Working with databases/Create a database/Key points

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

Key Points

On completion of this unit, you will be able to: Manage tables in a flat-file database. Add the correct fields based on your plan. Choose the correct data-types for each field. Customise the field properties. Save and re-open your database. Add records to the table. Update records. Sort records in a table. Delete records.

If you are completing the assessment for this course, please continue to ensure you have completed the assessment activities for this unit.

Otherwise, please continue with the next unit, Database queries.

Acknowledgements

The content of this unit has been adapted from the Business Solutions workbook, developed by the Community Learning Centre, Otago Polytechnic, July 2010.

|