Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft/access/training/courses - Access

microsoft/access/training/courses - Access

ResolvedVersion Standard

Mon 23 Apr 2007, 09:43 Delegate Jane said...

Jane has attended:
Access Introduction course

Access

How do I filter records using the toolbar options

Mon 23 Apr 2007, 10:12 Trainer Richard said...

RE: Access

Jane, You can filter in two ways.

There is a section of filter commands on the toolbar when you are in datasheet view.

BY SELECTION
Simply highlight the text you would like to filter by, and then choose the FILTER BY SELECTION toolbar icon.

BY FORM
When you click on this icon, then a form will appear where you can enter the search criteria. Clicking the filter button will then apply the filter.

ON/OFF
The plain filter button switches the filter you have created on and off.

Regards

Richard

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

microsoft/access/training/courses - Access

Access

RE: Access

Access articles

Access tip:

Random sampling