2 Simple Ways To Create Access Database Queries
Access database queries let you extract or pull data from the database. They let you ask questions of your data and find results using various criteria methods with your queries. When creating the query, they can be compiled simply by adding fields from a table. You can get more elaborate by adding fields from related tables. You can also add expressions and SQL refinements to get the exact answers you are seeking from your query. Below are two ways to create queries in Access 2010:
The Query Wizard is located on the Create tab of your Access Database ribbon. When this button is selected, the wizard takes you through a series of steps to create an Access query. Use this wizard to select your tables and fields you want to see in your finalized query.
Query Design is located on the Create tab near the Query Wizard button. Use this to select tables and/or queries for your query. This graphical interface lets you see the fields in the tables and manually drag them to your query.