Access 2003-07

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

Resolved · Low Priority · Version 2003

3 posts

ReplyMon 1 Jun 2009, 16:38Delegate James said...

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

Access 2003-07

What are the major functional differences between 03 and 07 versions?

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	6		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

648 posts

ReplyTue 2 Jun 2009, 09:23Trainer Simon said...

RE: Access 2003-07

Hi James,

Thank you for your question.

There are a few differences:

1. Improved templates
2. Improved Datasheet view
3. New layout view
4. Ribbon layout instead of toolbar
5. Object Tabs
6. Navigation Pane
7. New Data Types and controls

I hope this answers your question.

Regards

Simon

Mon 8 Jun 2009: Automatically marked as resolved.

· MS Access and Database Normalisation
· Microsoft Access: Unleash the True Potential Today
· MS Access: Access your Personal Information with Ease
· Microsoft Access 2007: New Features
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps

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

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