Page 557 - Using MIS

Sum of Inventory Cost

Webster
Distribution
$106,221.09 Copper River
Manufacturing
$176,786.91
Team Supplies
$91,442.38

Illumination, Inc.
$134,519.75
Grant Sales
$322,449.79

Figure AE-3
Data Displayed in Pie-Chart
Format

(6) Format the appropriate data as currency.
(7) Select the range that contains the data, press the Function key, and proceed
from there to create the pie chart. Name the data and pie chart worksheets
appropriately.
b. Follow a similar procedure to create the bar chart shown in Figure AE-4. Again, your
data will be different. Place the data and the chart in separate worksheets and name
them appropriately.

AE5-2. Read Case Study 5 on pages 198–202. A copy of Dean’s database is stored in the
Access file Ch05Ex02_U8e.accdb. Download a copy of this file and create que-
ries to provide the following data:
a. Sort the pianos from high quality to low.
b. Sort the pianos from high quality to low and, within each quality, sort by Building
and then by Location within that building.
c. List the pianos in the shed and sort the results by manufacturer.

Inventory Cost by Category
$450,000
$400,000
$350,000
$300,000
$250,000
Cost $200,000

$150,000
$100,000
Figure AE-4 $50,000
Data Displayed in Bar-Chart $0
Format Accessories Clothing Furniture Linens

525