MS Access (complete

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

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.

What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?

• Query

• Form

• Report

• Table

What is a complete row of data within a table?

• Table

• Field

• Record

• Query

Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.

• Cell

• Field

• Column

• Record

In a database table, rows are called __________

• Field

• Record

• Primary Key