Devry BIS245 Week 6 iLab Creating Reports

BIS 245 Week
6 iLab Creating Reports
BIS245 Database Essentials for Business with Lab
A. Lab # BSBA
BIS245A-6
B.
Lab 6 of 7 : Creating Reports
C.
Lab Overview – Scenario / Summary:
TCO(s): 7. Given a database application with a completed
relational schema, populated tables, and business reporting requirements,
create the necessary reports and make a business decision.
Scenario: The purpose of this lab is to create Access Reports. After a
report is created, the student will sort the fields in different ways. Also the
Student can also delete fields in layout view and modify the appearance of the
report by applying Themes. In addition to the report generated by Access, the
lab also uses Report Design to allow users to design their own reports. Upon
completing this lab, you should be able to:
• Create a report and apply a theme for professional appearance of the report.
• Use Report Design to generate your own report.
D.
Deliverables:Upload the
modified Lab6_Start.accdb file that you saved as YourName_Lab6.accdb to the
Week 6 iLab Dropbox.
Part A Step 1:
Create a Simple Report – Lab6_Report1
Part
A Step 2: Create a report using Report Design – Lab6_Report2
Part
A Step 3: Creating Multi-table Reports – Lab6_Report3
Part
A Step 4: Adding a Subreport – Lab6_Report4
Part
A Step 5: Create Mailing Labels – Lab6_Report5
Part
B Step 1: Create a Report – Lab6_Report6
Part
B Step 2: Create a Multi-table Report – Lab6_Report7