Microsoft Access Exam Review
2025/2026 Exam Questions and Answers
100% Guaranteed Success | Already
Rated A+
Access - 🧠ANSWER ✔✔A database program you use to enter, organize,
display, and retrieve related information.
Access window - 🧠ANSWER ✔✔The program window that appears when
you start the Access program to create a new database or open an existing
database.
Add & Delete group - 🧠ANSWER ✔✔A group on the Fields tab in Table
Datasheet view that contains options for adding different types of fields to a
table.
All Access Objects - 🧠ANSWER ✔✔The default category in the Navigation
Pane; it lists all the objects in the database grouped by type (tables,
queries, forms, reports, and so on).
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
,AutoNumber - 🧠ANSWER ✔✔An Access data type that automatically
assigns a unique number to a record.
backing up - 🧠ANSWER ✔✔Making a copy of a database file to protect
your database against loss or damage.
Click to Add column - 🧠ANSWER ✔✔In Datasheet view for a table, the
datasheet column you can use to create a new field in the table.
column selector - 🧠ANSWER ✔✔In a datasheet, the column heading (also
called the field selector) that you click to select the entire column.
common field - 🧠ANSWER ✔✔A field that appears in more than one table,
allowing you to connect the records in the separate tables
compacting - 🧠ANSWER ✔✔A process that rearranges the data and
objects in a database to decrease its file size, thereby making more space
available on your disk and letting you open and close the database more
quickly.
Create tab - 🧠ANSWER ✔✔A tab on the Ribbon that provides options for
creating various database objects, including tables, forms, and reports.
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, Current Record box - 🧠ANSWER ✔✔The box that appears at the bottom of
a datasheet or form and that indicates the current record and total number
of records displayed.
data type - 🧠ANSWER ✔✔The field property that determines what field
values you can enter for the field and what other properties the field will
have.
database - 🧠ANSWER ✔✔A collection of related tables stored in the same
file.
database management system (DBMS) - 🧠ANSWER ✔✔A software
program that lets you create databases and then manipulate data in them.
datasheet - 🧠ANSWER ✔✔The display of a table's contents in rows and
columns, similar to a table or spreadsheet; each row is a separate record in
the table, and each column contains the field values for one field in the
table.
datasheet selector - 🧠ANSWER ✔✔A box in the upper-left corner of a
datasheet that lets you select the entire datasheet.
3
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
2025/2026 Exam Questions and Answers
100% Guaranteed Success | Already
Rated A+
Access - 🧠ANSWER ✔✔A database program you use to enter, organize,
display, and retrieve related information.
Access window - 🧠ANSWER ✔✔The program window that appears when
you start the Access program to create a new database or open an existing
database.
Add & Delete group - 🧠ANSWER ✔✔A group on the Fields tab in Table
Datasheet view that contains options for adding different types of fields to a
table.
All Access Objects - 🧠ANSWER ✔✔The default category in the Navigation
Pane; it lists all the objects in the database grouped by type (tables,
queries, forms, reports, and so on).
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
,AutoNumber - 🧠ANSWER ✔✔An Access data type that automatically
assigns a unique number to a record.
backing up - 🧠ANSWER ✔✔Making a copy of a database file to protect
your database against loss or damage.
Click to Add column - 🧠ANSWER ✔✔In Datasheet view for a table, the
datasheet column you can use to create a new field in the table.
column selector - 🧠ANSWER ✔✔In a datasheet, the column heading (also
called the field selector) that you click to select the entire column.
common field - 🧠ANSWER ✔✔A field that appears in more than one table,
allowing you to connect the records in the separate tables
compacting - 🧠ANSWER ✔✔A process that rearranges the data and
objects in a database to decrease its file size, thereby making more space
available on your disk and letting you open and close the database more
quickly.
Create tab - 🧠ANSWER ✔✔A tab on the Ribbon that provides options for
creating various database objects, including tables, forms, and reports.
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, Current Record box - 🧠ANSWER ✔✔The box that appears at the bottom of
a datasheet or form and that indicates the current record and total number
of records displayed.
data type - 🧠ANSWER ✔✔The field property that determines what field
values you can enter for the field and what other properties the field will
have.
database - 🧠ANSWER ✔✔A collection of related tables stored in the same
file.
database management system (DBMS) - 🧠ANSWER ✔✔A software
program that lets you create databases and then manipulate data in them.
datasheet - 🧠ANSWER ✔✔The display of a table's contents in rows and
columns, similar to a table or spreadsheet; each row is a separate record in
the table, and each column contains the field values for one field in the
table.
datasheet selector - 🧠ANSWER ✔✔A box in the upper-left corner of a
datasheet that lets you select the entire datasheet.
3
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
