WORK IN PROGRESS Import the Toys data fileDownload the file (DB 4 Toys Import File - Data.csv) attached to this page.
The file looks like: Supplier,Buyer,Description,Order Qty,On Hand,Cost,Brand,Order Date Fun Factory,A. Hayes,Model Cessna,50,7,$8.99,Flying Fun,"July 2, 2014" Fun Factory,A. Hayes,Model Satellite,65,12,$5.50,Flying Fun,"June 5, 2014" Fun Factory,A. Hayes,Fortran Learner,50,32,$3.99,Computer Fun,"July 3, 2014" |
Create a new Fusion Table by importing the .csv file from your computer. Add Calculated FieldsAfter you have imported the data into the database program, add the required calculated fields: - value of inventory on hand
- Qty to Order
- if('On Hand' < 10, 'Order Qty',0)
Perform Queries- All A. Hayes purchases in July
- All toys with a quantity on hand of over 30 and a unit cost of less than $5.00
- All toys purchased from Toy Barn with a unit price between $4.99 and $16.00
- All toys not purchased by J. Mathers or not supplied by Toy Barn or over $8.00
Create a report that shows the value of inventory on hand by supplier and Brand, include a subtotal for each supplier, each Brand and an overall total. |
 Updating...
M. A. Vandepoele, 4 Jun 2014, 18:09
|