Working with databases/Database queries/Assessment

Working with Databases

Basic skills applicable to planning, creating and using an Access database.
An OP Online course from the National Certificate in Computing (Level 2) programme.

About this course  |  Getting started  |  Course schedule  |  Assessment overview  |  Help

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.