Just going through the motions

Resolved · Low Priority · Version 2003

Thu 19 Jun 2008, 16:57 Delegate Jari said...

Jari has attended:
Access Introduction course
Access Intermediate course

Just going through the motions

What is you most regular question?

Mon 23 Jun 2008, 09:41 Trainer Rich said...

RE: Just going through the motions

Hi Jari,

I'm not 100% sure.

For Excel it is usually something to do with VLookups. For Powerpoint it's usually about inserting movies. VBA courses entail a few questions about specific bits of code, or how to set up automatic e-mailing.

We look forward to answering any questions you may have about Access.

Regards, Rich

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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