1. Create a database named “Seller-Buyer” in Access 2007 2.
Create two tables named “Seller” and
“Buyer” by importing the corresponding two Text files 3. Assign primary keys and data types to field(s) in these two tables (if you haven’t done so when importing) 4. Establish a relationship between these two tables 5. Find out answers to the following questions by using queries: a. What is the total number of records where there is a letter “e” in the Seller’s Last Name AND there is a number “3” in his/her Buyer’s Phone Number? Make a table named “Table a” from this query result with the field caption “Phone Number” changed to “Buyer Phone Number” b. What is the longest time between the Pay Date and the Win Date for records where the Item Price is between 10 to 100 dollars OR where the Pay Date is null? Export this query result to an Excel file named “Query b”. c. What is the average Item Price for records where there is a letter “o” in the Seller ID? Seller.txt Seller ID Seller Last Name Seller First Name Buyer ID Item Price Win Date Pay Date Buyer.txt
Buyer ID Buyer Last Name Buyer First Name Phone Number Street City State Zip |