12 min read

Databases in Plain English: Key Concepts

Five words describe every database ever built: Database, Table, Field, Record, and Relationship.

You will learn: what each Access object type does. You will do: pick the right object for a library job.

Tables

Store the records. One row is one member, book, loan, or fine.

Queries

Ask a saved question. The answer updates when the tables change.

Forms

A screen for one record. Staff type here instead of the raw table grid.

Reports

A page to print or save as PDF. It reads data — you do not type new members here.

Not Excel

A spreadsheet is one mixed sheet. These four objects share one .accdb file.

Four object types share one .accdb file.

You will create all four in RiversideLibrary.accdb.

Navigation Pane

Tables

Queries

Forms

Reports

Press F11 if this list disappears.

Later in the course your Navigation Pane will look like this.

Practice

Swipe or use the arrows to move between questions.

1 / 2

Staff must save Sophie Walsh’s phone number permanently. Which object type?

Select one.

Show every loan where ReturnDate is empty (book still out). Best object?

Field Notes: Five Words That Explain Everything

Before opening Access at all, five plain-English words describe every database that has ever been built. A school tracking students and the classes they take is a useful everyday example: - Database — the whole collection of organized information, stored together: everything the school knows about students, teachers, and classes. - Table — one organized list dedicated to a single kind of thing, similar in appearance to an Excel sheet. A school database might have a Students table, a Teachers table, and a Classes table. - Field — one specific piece of information tracked for every entry in a table, shown as a column. Students might have fields for First Name, Last Name, Date of Birth, and Grade Level. - Record — one complete entry, shown as a row. One record in Students is one specific student, with every field filled in. - Relationship — a meaningful connection between two tables, letting Access understand that a particular student, from Students, is enrolled in a particular class, from Classes. Everything else in this course — queries, forms, reports — is really just a different, more powerful way of viewing, entering, or connecting that same underlying, well-organized information. Once tables, fields, records, and relationships feel comfortable, the rest follows naturally.

Four object types

Field Notes: Five Words That Explain Everything

Before opening Access at all, five plain-English words describe every database that has ever been built. A school tracking students and the classes they take is a useful everyday example: - Database — the whole collection of organized information, stored together: everything the school knows about students, teachers, and classes. - Table — one organized list dedicated to a single kind of thing, similar in appearance to an Excel sheet. A school database might have a Students table, a Teachers table, and a Classes table. - Field — one specific piece of information tracked for every entry in a table, shown as a column. Students might have fields for First Name, Last Name, Date of Birth, and Grade Level. - Record — one complete entry, shown as a row. One record in Students is one specific student, with every field filled in. - Relationship — a meaningful connection between two tables, letting Access understand that a particular student, from Students, is enrolled in a particular class, from Classes. Everything else in this course — queries, forms, reports — is really just a different, more powerful way of viewing, entering, or connecting that same underlying, well-organized information. Once tables, fields, records, and relationships feel comfortable, the rest follows naturally.