Tp5: Database

What is a Database?

A database is a set of related tables.

What is a table?

A table is a database object that you use to store data about a particular subject, such as customers, employees or products. It is a list of rows and columns similar to those in a spreadsheet. A table consists of records and fields.

The table above contains information about nine customers. Each of these customers is represented by a single record (or row) in the table. Each record can be broken down into its various fields (or columns).

A data type is a field property that indicates the kind of data that the field stores. It must be set in the Table Design grid when you create the field.