1.41 Tech Tool: Database Software Software Video: Database Tables 1. Select an authentic enterprise of your choice. Using Microsoft Access database software, develop a CUSTOMER table for the enterprise, identifying the appropriate fields.

2. Using Microsoft Access, select the primary key for the CUSTOMER table.

3. Populate the CUSTOMER table by entering test data for at least three customers.

4. What customer reports would the enterprise need to create? Would the database table you created be able to provide the information required?

1.42 (Continuation of TIP 1.41)

Tech Tool: Database Software Software Video: Database Tables 1. Using Microsoft Access database software and information from the prior exercise, create an ORDER table, identifying the appropriate fields.
2. Using Microsoft Access, select the primary key for the ORDER table.
3. Populate the ORDER table by entering test data for three orders.
4. What queries can you envision that the enterprise might need that would use information from both the CUSTOMER table and the ORDER table?