Tutorial Home > Software > Office > Microsoft Access 2000 > Querying the Database

Querying the Database
Queries are similar to filters in that they extract information based on criteria that you specify. One benefit of using a query over a filter is that you can save your settings and use the same query again. For example, if you often need to view records of customers in Ohio and Kentucky, you could create the query and save it. The next time you need this information, you can simply open the query and use it again. Saved queries are also handy for creating reports.

  Tutorials
  Add Tables to a Query
  Add Fields to a Query
  Edit a Query
  Add a Criteria to a Query
  Set Field Properties
  Using Operators in Queries
  Use AND Criteria
  Use OR Criteria
  Use NOT Criteria