Access: Database Fundamentals Flashcards

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

Answer: Select Query

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

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

Answer: To filter records based on conditions they must meet

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

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

Answer: Combo Box

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

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

Answer: To present data in a formatted, printable document

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

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

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

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

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

Answer: Macro

Macros in Access automate tasks by defining a sequence of actions that run when triggered by an event, without requiring VBA programming.

What is a subform in Microsoft Access?

Answer: A form embedded within another form to display related records

A subform is inserted into a main form and displays related records from a linked table, allowing both parent and child data to be viewed together.