Working with databases/Course Schedule
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.
|
If you haven't already done so, please read the section on Getting started as this section has important information to help you succeed. If you plan to complete the assessment tasks so you can get credit for Unit Standard 2786, please also read the material in the Assessment overview.
|
The course schedule below provides you with suggested timeframes for completing this course, based on around 30 hours in total. How long you spend on each section is up to you, so the suggested times below are just a guide.
Remember to take regular breaks, especially when working on a computer! You shouldn't try to complete any unit in one sitting.
| Unit | Overview | Topics |
|---|---|---|
| Unit 1: Database design |
Developing a database takes careful planning.
This section provides guidance on how to go about designing an effective database. Time: around 5 hours |
|
| Unit 2: Create a database |
This section provides detailed, step-by-step instructions for creating a database structure and entering data.
While the instructions are specifically tailored for Microsoft Access, the process is easily applicable to other software tools such as Open Office, which includes a free and open source database application. Time: around 15 hours |
|
| Unit 3: Database queries |
This section deals with how to use database features to manage information.
Time: around 10 hours |
