Add a Field

This Select Query shows three Fields from tblMovies: MovieID, Year and Movie. Say you wanted to Add a Field. Here are the steps to add the Rating Field.

 

1. Try it: Add a Field

MovieSQ is open in Design View.
Go to tblMovies.

Double-click a Field: Rating.

 

What Do You See? The Rating Field has been added to QBE Grid.

 

Keep going...

Query Tools ->Design

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Add Fields to a Query