Query: Select a Record Source

2. Try it: Select a Record Source

Select a Table: tblMovies

 

What Do You See? There are six Fields Available in tblMovies on the left side.

 

You can use the arrows pointing left or right to move the Fields from the Available Fields on the left to the Selected Fields on the right.

 

Select these Available Fields:

MovieID

Movie

Year

 

Click Next. Keep going...

Create ->Queries-> Query Wizard

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Create a Select Query