Database Basics

What is a field?

One piece of data in a record

What is a data type?

Text, Numeric, Date/Time, Boolean etc

What is a record?

A complete row of information about a person or thing.

What is a relational database?

A database comprised of linked tables.

What is a flat file database?

A database that holds all the information in one file.

What is a query?

A search based on the records

What is a primary key?

A unique way of identifying each record e.g. Car registration plate

What is a form?

A user interface for the database

What is a report?

A way of presenting the data

What is a database?

An organised collection of data (records)