Step 11: Create Queries - Customers Purchase

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 tableto add it to the query design grid.

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

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

7. Save the Query

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

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