Microsoft Access Test 2025/2026 Exam
Questions and Corresponding Answers
with Surety of 100% Pass Mark
Relational databases - 🧠ANSWER ✔✔A database in which data is divided
into tables, which are kind of like spreadsheets. Each table has just one
subject, such as customers (one table) or products (another table).
Records and fields - 🧠ANSWER ✔✔Storage for the discrete data in a table.
Rows (or records) store each unique data point, such as the name of a
customer. Columns (or fields) isolate the information being captured about
each data point into the smallest possible unit—first name might be one
column and last name might be another.
Primary key - 🧠ANSWER ✔✔A value that ensures each record is unique.
For example, there might be two customers with the same name, Elizabeth
Andersen. But one of the Elizabeth Andersen records has the number 12
as its primary key and the other has a primary key of 58.
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, Parent-child relationships - 🧠ANSWER ✔✔Common relationships between
tables. For example, a single customer may have multiple orders. Parent
tables have primary keys. Child tables have foreign keys, which are values
from the primary key that show how the child table records are linked to the
parent table. These keys are linked by a relationship.
What is good database design? - 🧠ANSWER ✔✔Avoid duplicate
information (also called redundant data).
Ensure that data is correct and complete.
Steps of Database Design? - 🧠ANSWER ✔✔Step 1: Determine the
purpose of your database
Step 2: Find and organize required information
Step 3: Divide information into tables
Step 4: Turn information items into columns
Step 5: Specify primary keys
What are the 6 database objects? - 🧠ANSWER ✔✔Tables, queries, forms,
reports, macros, and modules
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
Questions and Corresponding Answers
with Surety of 100% Pass Mark
Relational databases - 🧠ANSWER ✔✔A database in which data is divided
into tables, which are kind of like spreadsheets. Each table has just one
subject, such as customers (one table) or products (another table).
Records and fields - 🧠ANSWER ✔✔Storage for the discrete data in a table.
Rows (or records) store each unique data point, such as the name of a
customer. Columns (or fields) isolate the information being captured about
each data point into the smallest possible unit—first name might be one
column and last name might be another.
Primary key - 🧠ANSWER ✔✔A value that ensures each record is unique.
For example, there might be two customers with the same name, Elizabeth
Andersen. But one of the Elizabeth Andersen records has the number 12
as its primary key and the other has a primary key of 58.
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, Parent-child relationships - 🧠ANSWER ✔✔Common relationships between
tables. For example, a single customer may have multiple orders. Parent
tables have primary keys. Child tables have foreign keys, which are values
from the primary key that show how the child table records are linked to the
parent table. These keys are linked by a relationship.
What is good database design? - 🧠ANSWER ✔✔Avoid duplicate
information (also called redundant data).
Ensure that data is correct and complete.
Steps of Database Design? - 🧠ANSWER ✔✔Step 1: Determine the
purpose of your database
Step 2: Find and organize required information
Step 3: Divide information into tables
Step 4: Turn information items into columns
Step 5: Specify primary keys
What are the 6 database objects? - 🧠ANSWER ✔✔Tables, queries, forms,
reports, macros, and modules
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
