Access

The UK's most regular instructor-led training courses.
Training information: microsoft+access+course · Courses in microsoft access · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

Access

M. has attended:
Access Intermediate course

by - delegate M. [1 post] (2008 May 13 Tue, 16:29) Reply

Is there any great difference between Access 2000 and 2003?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	3	book now	£210	£215
2002/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
2002/XP	2008 Sep 24 Wed	Tooting	0	FULL
2003	2008 Oct 7 Tue	Southwark	6	book now	£193	£215
Full Schedule: See all 72 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Access

by - trainer Pete platinum contributer [799 posts] (2008 May 27 Tue, 13:16) Reply

Hi M
The biggest difference between 2000 and 2003 is that 2003 supports Pivot Tables which 2000 does not have. I hope that helps regards Pete

· Why a Microsoft Access Course Could Change the Way You Do Business
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Access VBA Training Adds Power to your Databases
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· How Reorganising Your Data Can Take Your Business to the Next Level

Please browse our web site to find out more about
microsoft+access+course and other Microsoft training courses.

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