Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access training courses - Append Update query

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access training courses - Append Update query

Resolved · Low Priority · Version Standard

Reply Thu 21 Jun 2007, 17:02Delegate Jigna said...

Jigna has attended:
Access Intermediate course

Append Update query

Can I append and update data selectios at the same time? For example I would like to add data from one table and update a field so I can see what data was appended

For upcoming training course dates see: Pricing & availability

Reply Mon 2 Jul 2007, 10:43Trainer Carlos said...

RE: Append Update query

Hi Jigna

The best way to do this is to create an Update Query and run it on the table which contains the data to be appended.

Once the data is updated then run the Append Query.

If you need to do these two actions simultaneously then create a Macro which runs the two queries.

Regards

Carlos

Access articles

· Protect Sensitive Access Databases With A Password
· Practice Microsoft Access Database Decorum To Reap The Rewards
· How To Make Access 2010 Databases Compatible With Access 2007
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Access Corruption Avoidance Tip #3: Stay Connected

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips