MOS Access: Database Fundamentals 2 — Questions and Answers
Question 1: Which type of query in Access retrieves records from one or more tables based on specified criteria?
- Action Query
- Select Query (Correct answer)
- Crosstab Query
- Union Query
Correct answer: Select Query
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?
- To specify which fields appear in the query results
- To sort the query results in ascending or descending order
- To filter records based on conditions they must meet (Correct answer)
- To add calculated fields to the query output
Correct 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.
Question 3: Which form control in Access provides a dropdown list of predefined values for data entry?
- Text Box
- Label
- Combo Box (Correct answer)
- Toggle Button
Correct 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.
Question 4: What is the primary purpose of a Report object in Microsoft Access?
- To enter and edit records in a structured layout
- To query data from multiple tables simultaneously
- To present data in a formatted, printable document (Correct answer)
- To define table relationships and referential integrity
Correct 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.
Question 5: What does the wildcard character '*' do when used in Access query criteria with the LIKE operator?
- Multiplies two field values together in a calculated field
- Represents any sequence of zero or more characters in a text string (Correct answer)
- Marks fields that are required to have a value
- Selects all records regardless of field values
Correct 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.
Question 6: Which Access object is specifically designed to automate repetitive tasks by executing a series of predefined actions?
- Query
- Module
- Report
- Macro (Correct answer)
Correct answer: Macro
Macros in Access automate tasks by defining a sequence of actions that run when triggered by an event, without requiring VBA programming.
Question 7: What is a subform in Microsoft Access?
- A form that saves data automatically on a timer
- A form embedded within another form to display related records (Correct answer)
- A simplified version of a form with fewer visible fields
- A form used exclusively for importing external data
Correct 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.
MOS Access: Database Fundamentals 2
Which type of query in Access retrieves records from one or more tables based on specified criteria?