access/courses - Access

Resolved · Low Priority · Version Standard

Tue 6 Nov 2007, 15:44 Delegate Soran said...

Soran has attended:
Access Intermediate course
Word Advanced course
Excel Advanced course
Outlook Advanced course

Access

What is access is mostly used for?

Thu 8 Nov 2007, 15:44 Trainer David said...

RE: Access

Hi Soran

Microsoft Access is mostly used for creating relational database systems. This means that your database consists of many table which are related.

Some uses of Microsoft Access are:
A database for product orders
A membership system
An account system

Hope this helps
David

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