|
|
|
Filtering is a method of retrieving the records that meet certain criteria. There are different methods of filtering. Open the database you want to work with. Make sure you are in Datasheet View / Tables. It is easier to see the entire database and all the retrieved records. Open the table
Select Advanced Filter / Sort
1. The table fields will display in a scroll down list 2. The criteria fields for sorting the table From the Customers' Table select the sorting fields you want to include in the query From the drop down list, double click the fields in the tables
Determine the Sorting options
Type in the searching Criteria: quotation marks are automatically added
Click Apply Filter icon Records that meet the criteria will display with all the columns and data that is included in the record.
If this is a query that you run periodically, save the settings for future use. Click the Save Query icon A pop-up screen will open
Give the Query a name:
As you will have many queries in your table, make sure the Query Name is one that describes the contents of the search You have just created your first Query Close the table You will be returned to the primary Access database screen Click Queries Notice that the list for Customers from Berlin Ger and London UK appears in the list.
Opening a Saved Query The next time you want to run this query against data in the table Click the Load from Query icon A pop-up screen will ask you to select the filter you want to open
OK
Click Apply Filter icon Records that meet the criteria will display with all the columns and data that is included in the record. Do you want to print a quick list? Click Edit Reminder: Many of the database lists must be printed on landscape orientation Click Edit
Click Page Setup… Click File Because this tutorial is a query, it is possible to print a report from the selected data. A tutorial will be designed to walk you through the process. May 21, 2008 Sr. Arlene Callahan |
is a new feature in Access 2000
