Tech Tool:Database SoftwareSoftware Video:Database TablesThis is a continuation of the pre...

Tech Tool:Database Software

Software Video:Database Tables

This is a continuation of the previous exercise.

EspressoCoffee asked for your assistance in entering data into database tables to record sales transactions.

1. Using Microsoft Access database software and your database file from the previous exercise, enter the following customer information into the Customer table.

Customer No	Company Name	Last Name	First Name	Street Address	City	State	ZIP	Country	Account Balance
127127		Ashuer	Angela	13 Joseph Ave	Appleton	WI	54911	USA	$1080.00
913691	EspressoBar	Pico	Vincent	58 Dante	Pisa	Tuscany	43001	Italy	$530.00

---

2. Enter the following items into the ITEM table.

Item No	Item Name	Item Description
9XB	Espresso Machine Lux	Espresso Machine Lux Model 2009 all electronic
ARQ1	Pure Arabica	Pure Arabica from Colombia and Africa
ARXC	Arabica Colombian Mix	Arabica Colombian Mix - 60% Arabica, 40% Colombian
BB6-1	Espresso Machine Base	Espresso Machine Base Model 2001 with foam feature
WC1	Small Cups	Small Cups - White small espresso cups
WC2	Small Cup Lux	Small Cups Lux - White small espresso cups quality

---

3. Enter the following sales into the Sales Order table and the Sales Order Line table.

---

■ On December 5, 2012, customer Angela Ashuer places an order to buy the following items: a.(2) Item No. ARXC for $40 each

■ On December 22, 2012, customer Vincent Pico places an order to buy the following items:

a. (1) Item No. 9XB for $400 each

b. (12) Item No. WC1 for $15 each

4. Print the Customer, Sales Order, Sales Order Line, AND Item tables.