Name: Basic Queries: Click "Create" in the menu ribbon, then click "Query Design" on the far right. Highlight each table that has data you want in the query and click the "Add" button. Drag the field (column names) from the tables to the grid below (or double click on them). Hit the exclamation point to run your query Example: Show the students and their class rank Queries with a condition (criteria) If you only want to see some of the data, that is, you don't want to see all the rows, enter your condition in the "criteria" row below the appropriate table name tam Show the students and their class rank, but only show students with a rank of 10 or less. Name: Basic Queries: Click "Create" in the menu ribbon, then click "Query Design" on the far right. Highlight each table that has data you want in the query and click the "Add" button. Drag the field (column names) from the tables to the grid below (or double click on them). Hit the exclamation point to run your query Example: Show the students and their class rank Queries with a condition (criteria) If you only want to see some of the data, that is, you don't want to see all the rows, enter your condition in the "criteria" row below the appropriate table name tam Show the students and their class rank, but only show students with a rank of 10 or less