Microsoft Access

Creating Reports and Forms

Purpose: To demonstrate the ability to create reports and forms.

Problem: Your supervisor at GetItNow Electronics wants you to create reports and forms combining data from the Outlets and Sales Rep tables using the techniques learned in Chapter 4.

Instructions: Using the Access_Chapter_4_-_Lab_Test_A_-_GetItNow_Electronics database file provided by your instructor, execute the following tasks:

1. Open the Sales Rep report. Group the report by Job Type and sort by Full Name within Job Type. Include totals for Quota and YTD Sales for each grouping. Save the report as Sales Rep Revised. The report should look similar to that shown in Figure A4A – 1.

2. Print the report.

3. Create the Sales Rep by Outlet report as shown in Figure A4A – 2. You will need to use both the Sales Rep and Outlets tables. Include a total for the YTD Sales field. Change the orientation to landscape. Make sure the total control displays completely. (Hint: Use Layout view to make this adjustment.).

4. Print the report.

5. Create the Sales Representatives form shown in Figure A4A – 3 for the Sales Rep table using the Form Wizard. Include the date in the form.

6. Print the form.

7. Submit the test according to the instructions provided by your instructor.

Figure A4A – 1

Figure A4A – 2

Figure A4A – 3

Page 1

© 2016 Cengage Learning®. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.