Access

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

A ‘required field’ is a form of

• Validation

• Verification

• Data Entry

• Data Output

A postcode is usually written in the same format e.g. LLNN NLL (L=letter, N=number). The most suitable type of validation to use in this instance would be

• Input Mask

• Required Field

• Range Check

• None

The best data type to choose for a phone number would be

• Number

• Text

• Date/Time

• Currency

To find a particular set of data in a database you would use a

• Table

• Form

• Query

• Report