Revised: April 12, 2000
Due: April 11, 2000Approach Exercise
1. Create an Approach database. Save it with the file name customer. The database should contain the following information:
Bill Pegram, 815 South 18th, #400, Arlington, VA 22202, 703-486-0952, wpegram@erols.com
Bob Pegram, 1821 Rhode Island Avenue North, Golden Valley, MN 55427, 612-544-5390 MARY.JOSEFSON@prodigy.net
Rebecca Williams, 815 South 18th, #402, Arlington, VA 22202, RebeccaEWilliams@compuserve.comYou should create fields so that first name, last name, address, city, state, zip, phone number or email address information can be retrieved easily. Assign each individual a customer number. (20 points)
2. Create a find (query) that finds all people in the database who live in Minnesota (MN). (10 points)
3. Create a find (query) that finds all people in the database who live in Minnesota (MN) or whose first name is Rebecca. (10 points)
4. Create a form for entry of additional data. Add yourself to the database. (20 points)
5. Create a report to print out the data. All the fields for a record should be on one page if possible (Hint: use the standard report if the columnar report spills onto another page). (10 points)
6. Create another Approach database. Save it with the file name purchases. The database should contain the following information. Use the customer numbers from step 1 rather than the person's name. The database should have two fields: customer ID and purchase. Create a new record for each purchase (food item) for each individual. (10 points)
Bill's purchases: bananas, apples, milk, yogurt, pork chops, Pepsi, Diet Mt. Dew
Bob's purchases: pizza, Mountain Dew
Rebecca's purchases: Potato bread, pizza, Pillsbury chocolate chip cookie dough7. Join the two databases together.
8. Create a find (query) to identify the names of those people who bought pizza. (20 points)
Submit a floppy that contains the two databases.