1.38 Tech Tool: Database Software Software Video: Database Tables EspressoCoffee has given you an assignment to create a database table for tracking customer information.

1. Using Microsoft Access database software and the following fields, create a CUSTOMER table for EspressoCoffee.

Customer No.

Last Name First Name Company Name Street Address City State ZIP Country Email Address Web Site 2. Using Microsoft Access, select the primary key for the CUSTOMER table.

3. Populate the CUSTOMER table by entering the following customer information.

Customer No.: 127127 Name: Angela Ashuer Address: 13 Joseph Ave, Appleton, WI, 54911, USA Email: ang@gmail.com Customer No.: 913691 Name: Vincent Pico, EspressoBar Address: 58 Dante, Pisa, Tuscany, 56100, Italy Email: vpico@yahoo.com Web site: espressobar.it Customer No.: 127000 Name: Becky Cornell Address: 1203 N Lake Shore Drive, Chicago, IL 60610, USA Customer No.: 1958361 Name: David Kolse, Creamy Coffee Address: 702 Ensenada Street, Orlando, FL 32825, USA Email: creamycoffee@flash.net Web site: creamycoffee.com Customer No.: 532700 Name: Fred Olhman, Coffee Shoppe Address: 7011 Second Street, San Francisco, CA 94102, USA Email: coffeeshoppe@gmail.com Web site: coffeeshoppe.com