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

Action Query

Answer

Crosstab Query

Answer

Union Query

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

To specify which fields appear in the query results

Answer

To sort the query results in ascending or descending order

Answer

To add calculated fields to the query output

Question 3

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

Accepted Answer

Combo Box

Answer

Text Box

Answer

Label

Answer

Toggle Button

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

To enter and edit records in a structured layout

Answer

To query data from multiple tables simultaneously

Answer

To define table relationships and referential integrity

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

Multiplies two field values together in a calculated field

Answer

Marks fields that are required to have a value

Answer

Selects all records regardless of field values

Question 6

Which Access object is specifically designed to automate repetitive tasks by executing a series of predefined actions?

Accepted Answer

Macro

Answer

Query

Answer

Module

Answer

Report

Question 7

What is a subform in Microsoft Access?

Accepted Answer

A form embedded within another form to display related records

Answer

A form that saves data automatically on a timer

Answer

A simplified version of a form with fewer visible fields

Answer

A form used exclusively for importing external data