The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 57 Weeks Ago |
| Questions Answered: | 7570 |
| Tutorials Posted: | 7352 |
BS,MBA, PHD
Adelphi University/Devry
Apr-2000 - Mar-2005
HOD ,Professor
Adelphi University
Sep-2007 - Apr-2017
A. Lab BSBA BIS245A-6
B. Lab 6 of 7: Creating Reports
C. Lab Overview—Scenario/Summary
CO(s):
7. Given a database application with a completed relational schema, populated tables,and business reporting requirements, create the necessary reports and make abusiness decision.
Scenario:
The purpose of this lab is to create Access reports. After a report is created, the student willsort the fields in different ways. Also, the student can also delete fields in layout view andmodify the appearance of the report by applying themes. In addition to the report generatedby 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; and
• 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 theWeek 6 Lab Assignment.
|
Section |
Deliverable |
Points |
|
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 Multitable 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 Multitable Report—Lab6_Report7 |
|
E. Lab Steps:
Preparation:
1. Download the Access starter filefrom the Week 6 Lab page and save the file to your local drive.You will want to download it using Chrome, as it does not open correctly using Edge or Explorer.
2. Using Citrix for MS Visio and/or MS Access
a. If you are using the Citrix remote lab, follow the login instructions located in theLab area in Introduction and Resources.
b. You will have to upload the “Lab6_Start.accdb” file to your Citrix folder. Follow theinstructions located on the Lab area in Introduction and Resources.
3. Start MS Access:
a. If you are using Citrix, click on Microsoft Office Applications folder.
b. If you are using Visio on a local computer, select Microsoft Office from your Program Menu.
Lab:
Attachments:
BIS----------- 24-----------5 W-----------eek----------- 6 -----------Lab-----------