Document Name: Beaver Mountain Customer Database (BMCUSTDB)

Software: Database

Comments:

At Beaver Mountain Bike Tours we need a database set up so we can keep track of the costumers we have signed up for bike tours. Set up a database and enter the following cards into the database. Later on we will have you generate some reports from your database.

Information:

Use the registration cards to set up your database and enter the information. The first card is for you to fill out about yourself. We want you to experience one of the trail rides. The company will pay your $350 fee.

Instructions:

1. Load your database software.
2. Decide on the fields needed, their length, and the data type.
3. Create a new table using the fields you have decided on.
4. Enter the data.
5. Proofread, save, and print it in table form.
6. Sort the database by last name and print it in table form.

Name: Your First & Last Name
Address: Your Street Address
City: Your City, State Zip
Phone: XXX-XXX-XXXX
Tour Date: 6/5/XX Fee Paid: $350

Name: Ben Lovell
Address: 349 Maple Street
City: Roosevelt, UT 84066
Phone: 435-722-4986
Tour Date: 7/8/XX Fee Paid: $300

Name: Michael Begay
Address: 35th Road, 9320
City: Kirtland, NM, 87417
Phone: 505-598-6394
Tour Date: 7/17/XX Fee Paid: $300

Name: Yuko Honda
Address: 493 Van Nuys Avenue
City: San Francisco, CA 94123
Phone: 213-262-9061
Tour Date: 8/10/XX Fee Paid: $650

Name: Karl Measer
Address: 431 East 200 North
City: Provo, UT 84601
Phone: 801-373-9360
Tour Date: 6/18/XX Fee Paid: $600

Name: Marlin Anderson
Address: 5333 27 Street
City: Taber, AB T0K 2G0
Phone: 403-223-6439
Tour Date: 7/24/XX Fee Paid: $650

Name: Selene Almonza
Address: 372 Los Lovatos Road
City: Santa Fe, NM 87501
Phone: 505-438-9762
Tour Date: 6/3/XX Fee Paid: $50

Name: Joseph Nye
Address: 4860 N Jones Road
City: Sutherland, UT 84624
Phone: 435-864-7382
Tour Date: 7/13/XX Fee Paid: $450

Name: Mary Hales
Address: 4346 Avenue E.
City: Ely, NV 89301
Phone: 702-289-7342
Tour Date: 7/15/XX Fee Paid: $650

Name: Darryl Henrie
Address: 732 East 400 North
City: Panguitch, UT 84759
Phone: 435-676-5732
Tour Date: 6/21/XX Fee Paid: $50