Access Exercise

1. Create an Access database.  Save it with the file name food.  The database should contain a table named customer with the following information:

Bill Pegram, 815 South 18th, #400, Arlington, VA 22202.

Bob Pegram, 1821 Rhode Island Avenue North, Golden Valley, MN 55427

Rebecca Williams, 815 South 18th, #402, Arlington, VA 22202

You should create fields so that first name, last name, address, city, state, and zip can be retrieved easily.  Assign each individual a customer number. (2 points)

2. Create a query that finds all people in the database who live in Minnesota (MN). (1 point)

3. Create a query that finds all people in the database who live in Minnesota (MN) or whose first name is Rebecca. (1 point)

4. Create a purchases table in the food database.  The table should contain the following information.  Use the customer numbers from step 1 rather than the person's name.  The table should have two fields: customer ID and purchase.  Create a new record for each purchase (food item) for each individual. (1 point)

Bill's purchases: bananas, apples, milk
Bob's purchases: pizza, Mountain Dew
Rebecca's purchases: Potato bread, pizza, Pillsbury chocolate chip cookie dough

5. Create a query named pizza to display only the first and last names of those people who bought pizza. This will require you to join the two tables together (1 point) The last names should be displayed in alphabetical order (1 point)

Email the database to pegramite115@gmail.com