Working with databases/Database queries/Assessment

Complete the database
Now you can finish creating the database you started developing in Unit 2.


 * 1) Create a query that lists records of inventory with a selling price of $20.00 or less. Use only the following fields in your query:
 * 2) *Description
 * 3) *Selling Price
 * 4) *Units on Hand
 * 5) Save the query with an appropriate name.
 * 6) Print one copy.
 * 7) Create a query that lists all records of inventory from the supplier Beverage Holders that have more than 10 units on hand. Use only the following fields in your query:
 * 8) *Description
 * 9) *Selling Price
 * 10) *Units on Hand
 * 11) Save the query with an appropriate name.
 * 12) Print one copy.

Before you submit your work

 * 1) Check: compare the entered data with the original data source to check its accuracy.
 * 2) Check: has your database meet the requirements of the brief?
 * 3) Check: evaluate your database using this checklist:
 * 4) *Data entry is accurate.
 * 5) *All data is present
 * 6) *The data is clear and easy to read and the data is formatted appropriately
 * 7) *The first two table printouts have been sorted correctly.
 * 8) *Query tables accurately show information required.
 * 9) *The database meets the purpose identified in the plan.