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

A primary key uniquely identifies each record in a table, ensuring no two records have the same key value.

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

Short Text is used for alphanumeric data like phone numbers that contain non-numeric characters and are never used in calculations.

Question 3

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

Accepted Answer

255

Answer

Short Text fields in Access support a maximum of 255 characters.

Question 4

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

Accepted Answer

Datasheet View

Answer

Datasheet View displays records in a row-and-column grid and allows direct data entry and editing.

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

Setting Required to 'Yes' forces users to enter a value in that field; the record cannot be saved if the field is left empty.

MOS - Microsoft Office Specialist Certification Practice Test