Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. Referential integrity cannot be set for _______________ relationships.
a. One-To-One
b. Indeterminate
c. One-To-Many
d. Many-To-Many
Q. The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
a. primary, foreign
b. primary, common
c. foreign, primary
d. foreign, common
Q. Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
a. queries
b. fields
c. records
d. tables
Q. In the Relationship window, related fields from each table are connected by a(n) _______________.
a. default field
b. linking tables
c. index
d. join line
Q. Relationships between tables can be graphically viewed in the _______________ window.
a. Design
b. Joins
c. Relationships
d. Tables
Q. In the Field List of a table, the primary key appears _______________.
a. bold
b. italicized
c. underlined
d. with key icon
Q. What type of relationship is created when you select a primary key in both related tables?
a. One-To-One
b. Indeterminate
c. One-To-Many
d. Many-To-Many
Q. The Table _______________ Wizard analyzes a database and recommends changes for normalization.
a. Analyzer
b. Documenter
c. Cleanup
d. Normalization
Q. The Input Mask wizard does NOT include the ability to do which of the following?
a. Force all uppercase
b. Define placeholder
c. Store symbols with data
d. Use preset masks
Q. Which of the following field properties enforces the use of parentheses when keying an area code?
a. Field Size
b. Format
c. Input Mask
d. Validation Rule
Q. Which of the following field properties is an expression that specifies criteria or requirements for entering data?
a. Field Size
b. Format
c. Input Mask
d. Validation Rule
Q. In Datasheet View, what appears at the top of each column?
a. Data type
b. Description
c. Field name
d. Primary key
Q. Which is NOT a method of creating a table?
a. Datasheet View
b. Design View
c. Layout View
d. Template