Microsoft Access Test 2025/2026 Exam
Questions with 100% Correct Answers |
Latest Update
Access - 🧠ANSWER ✔✔Database management system for Office
Table - 🧠ANSWER ✔✔object in which data such as a name or number is
stored
Field - 🧠ANSWER ✔✔smallest data element of a table
Record - 🧠ANSWER ✔✔complete set of all the fields about one person,
place, event, or concept
Form - 🧠ANSWER ✔✔object that gives a user a way of entering and
modifying data in databases
Query - 🧠ANSWER ✔✔is a question that you ask about the data in your
database
Report - 🧠ANSWER ✔✔contains professional looking formatted info from
underlying tables or queries
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, Design View - 🧠ANSWER ✔✔gives you a detailed view of the table's
structure and is used to create and modify a tables design
Datasheet View - 🧠ANSWER ✔✔is a grid containing fields and records like
a spreadsheet
Field Properties - 🧠ANSWER ✔✔define the characteristics of the fields in
more detail
Primary Key - 🧠ANSWER ✔✔is the field that uniquely identifies each record
in a table
AutoNumber - 🧠ANSWER ✔✔number generated by Access and increases
incrementally
Compact and Repair - 🧠ANSWER ✔✔reduces the size of the database
Back Up Database - 🧠ANSWER ✔✔creates duplicate copy of the database
Criterion - 🧠ANSWER ✔✔number, text, phrase, etc used to select
something form a table
Filter By Selection - 🧠ANSWER ✔✔displays only the records that match a
criterion you select
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
Questions with 100% Correct Answers |
Latest Update
Access - 🧠ANSWER ✔✔Database management system for Office
Table - 🧠ANSWER ✔✔object in which data such as a name or number is
stored
Field - 🧠ANSWER ✔✔smallest data element of a table
Record - 🧠ANSWER ✔✔complete set of all the fields about one person,
place, event, or concept
Form - 🧠ANSWER ✔✔object that gives a user a way of entering and
modifying data in databases
Query - 🧠ANSWER ✔✔is a question that you ask about the data in your
database
Report - 🧠ANSWER ✔✔contains professional looking formatted info from
underlying tables or queries
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, Design View - 🧠ANSWER ✔✔gives you a detailed view of the table's
structure and is used to create and modify a tables design
Datasheet View - 🧠ANSWER ✔✔is a grid containing fields and records like
a spreadsheet
Field Properties - 🧠ANSWER ✔✔define the characteristics of the fields in
more detail
Primary Key - 🧠ANSWER ✔✔is the field that uniquely identifies each record
in a table
AutoNumber - 🧠ANSWER ✔✔number generated by Access and increases
incrementally
Compact and Repair - 🧠ANSWER ✔✔reduces the size of the database
Back Up Database - 🧠ANSWER ✔✔creates duplicate copy of the database
Criterion - 🧠ANSWER ✔✔number, text, phrase, etc used to select
something form a table
Filter By Selection - 🧠ANSWER ✔✔displays only the records that match a
criterion you select
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
