MS Access - Lesson 10: Querying the database

TipsMake.com - Query allows you to select and filter data from multiple tables. Queries can be saved and used anytime needed.

Query Wizard

Query Wizard will introduce each step to build a query. To execute a query using the Query Wizard:

- Click the Create tab

- Click the Query Wizard button
MS Access - Lesson 10: Querying the database Picture 1 - Select the type of query you want to execute

- 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.