Databases

A database is used to

• Calculate figures

• Store data in a logical order

• Layout pages attractively

• Present material using animations

A record is made up of

• Fields

• Primary Key

• Foreign key

• Currency

Rows in a database tables are called...

• Fields

• Tables

• Records

• Forms

Which of the following would be used to uniquely identify a record

• Field size

• Validation

• Data type

• Primary Key

Columns in a database are called...

• Rows

• Tables

• Fields

• Forms

Everything on one row is a record.

• True

• False

Each item from this list is classified as...

Name, Birthdate, Street, County , PostCode

• Form

• Table

• Record

• Field

Which of the following is an example of a record?

• 5

• 5, Thorpe, Steven, 12/17/1982, 25

• 25

• 2, 1, 8, 9, 3, 6, 4, 5, 7

Which of the following is an example of a field?

• 5

• Birth Date

• Thorpe

• 25

The best data type to choose for a postcode would be:

• Number

• Date/Time

• Text

• Currency