How to Filter for a Record in the Data Access Page

Building an Access query allows you to retrieve just the information you need in real time. Once the query is in place, even non-technical users can find the data they want, without having to open the tables directly. You can make your Access queries even easier to use by building a filter into the query design.

• 1

  Log on to your computer and open the database you want to use.

• 2

  Click the "Create" tab and choose the "Query Design" icon. Use the "Show Table" window to select the table you want to base your query on. Click "Close" when you are done.

• 3

  Double-click each field you want to include in the table. Go to the "Criteria" section of the field you want to filter.

• 4

  Type "[Enter criteria]" in the criteria tab. Click "Save" on the quick access toolbar and type a name for the query.

• 5

  Close the query window by clicking the red X at the top right hand corner. Go to the navigation pane on the left side of the screen and double-click the new query.

• 6

  Enter the criteria you wish to use when prompted. Your results will be limited to records that match your criteria.