access vs

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2003 vs 1997

Access 2003 vs 1997

resolvedResolved · Low Priority · Version 2003

Chris has attended:
Access Introduction course

Access 2003 vs 1997

What are the key differences between Access 2003 and 1997 from the point of view of someone who has just taken the introductory course (ie not concerned with macros)

Edited on Fri 27 Feb 2009, 15:34

RE: Access 2003 vs 1997

Hi Chris

Do you mean 2007?

The main difference between 2003 and 2007 Access is the way it appears on the screen and the fact that the commands are now on a ribbon.

The way tables, queries, forms and reports are built is the same. So once you get used to the appearance of 2007 and find where the buttons are on the ribbon you should have no problem.

You can dowload an Access 2003 to Access 2007 interactive command reference guide from Microsoft to help you find known commands on the new ribbon:

http://www.microsoft.com/downloads/details.aspx?FamilyId=B9574C72-657F-438C-9DE9-F8F70DD2D40D& ;displaylang=en

If you meant 1997 then there are some features in 2003 that didn't exist in 1997 but the general make up is pretty similar.

Hope this helps

Carlos

Thu 5 Mar 2009: Automatically marked as resolved.


 

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips


Server loaded in 0.08 secs.