Software

Records

Fields

Each record is made up of fields – categories of information.

The fields here are Name, Surname, Address, Telephone and Date of birth.

File

Let’s get it right?

Here are some more field names and data types:

Fields are of a certain data type. For example, Name and Surname are text; Date of birth is not text but a date.

Data Types

text date

Can I have a go?

This database shows records of students joining a college. Can you match the data type to the field name?

Forms and reports

Forms are designed to be viewed on screen. They make it easier for users to enter data into a database.

Reports are designed to be printed.