IT Form2 term2 test1 database

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 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

Nick wants Access to assign an ID number to each record. What is this called?

• Data Type

• auto numbering

• Properties

• Text

What is design view?

• The function we use to set up a table in a database.

• The place where we type in all the information.