Query the Customer Table

This lesson creates a Select Query in Design View. The first step is to select a Record Source when you are prompted by a ShowTable window.


Before You Begin: All of the Tables, Forms and Queries are closed.


1. Try it: Create a Select Query
Go to
Create ->Queries-> Query Design.


What Do You See? A blank query will open. The Show Table window will prompt you to choose a Table or Query for the Record Source.


Select a Table: tblCustomers

Click Add.


Click Close. Keep going...

Create ->Queries-> Query Design

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.2. Manage source tables and relationships: Use Show/Table Command