|
Objective:
To create reports with totals.
Assignment:
 | Using MS
Access to create reports for your database.
|
|
Add summary statistics (totals, counts, minimums, maximums)
|
| Follow procedure to upload your MDB and post
summary on Message Board.
|
|
Review the reports of classmates and post suggestions
|
| Follow
procedure to read about, download and critique the queries of class members.
|
| Respond to your critiques.
|
Details:
Learn about Access reports
| read about reports in an
Access book
|
| use online MS Access help:
 | type "Reports Overview" into Answer
Wizard,
|
| select "Reports: What they are and how they work",
|
| study 3
screen pictures,
|
| type "Create a Report" into Answer Wizard
|
| chose "wizard", read some screens
|
| chose "create your own", read some screens
|
|
Be sure to document by giving descriptions to each Report (right click on
their names in database object view)
Procedure:
- Create 2 or more reports per details above
- Post your database MDB file in your virtual
disk drive.
- Post a summary on the Bulletin Board
signaling that your work is ready to be
reviewed.
- Check if your classmates have posted a Reports
on their Database
| If so download them
|
| Review them
Modify the reports to improve them and upload the MDB to your virtual
disk
|
| Post suggestions on the Bulletin Board
|
| Imitate good ideas in your forms
|
Look for suggestions to your Reports
| incorporate suggestions into your design and upload to
your virtual
disk drive again
then note improvement on the Bulletin Board or
|
| post reasons you think suggestions won't work
|
Continue to do step 4 and 5.
|
