Step 12: Create Queries - City Jengka

1. Single click Customers table

2. Click on the Create tab in the Ribbon.

3. Click on Query Design in the Queries group.

4. Double-click the Manufacturers table and Customers table to add it to the query design grid.

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

6. Add customer’s ID and name, city, price/unit, manufacturer’s name, city and discount available availableto the Query

7. Save the Query

• Name the query City_JGKA 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 "JGKA" (including quotes). This ensures the query will only include records where the city is JGKA.

8. 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 City_JGKA. at Queries

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

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