Assignment 20

Volume I

ACCESS CHAPTER 3

Information from the Database: Reports and Queries

(Volume I, third chapter on the section with orange page number flags)

Warning: Be sure to save your work frequently and back up your work.

·       Do Knowledge Test K20 at the beginning of the class. Do Skill Test S20 “Access Chapter 3” toward the end of the class. Be sure to use S02 as the ID in the skill test.

1.   Read pages 102 to 107

2.   Do Hands-on Exercise 1: The Report Wizard, steps 1 to 9

a.   Step 6: Enter your name to the control Prepared by: instead of Gregg Kuehnel's.

b.   Step 9: Print the report, and hand in the printout as part of your assignment 20.

3.   Read pages 115 to 120

4.   Do Hands-on Exercise 2: Creating a Select Query, steps 1 to 8

a.   Step 7: Add your name. Before finishing up the report Wizard enter Undecided Major created by your name as the title of the report.

b.   Step 8: Print the report, and hand in the printout as part of your assignment 20.

5.   Read pages 127 to 129

6.   Do Hands-on Exercise 3: Grouping Records, steps 1 to 10

a.   Step 6: To the title GPA by Major add created by your name

b.   Step 10: Print the report, and hand in the printout as part of your assignment 20.

7.   Staple and turn in your printouts. Use this sheet as cover adding your section number, name and computer number.

FOR NEXT CLASS

REVIEW THE STUDY GUIDE FOR THE SECOND TEST

EXCEL &  ACCESS

BRING YOUR QUESTIONS and VOLUME I & II IF NEEDED