,TESTBANK FOR GO! Microsoft 365 Access 2025, 1st
edition Shelley Gaskin
Notes
1- The file is chapter after chapter.
2- We have shown you few pages sample.
3- The file contains all Appendix and Excel sheet
if it exists.
4- We have all what you need, we make update
at every time. There are many new editions
waiting you.
5- If you think you purchased the wrong file You
can contact us at every time, we can replace it
with true one.
Our email:
,GO! Microsoft 365: Access 2025 (Gaskin)
Access Chapter 1 Getting Started with Microsoft Access
1) A ________ is an organized collection of data.
A) database
B) catalog
C) server
D) caption
Answer: A
Diff: 1
Objective: A1.01. Identify Good Database Design
2) Data that is accurate, timely, and organized in a useful manner is ________.
A) knowledge
B) information
C) metadata
D) enhanced data
Answer: B
Diff: 1
Objective: A1.01. Identify Good Database Design
3) A ________ database is one where multiple collections of data are linked to one another.
A) cataloged
B) hierarchical
C) flat
D) relational
Answer: D
Diff: 2
Objective: A1.01. Identify Good Database Design
4) In a table, a ________ contains all of the categories of data pertaining to one person, place,
event, thing, or idea.
A) record
B) field
C) primary key
D) foreign key
Answer: A
Diff: 1
Objective: A1.01. Identify Good Database Design
1
Copyright © 2026 Pearson Education, Inc.
,5) In a table, a ________ is a single piece of information for every record, such as a first or last
name.
A) primary key
B) record
C) foreign key
D) field
Answer: D
Diff: 1
Objective: A1.01. Identify Good Database Design
6) The ________ principle of good database design is to organize data in tables so that there is
no redundant data.
A) first
B) second
C) third
D) fourth
Answer: A
Diff: 3
Objective: A1.01. Identify Good Database Design
7) Using techniques that ensure the accuracy and consistency of data as it is entered into a table
is the ________ principle of good database design.
A) first
B) second
C) third
D) fourth
Answer: B
Diff: 3
Objective: A1.01. Identify Good Database Design
8) Which of the following is not true about appending records?
A) The table into which the records are going must already exist.
B) The table into which the records are going must be closed.
C) The source of the new records must be from an Access table.
D) Appending means adding records to a table.
Answer: C
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
9) Which data type can create a sequential order of numbers with no duplications?
A) Calculated
B) AutoNumber
C) Large Number
D) Hyperlink
Answer: B
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
2
Copyright © 2026 Pearson Education, Inc.
,10) Which field property allows you to display a name in forms and reports that is different than
the field name?
A) Caption
B) Indexed
C) Input Mask
D) Format
Answer: A
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
11) Which of the following is not a method to create a new database?
A) Database template
B) Blank desktop database
C) Database wizard
D) Custom web app
Answer: C
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
12) When creating a new table, Access creates the first field and names it ________.
A) ITEM
B) OBJECT
C) ID
D) VALUE
Answer: C
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
13) To improve accuracy during user input, a designer can limit the number of characters a user
can enter by adjusting the ________ field property.
A) Length
B) Field Size
C) Details
D) Format
Answer: B
Diff: 2
Objective: A1.03. Change the Structure of Tables and Add a Second Table
14) The ________ key refers to the unique field that identifies each record in a table.
A) join
B) primary
C) object
D) foreign
Answer: B
Diff: 1
Objective: A1.03. Change the Structure of Tables and Add a Second Table
3
Copyright © 2026 Pearson Education, Inc.
,15) A ________ is a database object that retrieves specific data from one or more database
objects.
A) report
B) filter
C) form
D) query
Answer: D
Diff: 2
Objective: A1.04. Create a Query, Form, and Report
16) The ________ view of a form allows a user to view the data while making changes to the
elements of the form.
A) Layout
B) Form
C) Print
D) Design
Answer: A
Diff: 2
Objective: A1.04. Create a Query, Form, and Report
17) A ________ is a connection that you establish between two tables based on common fields.
A) relationship
B) field list
C) subdatasheet
D) sort
Answer: A
Diff: 1
Objective: A1.08. Create Table Relationships
18) Within an Access table, each column is called a record.
Answer: FALSE
Diff: 1
Objective: A1.01. Identify Good Database Design
19) Following the rules of normalization helps to ensure that your database performs as
expected.
Answer: TRUE
Diff: 2
Objective: A1.01. Identify Good Database Design
20) Proofreading data is critical to maintaining accuracy in a database.
Answer: TRUE
Diff: 1
Objective: A1.01. Identify Good Database Design
4
Copyright © 2026 Pearson Education, Inc.
,21) Making sure that everyone enters data in a state field the same way is a part of the first
principle of database design.
Answer: FALSE
Diff: 2
Objective: A1.01. Identify Good Database Design
22) One way of populating a table is by typing data directly into the table.
Answer: TRUE
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
23) Objects are the basic parts of a database that you use to store, work with, and display data.
Answer: TRUE
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
24) In the Datasheet view, a user will see the underlying structure of the table.
Answer: FALSE
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
25) The Short Text data type will allow a user to store up to 512 characters in that field.
Answer: FALSE
Diff: 3
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
26) Once users select a data type for a field and enter data, they can change the data type.
Answer: TRUE
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
27) The AutoNumber field type can generate random numbers.
Answer: TRUE
Diff: 3
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
28) Numbers generated by the AutoNumber field are always unique to that table.
Answer: TRUE
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
29) The table into which you import or append data is referred to as the receiving table.
Answer: FALSE
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
5
Copyright © 2026 Pearson Education, Inc.
,30) You can append records to a non-existent table.
Answer: FALSE
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
31) Adjusting the column width to fit the content is known as Must Fit.
Answer: FALSE
Diff: 2
Objective: A1.03. Change the Structure of Tables and Add a Second Table
32) An object or item's Property Sheet is where you can make precise changes to the
characteristics of the object or item.
Answer: TRUE
Diff: 2
Objective: A1.04. Create a Query, Form, and Report
33) A user can only select one table or query on which to perform a simple select query.
Answer: FALSE
Diff: 3
Objective: A1.04. Create a Query, Form, and Report
34) A user can create a new form for data within a table by making the table active and selecting
Form from the Create tab.
Answer: TRUE
Diff: 2
Objective: A1.04. Create a Query, Form, and Report
35) If you make changes to the structure of a table, you will be prompted to save the table when
closing it.
Answer: TRUE
Diff: 2
Objective: A1.05. Close a Database and Close Access
36) The Message Bar is the area directly below the ribbon that displays information such as
security alerts.
Answer: TRUE
Diff: 2
Objective: A1.06. Open an Existing Database
37) You can double-click a table name in the Navigation Pane to open it in the object window.
Answer: TRUE
Diff: 1
Objective: A1.07. Organize Objects in the Navigation Pane
6
Copyright © 2026 Pearson Education, Inc.
,38) The Tables and Related Views category in the Navigation Pane groups objects by the table to
which the objects are related.
Answer: TRUE
Diff: 3
Objective: A1.07. Organize Objects in the Navigation Pane
39) A many-to-many relationship is the most common type of relationship in Access.
Answer: FALSE
Diff: 3
Objective: A1.08. Create Table Relationships
40) Referential integrity is a set of rules that Access uses to ensure that the data between related
tables is valid.
Answer: TRUE
Diff: 2
Objective: A1.08. Create Table Relationships
41) A field list is an association that you establish between two tables in a database.
Answer: FALSE
Diff: 2
Objective: A1.08. Create Table Relationships
42) Sorting is the process of arranging data in a specific order based on the value in a field.
Answer: TRUE
Diff: 1
Objective: A1.09. Sort Records in a Table
43) Descending order sorts text alphabetically (from A to Z).
Answer: FALSE
Diff: 1
Objective: A1.09. Sort Records in a Table
44) ________ is data that is accurate, timely, and organized in a useful manner.
Answer: Information
Diff: 1
Objective: A1.01. Identify Good Database Design
45) ________ is the process of applying design rules and principles to ensure that your database
performs as expected.
Answer: Normalization
Diff: 2
Objective: A1.01. Identify Good Database Design
46) A(n) ________ field is a field in two or more tables that stores the same data.
Answer: common
Diff: 2
Objective: A1.01. Identify Good Database Design
7
Copyright © 2026 Pearson Education, Inc.
, 47) A preformatted database designed for a specific purpose is a database ________.
Answer: template
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
48) ________ is the process of copying data from one source or application to another
application.
Answer: Importing
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
49) The ________ Pane displays and organizes the names of the objects in a database.
Answer: Navigation
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
50) The ________ classifies the kind of data that can be stored in each table field, such as
numbers, text, or dates.
Answer: data type
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
51) You can ________ records from an Excel spreadsheet to add them to an existing table in
Access.
Answer: append
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
52) The ________ data type assigns a unique sequential or random number to a field as each
record is entered.
Answer: AutoNumber
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
53) Which field property allows a field named "LastName" to be displayed as "Last Name"?
Answer: Caption
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
54) The ________ data type is most often used for fields that contain monetary values.
Answer: Currency
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
8
Copyright © 2026 Pearson Education, Inc.
edition Shelley Gaskin
Notes
1- The file is chapter after chapter.
2- We have shown you few pages sample.
3- The file contains all Appendix and Excel sheet
if it exists.
4- We have all what you need, we make update
at every time. There are many new editions
waiting you.
5- If you think you purchased the wrong file You
can contact us at every time, we can replace it
with true one.
Our email:
,GO! Microsoft 365: Access 2025 (Gaskin)
Access Chapter 1 Getting Started with Microsoft Access
1) A ________ is an organized collection of data.
A) database
B) catalog
C) server
D) caption
Answer: A
Diff: 1
Objective: A1.01. Identify Good Database Design
2) Data that is accurate, timely, and organized in a useful manner is ________.
A) knowledge
B) information
C) metadata
D) enhanced data
Answer: B
Diff: 1
Objective: A1.01. Identify Good Database Design
3) A ________ database is one where multiple collections of data are linked to one another.
A) cataloged
B) hierarchical
C) flat
D) relational
Answer: D
Diff: 2
Objective: A1.01. Identify Good Database Design
4) In a table, a ________ contains all of the categories of data pertaining to one person, place,
event, thing, or idea.
A) record
B) field
C) primary key
D) foreign key
Answer: A
Diff: 1
Objective: A1.01. Identify Good Database Design
1
Copyright © 2026 Pearson Education, Inc.
,5) In a table, a ________ is a single piece of information for every record, such as a first or last
name.
A) primary key
B) record
C) foreign key
D) field
Answer: D
Diff: 1
Objective: A1.01. Identify Good Database Design
6) The ________ principle of good database design is to organize data in tables so that there is
no redundant data.
A) first
B) second
C) third
D) fourth
Answer: A
Diff: 3
Objective: A1.01. Identify Good Database Design
7) Using techniques that ensure the accuracy and consistency of data as it is entered into a table
is the ________ principle of good database design.
A) first
B) second
C) third
D) fourth
Answer: B
Diff: 3
Objective: A1.01. Identify Good Database Design
8) Which of the following is not true about appending records?
A) The table into which the records are going must already exist.
B) The table into which the records are going must be closed.
C) The source of the new records must be from an Access table.
D) Appending means adding records to a table.
Answer: C
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
9) Which data type can create a sequential order of numbers with no duplications?
A) Calculated
B) AutoNumber
C) Large Number
D) Hyperlink
Answer: B
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
2
Copyright © 2026 Pearson Education, Inc.
,10) Which field property allows you to display a name in forms and reports that is different than
the field name?
A) Caption
B) Indexed
C) Input Mask
D) Format
Answer: A
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
11) Which of the following is not a method to create a new database?
A) Database template
B) Blank desktop database
C) Database wizard
D) Custom web app
Answer: C
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
12) When creating a new table, Access creates the first field and names it ________.
A) ITEM
B) OBJECT
C) ID
D) VALUE
Answer: C
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
13) To improve accuracy during user input, a designer can limit the number of characters a user
can enter by adjusting the ________ field property.
A) Length
B) Field Size
C) Details
D) Format
Answer: B
Diff: 2
Objective: A1.03. Change the Structure of Tables and Add a Second Table
14) The ________ key refers to the unique field that identifies each record in a table.
A) join
B) primary
C) object
D) foreign
Answer: B
Diff: 1
Objective: A1.03. Change the Structure of Tables and Add a Second Table
3
Copyright © 2026 Pearson Education, Inc.
,15) A ________ is a database object that retrieves specific data from one or more database
objects.
A) report
B) filter
C) form
D) query
Answer: D
Diff: 2
Objective: A1.04. Create a Query, Form, and Report
16) The ________ view of a form allows a user to view the data while making changes to the
elements of the form.
A) Layout
B) Form
C) Print
D) Design
Answer: A
Diff: 2
Objective: A1.04. Create a Query, Form, and Report
17) A ________ is a connection that you establish between two tables based on common fields.
A) relationship
B) field list
C) subdatasheet
D) sort
Answer: A
Diff: 1
Objective: A1.08. Create Table Relationships
18) Within an Access table, each column is called a record.
Answer: FALSE
Diff: 1
Objective: A1.01. Identify Good Database Design
19) Following the rules of normalization helps to ensure that your database performs as
expected.
Answer: TRUE
Diff: 2
Objective: A1.01. Identify Good Database Design
20) Proofreading data is critical to maintaining accuracy in a database.
Answer: TRUE
Diff: 1
Objective: A1.01. Identify Good Database Design
4
Copyright © 2026 Pearson Education, Inc.
,21) Making sure that everyone enters data in a state field the same way is a part of the first
principle of database design.
Answer: FALSE
Diff: 2
Objective: A1.01. Identify Good Database Design
22) One way of populating a table is by typing data directly into the table.
Answer: TRUE
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
23) Objects are the basic parts of a database that you use to store, work with, and display data.
Answer: TRUE
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
24) In the Datasheet view, a user will see the underlying structure of the table.
Answer: FALSE
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
25) The Short Text data type will allow a user to store up to 512 characters in that field.
Answer: FALSE
Diff: 3
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
26) Once users select a data type for a field and enter data, they can change the data type.
Answer: TRUE
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
27) The AutoNumber field type can generate random numbers.
Answer: TRUE
Diff: 3
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
28) Numbers generated by the AutoNumber field are always unique to that table.
Answer: TRUE
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
29) The table into which you import or append data is referred to as the receiving table.
Answer: FALSE
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
5
Copyright © 2026 Pearson Education, Inc.
,30) You can append records to a non-existent table.
Answer: FALSE
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
31) Adjusting the column width to fit the content is known as Must Fit.
Answer: FALSE
Diff: 2
Objective: A1.03. Change the Structure of Tables and Add a Second Table
32) An object or item's Property Sheet is where you can make precise changes to the
characteristics of the object or item.
Answer: TRUE
Diff: 2
Objective: A1.04. Create a Query, Form, and Report
33) A user can only select one table or query on which to perform a simple select query.
Answer: FALSE
Diff: 3
Objective: A1.04. Create a Query, Form, and Report
34) A user can create a new form for data within a table by making the table active and selecting
Form from the Create tab.
Answer: TRUE
Diff: 2
Objective: A1.04. Create a Query, Form, and Report
35) If you make changes to the structure of a table, you will be prompted to save the table when
closing it.
Answer: TRUE
Diff: 2
Objective: A1.05. Close a Database and Close Access
36) The Message Bar is the area directly below the ribbon that displays information such as
security alerts.
Answer: TRUE
Diff: 2
Objective: A1.06. Open an Existing Database
37) You can double-click a table name in the Navigation Pane to open it in the object window.
Answer: TRUE
Diff: 1
Objective: A1.07. Organize Objects in the Navigation Pane
6
Copyright © 2026 Pearson Education, Inc.
,38) The Tables and Related Views category in the Navigation Pane groups objects by the table to
which the objects are related.
Answer: TRUE
Diff: 3
Objective: A1.07. Organize Objects in the Navigation Pane
39) A many-to-many relationship is the most common type of relationship in Access.
Answer: FALSE
Diff: 3
Objective: A1.08. Create Table Relationships
40) Referential integrity is a set of rules that Access uses to ensure that the data between related
tables is valid.
Answer: TRUE
Diff: 2
Objective: A1.08. Create Table Relationships
41) A field list is an association that you establish between two tables in a database.
Answer: FALSE
Diff: 2
Objective: A1.08. Create Table Relationships
42) Sorting is the process of arranging data in a specific order based on the value in a field.
Answer: TRUE
Diff: 1
Objective: A1.09. Sort Records in a Table
43) Descending order sorts text alphabetically (from A to Z).
Answer: FALSE
Diff: 1
Objective: A1.09. Sort Records in a Table
44) ________ is data that is accurate, timely, and organized in a useful manner.
Answer: Information
Diff: 1
Objective: A1.01. Identify Good Database Design
45) ________ is the process of applying design rules and principles to ensure that your database
performs as expected.
Answer: Normalization
Diff: 2
Objective: A1.01. Identify Good Database Design
46) A(n) ________ field is a field in two or more tables that stores the same data.
Answer: common
Diff: 2
Objective: A1.01. Identify Good Database Design
7
Copyright © 2026 Pearson Education, Inc.
, 47) A preformatted database designed for a specific purpose is a database ________.
Answer: template
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
48) ________ is the process of copying data from one source or application to another
application.
Answer: Importing
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
49) The ________ Pane displays and organizes the names of the objects in a database.
Answer: Navigation
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
50) The ________ classifies the kind of data that can be stored in each table field, such as
numbers, text, or dates.
Answer: data type
Diff: 1
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
51) You can ________ records from an Excel spreadsheet to add them to an existing table in
Access.
Answer: append
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
52) The ________ data type assigns a unique sequential or random number to a field as each
record is entered.
Answer: AutoNumber
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
53) Which field property allows a field named "LastName" to be displayed as "Last Name"?
Answer: Caption
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
54) The ________ data type is most often used for fields that contain monetary values.
Answer: Currency
Diff: 2
Objective: A1.02. Create a Table and Define Fields in a Blank Desktop Database
8
Copyright © 2026 Pearson Education, Inc.
