Computer Studies·Databases · NSSCO 3.1.3
Databases: tables, keys, queries, forms, reports & macros
Narrated lesson · press play
A database is how a school, a bank or a clinic keeps thousands of records tidy, correct and easy to find. In this lesson we build a small Namibian school database, learn the words table, record, field, primary key and foreign key, and see how two tables are linked with a relationship. We also meet views, queries, forms, reports and macros so you can pass the exam and use the software.
What you'll learn in this lesson
By the end you should be able to (NSSCO Computer Studies 3.1.3):
- Define the term database; explain the purpose of a database
- Define the following types of databases: flat file, relational database
- Describe the following terms: table, record, field, primary key, foreign key, database file, relationships
- Explain the different types of fields
- Explain the difference between design view, form view, query view and report view
- Create a database file; create table(s) in a database; change field width; add fields; delete fields; change field types; create relationships between tables in a database
- Enter data in a database file using forms only
- Create different types of queries in a database such as: select query, action queries (create table, append, delete, update), parameter query
- Create forms for a database containing some of the following components: combo box, list box, sub-form; and forms for: data entry only, search and display data only
- Create reports from a database
- Create macros to perform the following tasks: run select and action queries, run forms and reports
- Apply data migration techniques in a database (import and export); print retrieved data from a database: form data, query results, reports
Loading your lesson…
You're watching a free 3-minute preview — create a free account to keep going.
Quick revision
Revise this in 5 minutes
Miss Maria and Mike talk through the whole topic — with the figure and working drawn live.