Y8 Database Key Terms

A database is used to:

• Calculate figures

• Store data in a logical order

• Layout pages attractively

• Present material using animations and graphics

The software that we would use to create a database is:

• Microsoft Publisher

• Microsoft Excel

• Microsoft Word

• Microsoft Access

In a database, data is stored in

• Tables

• Forms

• Reports

• Queries

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

• Validation

• Data type

• Primary key

• Field size

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

• Number

• Text

• Date/Time

• Currency

The best data type to choose for date of birth would be:

• Number

• Text

• Date/Time

• Currency

The best data type to choose for a persons age would be:

• Number

• Text

• Date/Time

• Currency

The best data type to choose for money would be:

• Number

• Text

• Date/Time

• Currency

A field is represented by:

• Rows

• Columns

A record is represented by:

• Rows

• Columns