- Click OK .
MS Access - Lesson 10: Querying the database Picture 2 - Select the fields you want to have in each table by selecting the field and clicking the button
MS Access - Lesson 10: Querying the database Picture 3
- To select fields from different tables, click on the Table / Queries down arrow
- Click Next.
MS Access - Lesson 10: Querying the database Picture 4 Complete Query wizard
- Enter a name for the query
- Click Finish . MS Access - Lesson 10: Querying the database Picture 5
- The retrieval results will still display as follows:
MS Access - Lesson 10: Querying the database Picture 6 To switch between tables and queries:
- Open Navigation Pane
- Double click on the table name or query to view.
MS Access - Lesson 10: Querying the database Picture 7 Query design feature
You can design a query with the Query Design button. To design a query using Query Design:
- Click the Query Design button on the Create tab.
MS Access - Lesson 10: Querying the database Picture 8 - The Show Table dialog box appears allowing you to select the table
- Click Add to add the table and click the Close button to close the Show Table dialog box
MS Access - Lesson 10: Querying the database Picture 9 - Double click on the field name you want it to appear in the design grid
- Repeat the above steps for other schools
MS Access - Lesson 10: Querying the database Picture 10 - Click the Run button to execute the query.
MS Access - Lesson 10: Querying the database Picture 11 Query design with conditions
The query standard is the search for the conditions used in the query to retrieve data. You can set the standard as a specific number or data string, or data range. 'value' Only displays the record that matches the correct value (replace the word value with the word you want to find) = Equal Greater than> = Greater than or equal to <> Different Between X And Y In a range (get the value between X and Y) Is Null Null value And Only true if condition exists Or True if either condition exists Not True if 1 case is incorrect
To facilitate query:
- Click on the query you want to add conditions
- Enter the query condition for in the Criteria section
MS Access - Lesson 10: Querying the database Picture 12 - Then click the Run button to execute the query.