Access Assignment 5: Creating a custom Report
Learning Objective
The assignment teaches how to create well designed custom reports. This will remove any magic from the
process of using report wizards and will strengthen your understanding of how to
arrange data for printing.
Deliverable
This assignment builds on the work you did for the Access
2 assignment, so it will extend and revise your MovinOn.mdb database.
The Access 3, Access
4, and Access 5 assignments are independent.
Thus, you can complete them in any order. For example, you might complete
Access 4 assignment without completing the
Access 3 assignment -- but that wouldn't be my
recommended approach. All three assignments are similar in nature in that they
each ask you to add more objects to your MovinOn.mdb database.
Training Exercises
I recommend that you start by working through these activities as a training
exercise:
- Steps to Success: Level 1 on pages 385-387. This will ask
you to open the Hudson.mdb database and build some simple reports inside it.
- To complete Step 2 on page 386, you can use this link to retrieve
the
HudsonBay.jpg image.
- If you skipped the exercises in the last chapter, I recommend
beginning with this
Hudson4-2.mdb file. Note: the link in the previous sentence
won't work if you are off campus or if you are using Monzilla FireFox as
your browser.
- Steps To Success: Level 2 on pages 407-408. Once again,
you will open the Hudson.mdb database, and you will create a couple of more
advanced reports in it.
- Note: If you complete this Level 2 training exercise
successfully, you should end up with a database similar to this
Hudson5-2.mdb file.
Note: the link in the previous sentence won't
work if you are off campus or if you are using Monzilla FireFox as your
browser.
If you skip the exercises described above, expect the actual assignment to be
confusing. Also, when it comes time to show me your skills on an exam, know that
you will have a lot less practice and understanding about what to do.
Ultimately, the choice of how much practice you need is up to you.
Assignment Specifications
Individual Assignment
- This is an individual assignment (not a team assignment). Please
ensure that you address all of the system requirements described in the review
assignment and instructions provided below. If you would like to be creative
and enhance your assignment beyond the listed requirements, you may do so.
However, make sure that you satisfy the requirements of the assignment, since
your work will be evaluated based on those requirements.
- Note: The code for academic honesty applies. All students
are expected to work through this assignment personally with their own set
of fingers. Copying all or a portion of a file from a classmate and
submitting it as your own work will be treated as a violation of OSU's code of
academic honesty.
-
Please pay attention to the specifications of the
assignment. In a multi-developer environment, even the seemingly minor
deviations from these specifications may have profound impacts. If you
spell the name of a report incorrectly, another application that links to
the correctly spelled report may crash. Let me put this another way: if your
reports are named incorrectly, we may not find them when we grade your work,
and you may not get any credit for creating them.
Instructions
For this assignment, you are to complete steps 1, 2, and 4 of Case 2--Creating Financial
Reports for MovinOn Inc. on pages 431-432 of the textbook.
- In Step 1, open the MovinOn.mdb database that you created in the Access
2 assignment and extended in the Access 3 assignment.. It should be in your
P:\classwork\ba271\access folder rather than in a "Case2" folder as the
printed instructions suggest.
- Do your best to follow Step 2.
- Feel free to skip Step 3.
- You can use
this
link to retrieve the MovinOn-logo.jpg file.
- In Step 4, your rptJobRevenue should look at least as good as the
following image:
I suggest calculating the three right-hand columns as:
- Job Income as ($.70/mile times Mileage) plus ($.20/pound times
Weight).
- Driver Pay as (Mileage Rate times Mileage) plus $50.00.
- Net Income as Job Income minus Driver Pay.
Feel free to skip steps 5 and 6.
Final Step: Test that you have turned in the assignment correctly
Make sure your work is in the proper location for grading. To do this, click
on your name in this Access listing.
|
