Database structure, fields and records, keys, and queries and reports.
Database structure
A database stores organised data:
Field — a single item (column), e.g. "Surname".
Record — a complete set of fields for one entry (row).
Table — a collection of records.
Each field has a data type (text, number, date, boolean).
Viewing only
This content is free to read on superexams.com and cannot be printed or downloaded.
Read the full note, free
Create a free account to read this note in full. Every free account gets 2 complete revision notes, no card needed.