Beginning Access Objectives

In this lesson, you will learn how to:

1. Create a Query in Design View and use the Show Table command to add a Record Source.

2. Add Fields to the QBE Grid.

3. Create a Field that combines (Concatenates) two or more Fields together.

4. Create a Parameter Query that prompts the User to enter more information when the Query runs.

Menu Map

Lesson 8 : More Questions, More Queries


Query Tools->Design
Menu Map

Menu Maps

From the Create Ribbon.

1. Create ->Queries-> Query Design, page 184


From the Query Tools->Design Ribbon.

2. Query Tools->Design->Show Table, page 184

3. Query Tools ->Design->Results->Run, page 187