access database training - Easy way of creating a pivot table

Resolved · Low Priority · Version Standard

Wed 28 Feb 2007, 09:53 Delegate Simon said...

Simon has attended:
Access Intermediate course
Access Advanced course

Easy way of creating a pivot table

Is there an easy way of creating a pivot table

Mon 5 Mar 2007, 16:33 Trainer Carlos said...

RE: easy way of creating a pivot table

In Access

Open the table in Datasheet view

Open the View menu and select Pivot Table View

Move the required fields to the correct sections

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