Working with databases/Database queries/Assessment

From WikiEducator
Jump to: navigation, search
OtagoPoly Logo S.png




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:
    • Description
    • Selling Price
    • Units on Hand
  2. Save the query with an appropriate name.
  3. Print one copy.
  4. 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:
    • Description
    • Selling Price
    • Units on Hand
  5. Save the query with an appropriate name.
  6. 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:
    • Data entry is accurate.
    • All data is present
    • The data is clear and easy to read and the data is formatted appropriately
    • The first two table printouts have been sorted correctly.
    • Query tables accurately show information required.
    • The database meets the purpose identified in the plan.