Create A Query

• 1). Open your Access database and click on the "Queries" icon in the pop-up window.
  
  
• 2). Double-click on the "Create Query by Using Wizard" option.
  
  
• 3). Click on the name of the table in the "Tables/Queries" drop-down list that contains the information fields you want in your query.
  
  
• 4). Select a field name in the "Available Fields" list and click "Add" to move it into the "Selected Fields" section. Add as many fields as you need, then click "Next."
  
  
• 5). Type a title for your query in the "What title do you want for your query?" text box, then click "Finish" to view your results.
  
  

Add Fields to the Query

• 1). Click in the "Field" box in the first "field" column of the query grid. A drop-down arrow will then show up at the right end of the Field box you just clicked.
  
  
• 2). Click the drop-down arrow and scroll through the fields until you find the one you want, then select it.
  
  
• 3). Click in the second "field" column of the query grid and repeat the steps until you have added all of your desired fields to your query.
  
  

Add Criteria to the Query

• 1). Click the "Criteria" row in the desired "fields" column in the "Query Design" view.
  
  
• 2). Type in the criteria you wish to use for your query. There can be numerous criteria.
  
  
• 3). Repeat to add additional criteria to the field columns throughout your query.
  
  

Add Basic Value Functions to the Query

• 1). Click the "Totals" button located on the "Query Design" toolbar in the "Query Design" view. Notice that a "Total" row is then added to the query grid.
  
  
• 2). Click in the "Total" row in the query grid that contains numerical data information. A drop-down arrow will then appear in the right side of the box you clicked.
  
  
• 3). Click on the drop-down arrow and select the type of value function you wish to insert in the field's "Total" box.
  
  
• 4). Repeat to insert value functions as needed into other "Total" field columns.
  
  

View Query Results

• 1). Click the "Save" button in the "Query Design" toolbar.
  
  
• 2). Name your query and click "OK."
  
  
• 3). Click the "Run" button on the "Design Query" toolbar to view your query results in a format that resembles an Access datasheet.