microsoft/access/training/courses - access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

microsoft/access/training/courses - Access

resolvedResolved · Low Priority · Version Standard

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

Jane has attended:
Access Introduction course

Access

How do I filter records using the toolbar options

For upcoming training course dates see: Pricing & availability

replyReply Mon 23 Apr 2007, 10:12Trainer 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

 

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard