MOS Access: Database Fundamentals

Question 1

What is the primary purpose of a primary key in an Access table?

Accepted Answer

To uniquely identify each record in the table

Answer

To sort records alphabetically

Answer

To create relationships between tables

Answer

To set a default value for a field

Question 2

Which data type should you use to store a phone number like '(555) 123-4567' in an Access table?

Accepted Answer

Short Text

Answer

Number

Answer

Currency

Answer

Long Text

Question 3

What is the maximum number of characters allowed in a Short Text field in Microsoft Access?

Accepted Answer

255

Answer

128

Answer

512

Answer

1,024

Question 4

Which Access view allows you to add, edit, and delete table records directly?

Accepted Answer

Datasheet View

Answer

Design View

Answer

Layout View

Answer

PivotTable View

Question 5

What happens when you set a field's Required property to 'Yes' in Access?

Accepted Answer

The field must have a value before the record can be saved

Answer

The field is filled with a default value automatically

Answer

The field cannot contain duplicate values

Answer

The field is hidden from users in forms

Question 6

Which of the following is NOT a valid data type in Microsoft Access?

Accepted Answer

Formula

Answer

AutoNumber

Answer

Hyperlink

Answer

OLE Object

Question 7

What is the purpose of the AutoNumber data type in Access?

Accepted Answer

To automatically assign a unique sequential integer to each new record

Answer

To automatically calculate totals for a field

Answer

To format numbers with a specified number of decimal places

Answer

To store very large numerical values beyond standard integer range