Question

Download the Excel file Ch04_FruitStand, and import the two worksheets, labeled Customers and Purchases. Identify the Customer ID as the primary key for Customers, and Purchase Number fields as the primary key for Purchases, rather than letting Access create its own primary keys.
a. What fields are contained in the Customers table? Generate a list of all your customers, sorted by Customer ID.
b. What fields are contained in the Purchases table? What are the foreign key(s) in the Purchases table, and which table(s) do they reference?



$1.99
Sales1
Views90
Comments0
  • CreatedJanuary 03, 2015
  • Files Included
Post your question
5000