Microsoft Access Training

Resolved · Urgent Priority · Version 2003

Thu 11 Dec 2008, 11:14 Delegate Mary said...

Mary has attended:
Access Introduction course
Access Intermediate course
Excel Advanced course

Microsoft Access Training

I've just completed the Access 2007 Introduction and I'm looking to attend the intermediate course this month. On checking your training schedule there is no more Access 2007 course scheduled for this month. Is it advisable for me to attend the Access 2003 intermediate instead or is it better to wait till January for the 2007 Inremediate course?

Thu 11 Dec 2008, 16:52 Trainer Amanda said...

RE: Microsoft Access Training

Hello Mary

Thank you for your qustion.

I would advise attending an Access 2007 Intermediate course so best to wait until January.

Kind regards
Amanda McKee
Trainer & Microsoft Office Specialist

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Microsoft Access Training

Microsoft Access Training

RE: Microsoft Access Training

Access articles

Access tip:

Deleting duplicate records from a table