Still Before You Begin

The best place to start is to review the data. A Report is only as good as the information in the Table or Query.

 

1. Try it: Review the Query

Go to All Access Objects->Queries.

Select a Query: MovieSQ.

Go to Home->Views->View.

Select a View: Design View.

 

What Do You See? There are five Fields selected from tblMovies:

MovieID

Year

Movie

Rating

Genre

 

Keep going...

Home->Views->View->Design View

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields