Step 9: Create Queries - Customers from MRAN

1. Single click Customers table

2. Click on the Create tab in the Ribbon.

3. Click on Query Design in the Queries group.

4. Add the Customers Table to the Query

5. Double-click the Customers table to add it to the query design grid.

6.Close the Show Table dialog box after adding the table.

7. Add All Fields to the Query

7. Save the Query

• Name the query Customers_MRAN when prompted.
• Click OK to save the query with this name.

8. Specify the Criteria to Filter by City

• Set the Criteria for the City:
• In the query grid, find the City column (you might need to scroll right if it's not visible).
• In the Criteria row under the City column, type "MRAN" (including quotes). This ensures the query will only include records where the city is MRAN.

9. Run the Query to Verify the Results

• Run the Query:
• Click on the Run button (red exclamation mark) in the Design tab to execute the query and view the sorted records.

• Or Simply Double click Customers_MRAN at Queries

10. Save the Query

• After verifying that the records are sorted correctly, click on the Save button on the Quick Access Toolbar, or press Ctrl + S.

11. Close the Query

• Close the query by clicking the Close button (X) on the query tab or right-clicking the query tab and selecting Close.