LATEST MICROSOFT OFFICE SPECIALIST:
ACCESS ASSOCIATE (ACCESS
MICROSOFT 365 APPS) CERTIFICATION
EXAM OFFERED BY MICROSOFT | Q&A
WITH RATIONALES
1. Which database object is used to store raw data in
a structured format of rows and columns?
A) Query
B) Form
C) Table
D) Report
Correct answer: C
Rationale: Tables are the fundamental database
objects that store all data in records (rows) and fields
(columns).
2. What is the purpose of a primary key in an Access
table?
A) To format the table for printing
B) To uniquely identify each record in the table
C) To sort the data alphabetically
D) To create a relationship with another table
,Correct answer: B
Rationale: A primary key ensures that each record in
a table is unique, preventing duplicate entries and
enabling reliable data retrieval.
3. Which data type should be used for a field that
stores monetary values?
A) Number
B) Currency
C) Text
D) AutoNumber
Correct answer: B
Rationale: The Currency data type is specifically
designed for monetary values, providing precise
calculations and avoiding rounding errors.
4. What is the maximum number of characters
allowed in a Short Text field?
A) 50
B) 128
C) 255
D) 1024
Correct answer: C
,Rationale: A Short Text field in Access can store up to
255 characters. For longer text, the Long Text data
type should be used.
5. Which view is used to add, edit, and delete records
in a table?
A) Design View
B) Datasheet View
C) Layout View
D) Print Preview
Correct answer: B
Rationale: Datasheet View displays the table in a
spreadsheet-like grid, allowing users to directly add,
edit, or delete records.
6. What is the default data type for a new field in an
Access table?
A) Text
B) Number
C) Date/Time
D) AutoNumber
Correct answer: A
, Rationale: When creating a new field in Design View,
Access defaults to the Short Text data type.
7. Which of the following is NOT a valid data type in
Access?
A) Memo
B) OLE Object
C) Hyperlink
D) Paragraph
Correct answer: D
Rationale: Paragraph is not a data type in Access.
Memo (Long Text), OLE Object, and Hyperlink are all
valid data types.
8. How can you prevent duplicate entries in a specific
field (e.g., Social Security Number)?
A) Set the field as a primary key
B) Set the field's Indexed property to Yes (No
Duplicates)
C) Set the field's Required property to Yes
D) Set the field's Allow Zero Length property to No
Correct answer: B
ACCESS ASSOCIATE (ACCESS
MICROSOFT 365 APPS) CERTIFICATION
EXAM OFFERED BY MICROSOFT | Q&A
WITH RATIONALES
1. Which database object is used to store raw data in
a structured format of rows and columns?
A) Query
B) Form
C) Table
D) Report
Correct answer: C
Rationale: Tables are the fundamental database
objects that store all data in records (rows) and fields
(columns).
2. What is the purpose of a primary key in an Access
table?
A) To format the table for printing
B) To uniquely identify each record in the table
C) To sort the data alphabetically
D) To create a relationship with another table
,Correct answer: B
Rationale: A primary key ensures that each record in
a table is unique, preventing duplicate entries and
enabling reliable data retrieval.
3. Which data type should be used for a field that
stores monetary values?
A) Number
B) Currency
C) Text
D) AutoNumber
Correct answer: B
Rationale: The Currency data type is specifically
designed for monetary values, providing precise
calculations and avoiding rounding errors.
4. What is the maximum number of characters
allowed in a Short Text field?
A) 50
B) 128
C) 255
D) 1024
Correct answer: C
,Rationale: A Short Text field in Access can store up to
255 characters. For longer text, the Long Text data
type should be used.
5. Which view is used to add, edit, and delete records
in a table?
A) Design View
B) Datasheet View
C) Layout View
D) Print Preview
Correct answer: B
Rationale: Datasheet View displays the table in a
spreadsheet-like grid, allowing users to directly add,
edit, or delete records.
6. What is the default data type for a new field in an
Access table?
A) Text
B) Number
C) Date/Time
D) AutoNumber
Correct answer: A
, Rationale: When creating a new field in Design View,
Access defaults to the Short Text data type.
7. Which of the following is NOT a valid data type in
Access?
A) Memo
B) OLE Object
C) Hyperlink
D) Paragraph
Correct answer: D
Rationale: Paragraph is not a data type in Access.
Memo (Long Text), OLE Object, and Hyperlink are all
valid data types.
8. How can you prevent duplicate entries in a specific
field (e.g., Social Security Number)?
A) Set the field as a primary key
B) Set the field's Indexed property to Yes (No
Duplicates)
C) Set the field's Required property to Yes
D) Set the field's Allow Zero Length property to No
Correct answer: B
