MOS Access: Database Fundamentals 2

Question 1

Which type of query in Access retrieves records from one or more tables based on specified criteria?

Accepted Answer

Select Query

Answer

A Select Query retrieves and displays records matching specified criteria without modifying the underlying data.

Question 2

In Access Query Design View, what is the purpose of the 'Criteria' row?

Accepted Answer

To filter records based on conditions they must meet

Answer

The Criteria row lets you enter conditions (such as ='Smith' or >100) that records must satisfy to be included in query results.

Question 3

Which form control in Access provides a dropdown list of predefined values for data entry?

Accepted Answer

Combo Box

Answer

A Combo Box combines a text box with a dropdown list, allowing users to either select from predefined values or type an entry.

Question 4

What is the primary purpose of a Report object in Microsoft Access?

Accepted Answer

To present data in a formatted, printable document

Answer

Reports are designed to format and display data for printing or on-screen presentation, not for data entry or modification.

Question 5

What does the wildcard character '*' do when used in Access query criteria with the LIKE operator?

Accepted Answer

Represents any sequence of zero or more characters in a text string

Answer

The asterisk (*) wildcard in Access represents any number of characters, so LIKE 'Smith*' matches 'Smith', 'Smithson', 'Smithfield', etc.

MOS - Microsoft Office Specialist Certification Practice Test