WeLearn

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
All Grade 11 Information Technology key terms →

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. 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. 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 WeLearn

Teach 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.