Download the Excel file Ch04_FruitStand, and import the two worksheets, labeled Customers and Purchases. Identify the Customer

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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: