Test Bank for Exploring Microsoft 365: Access 2025, 1st Edition by Mary Anne Poatsy

Exploring Microsoft Office 365: Access 2025 (Poatsy)
Chapter 1 Introduction to Databases and Microsoft Access

1) Database ________ are employees who are database experts who manage the database data
and ensure the security of that organization's data.
A) users
B) engineers
C) administrators
D) managers
Answer: C
Diff: 2
Objective: A1.01 Explore Database Fundamentals

2) What is not true about the Compact and Repair Database utility?
A) It can help when the data becomes corrupt.
B) It can be set up to run automatically when a database is closed.
C) It is used when the database gets too many records in it.
D) It can reduce the size of a database.
Answer: C
Diff: 2
Objective: A1.04 Use Database Utilities

3) When you click the Enable Content warning, the database is now ________.
A) trusted on this computer
B) trusted for this session
C) trusted for any computer
D) unlocked
Answer: A
Diff: 2
Objective: A1.01 Explore Database Fundamentals

4) What interface element shows you the various objects in your database?
A) The Database Tools menu
B) The Database Properties pane
C) The Home menu
D) The Navigation Pane
Answer: D
Diff: 2
Objective: A1.02 Recognize Database Object Types




1
Copyright © 2026

,5) How can you toggle viewing the Navigation Pane?
A) Shutter Bar View/Hide button
B) Navigation Pane View/Hide button
C) Shutter Bar Open/Close button
D) Navigation Pane Open/Close button
Answer: C
Diff: 2
Objective: A1.02 Recognize Database Object Types

6) What database object organizes your data by rows and columns?
A) Table
B) Form
C) Report
D) Macro
Answer: A
Diff: 1
Objective: A1.02 Recognize Database Object Types

7) A customer's cell phone number would be an example of a ________.
A) table
B) record
C) field
D) primary key
Answer: C
Diff: 1
Objective: A1.02 Recognize Database Object Types

8) Which of the following produces a subset of your data?
A) Macro
B) Field
C) Table
D) Query
Answer: D
Diff: 2
Objective: A1.02 Recognize Database Object Types

9) Most users enter information into a database through the use of a ________.
A) form
B) table in Datasheet view
C) query
D) macro
Answer: A
Diff: 2
Objective: A1.02 Recognize Database Object Types




2
Copyright © 2026

,10) A module uses what programming language?
A) SQL
B) VBA
C) VBL
D) HTML
Answer: B
Diff: 3
Objective: A1.02 Recognize Database Object Types

11) In Datasheet view, what does a pencil symbol to the left of a record indicate?
A) Data in that record has not been saved yet.
B) Data in that record has recently been modified and saved.
C) Data in that record has a data integrity violation and needs to be changed.
D) Data in that record is about to be deleted.
Answer: A
Diff: 2
Objective: A1.03 Modify, Add, and Save Data

12) ________ is(are) what is entered into a database.
A) AI programs
B) Objects
C) Information
D) Data
Answer: D
Diff: 2
Objective: A1.01 Explore Database Fundamentals

13) How many records do most forms display?
A) 0 (Forms don't display records.)
B) 1
C) 2
D) All the records at the same time
Answer: B
Diff: 2
Objective: A1.02 Recognize Database Object Types

14) What is not true about field properties?
A) They define a field's characteristics.
B) They vary by field type.
C) They can allow data entry to be required for a field.
D) The categories are the same for all field types.
Answer: D
Diff: 2
Objective: A1.02 Recognize Database Object Types




3
Copyright © 2026

, 15) Which of the following views would you use to view or modify a table's structure?
A) Datasheet
B) Form
C) Design
D) Layout
Answer: C
Diff: 2
Objective: A1.02 Recognize Database Object Types

16) What are the two ways you can view a table?
A) Design and Layout views
B) Design and Datasheet views
C) Datasheet and Form views
D) Datasheet and Layout views
Answer: B
Diff: 1
Objective: A1.02 Recognize Database Object Types

17) Access is a ________ product.
A) Microsoft
B) Google
C) Yahoo
D) Corel
Answer: A
Diff: 1
Objective: A1.02 Recognize Database Object Types

18) In Datasheet view, what do the rows indicate?
A) Tables
B) Fields
C) Records
D) Information
Answer: C
Diff: 1
Objective: A1.02 Recognize Database Object Types

19) What view normally appears when you double-click a table?
A) Form view
B) Layout view
C) Design view
D) Datasheet view
Answer: D
Diff: 1
Objective: A1.02 Recognize Database Object Types




4
Copyright © 2026