Working with databases/Course Schedule

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

OP icon exclamation.gif

Please note

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