Jan's Working with Databases

Exercise Database 4-4: On Your Own

---

What you will do:

Create a database of your own

---

You will create a database of your own which includes numbers for some kind of calculation. These might be prices or scores or whatever is useful to you.

Suggestions for type of database:

• club members with addresses, phone numbers, dues paid or not, club office held...
• records of a science fair experiment with measurements
• sales of several products by type or date or region or salesman...
• events scheduled at a theater or show ring with name of event, responsible person or organization, dates, times, fee, paid or not, description of event
• customers and their orders (requires 3 main tables)
• courses taken with data on semester or dates, instructor, name of course, school, details of course content, final grade, cost, average grades...

1. Create a new, blank database. Save it with the name ex4-Lastname-Firstname.accdb to your Class disk in the folder databases project4. (Use your own first and last names, of course!)
2. Create at least 3 related tables, using the method of your choice.
3. Create at least 1 query that uses fields from at least 2 tables.
4. Create at least 1 form to enter data into one of your tables.
5. Include a subform to show the related records from another table.
6. Add at least 10 records to your primary table and at least 4 related records for some of the records in the primary table.
7. Create a printable form and print one of the records.
8. Create a report that summarizes the data without showing anything in the Detail section.
9. Create a report that uses a subreport, either with each record or providing a summary in the report header or footer.
10. Create one of the special forms and reports: switchboard, custom dialog, labels report, chart report, report with multiple columns
11. Print all of your reports.
12. Print the Relationships.