Grade 11 Information Technology · Lesson 3.3
Creating a Relational Database in Microsoft Access
Unit 3: Database Management
Microsoft Access is a relational DBMS that is part of Microsoft Office. An Access database is saved as a single file with the extension .accdb and contains several kinds of objects: tables store the data; queries retrieve, filter and calculate data; forms provide user-friendly screens for entering and viewing data; reports present data in a formatted, printable layout; and macros and modules automate tasks.
Key terms
- Table
- object that stores data in rows and columns
- Query
- object that selects, filters and calculates data
- Form
- screen for entering and viewing records
- Report
- formatted output for printing or sharing
- Data type
- the kind of data a field can hold
- Validation rule
- condition that entered data must satisfy
- Referential integrity
- rule that foreign key values must match existing primary keys
Summary
- Access objects: tables, queries, forms, reports, macros.
- Choose correct data types and set a primary key for each table.
- Link tables in the Relationships window and enforce referential integrity.
- Queries filter with criteria; reports present results.
In everyday life: Small clinics, cooperatives and schools in Ethiopia often use Access databases to manage patients, members or student records before moving to larger systems.
Check yourself
- Name four Access objects and their purposes.
- Which data type gives automatic unique numbers?
- What does enforcing referential integrity prevent?
- Write a criterion to find marks below 50.
Practice questions
1. In Microsoft Access, which object is used to ask questions of the data, e.g. 'list all students older than 17'?
- A. Table
- B. Query
- C. Report
- D. Macro
Show answer
Answer: Query
Queries select, filter and sort data from tables according to criteria.
2. A field in one table that refers to the primary key of another table is a:
- A. Foreign key
- B. Candidate key
- C. Index card
- D. Validation rule
Show answer
Answer: Foreign key
A foreign key creates the relationship between two tables, e.g. StudentID in a Marks table pointing to the Students table.
On WeLearn
The full lesson: reading notes, worked examples, class activities and the Unit 3 quiz
Study Creating a Relational Database in Microsoft Access on WeLearnTeach Creating a Relational Database in Microsoft Access with WeLearn
We will bring a demo to your school: a lesson on your interactive TV, a virtual lab and a classroom game, with your own teachers.
