Types

• Select queries retrieve records using criteria that all the records have in common, such as the same last name or customer number. Parameter queries retrieve records based on information supplied by the user when the query is run. Queries in Access can retrieve data from a single table or from multiple tables linked together.
  
  

Features

• You create Access queries in Query Design View or with the Query Wizard, which supplies a series of prompts and choices to automate the process. Not all features are available in the Query Wizard, so using Query Design View is a better choice if you want to tailor a query to your specific needs.
  
  

Considerations

• Access creates code in the SQL language for all queries, whether you wrote the query in Query Design View or with the Query Wizard. Access executes the SQL code when you run the query. You can use the SQL View feature in Access to write your own SQL queries.
  
  

Fun Fact

• Access can also use queries to change, delete or add records to a table or to create an entirely new table.