Access Worksheet on Lessons 1-8

You are the event manager for the Miami Arena, and need to build a database for your "Gulliver Club" patrons. Following is the key information for your customers.

Name Sally Wilson Peter Johnson William Longvue
Customer Acct # 127 868 1499
Address 117 Maple Road 1515 Fifth Avenue 12 Main Street
Apt 13
City, State, Zip Moon Township
FL 33108		 Miami, FL 31570 Atoona, PA 16601
Phone 407-262-5555 305-379-5555 814-862-5555
Credit Card # 4234-1232-1232 5953-1111-1127 343-1272-86709
Expiration Date 2/99 1/00 3/97
Seats A31-3-4 B171-4 B5-3-6
Amount Owed $750 $1000 $1250
Amount Paid $750 $0 $600
Customer Since 1/1/94 5/4/97 12/4/95

Build a database for the above information:

  1. Create an MSAccess 97 Database called GULLCLUB, and a table called CUSTOMERS, ensure that you build the appropriate number of fields, and that you size the attributes appropriately
  2. Create an Input Mask for the phone number field
  3. Once the file is built add the three records shown above
  4. Add yourself as a 4th customer
  5. Create an Autoform in "Columnar" format
  6. In design view, change Sally Wilson's credit card # to 4734-1232-1732
  7. Print the autoform
  8. Create a Tabular Autoreport for the above table
  9. Create a report header titled "Gulliver Club Members"
  10. Add a second text label in the report header with your initials
  11. Print your autoreport
  12. Create name tags for the above customers
  13. Create mailing labels for the above customers
  14. Print your name tags
  15. Print your mailing labels