Jan's Working with Databases

Exercise Access 3-4: On Your Own

---

What you will do:

Create your own database

---

Start with:   Access open

Choose a real-life situation or invent one. Your database must be significantly different from the examples, projects, and exercises in these lessons! You cannot just replace the data while keeping the design.

Suggestions for type of database:

• club members with addresses, phone numbers, dues paid or not, with separate tables listing the club offices and listing who held which office for which term
• records of a science fair experiment
• sales of several products with tables for products and salespersons as well as orders
• 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 with a separate table for types of events and for sponsors
• customers and their orders with separate tables for customers, products, and orders
• software and hardware installed on your computer with registration number or model and serial numbers, date bought, date installed, with separate tables for problems addressed and the results and for manufacturer/publisher info like company name and address, tech support phone number and email, company web address,
• companies to which you have applied for a job with addresses, phone numbers, contact person, using a separate table for the job applied for with its details like salary and responsibilities, current status, results. You might apply for more than one position at the same company.
• courses taken with data on semester or dates, instructor, name of course, school, details of course content, final grade, cost, with separate tables for the instructors and schools. You might take more than one course from the same instructor. You might take courses at more than one school.

Required Parts:

• Create your own database which includes at least 3 related tables. The main table must have at least 8 records.
• Change some of the field properties from the defaults to more useful values.
• Make at least one field a Lookup field.
• Include at least one field with a validation rule and validation text.
• Create several queries which include:
  • criteria and sorting
  • a calculated text field
  • calculated field using a conditional expression (IIf)
  • parameter query
  • action query
  • Totals query
  • Crosstab query
• Document your database by printing:
  • relationships
  • datasheet for a table
  • Documenter report for a table and for a query
  • Object Dependencies screen shot for a object that has dependencies.
  • Export a datasheet as a text file and print the file from Notepad. Include your name and "Ex. Access 3-4" in the header