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