(Continuation of TE 2.27)
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.
TE 2.27:
Tech Tool: Database Software
Software Videos: Database Tables, Database Table Relationships
EspressoCoffee asked for your assistance in building database tables to record sales transactions.
1. Using Microsoft Access database software and information in Figure 2.21, build the following database tables. Identify the primary key for each table.
■ CUSTOMER table
■ SALES ORDER table
■ SALES ORDER LINE table
■ ITEM table
FIGURE 2.21
MS Access Sales Transaction Database Tables for EspressoCoffee
Can you imagine what the diagram of all the database tables for the entire accounting system looks like, instead of only four tables?
2. Identify the table relationships between the CUSTOMER, SALES ORDER, SALES ORDER LINE, and ITEM tables. Use database software to create the database table relationships.
3. Print the table relationships.
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.