graphic2
graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.1 Create a Query: Select Query Design

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