Question
Enhanced Microsoft Access 2013 Creating Reports and Forms Part-3 Total Points = 100 Purpose: To demonstrate the ability to create reports and forms. Problem: Your
Enhanced Microsoft Access 2013
Creating Reports and Forms
Part-3
Total Points = 100
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 Part-1 GetItNow_Electronics database file, 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started