Working with databases/Assessment overview/Brief

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

Assessment Brief

The scenario

After lengthy negotiations, your town now has a minor league baseball team. The team owners and the town government are vigorously promoting the benefits of the new team. As part of their marketing strategy, they are selling items with the new team logo.

The marketing team has asked you to create and update a database that they can use to keep track of their inventory and suppliers.

You will complete the project in three stages:

Part 1

Develop a database plan.

Part 2

Create the database.

Part 3

Use the database to solve a problem

Database specifications

The current inventory is shown in the table below:

Assessment overview