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: [email protected]
Customer No.: 913691
Name: Vincent Pico, EspressoBar
Address: 58 Dante, Pisa, Tuscany, 56100, Italy
Email: [email protected]
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: [email protected]
Web site: creamycoffee.com
Customer No.: 532700
Name: Fred Olhman, Coffee Shoppe
Address: 70.1.1 Second Street, San Francisco, CA 94102, USA
Email: [email protected]
Web site: coffeeshoppe.com
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.