graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.1 Create a Query: Simple Query Wizard

Query: Detail or Summary

3. Try it: Choose Detail

The Detail option will return all of the Movies in tblMovies. The Summary option will give you choices on how you want to Group the Movies.

 

Select: Detail

Click Next.

Keep going...

 

Memo to Self: Sometimes the Query Wizard skips the option to select Detail or Summary:

It depends on the data. The Movies Table has several Fields (Year, Rating, Genre) that can be Grouped and Sorted.

Create ->Queries-> Query Wizard

graphic2