Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. Which of the following views displays the field name, description, and properties of a table?
a. Datasheet View
b. Design View
c. Layout View
d. Table View
Q. Which of the following properties identifies the type of information stored in a field?
a. Data type
b. Field description
c. Field name
d. Field properties
Q. Which of the following field properties displays a model or pattern for entering data?
a. Field Size
b. Format
c. Input Mask
d. Validation Rule
Q. Which of the following data types automatically generates a consecutive number?
a. Autonumber
b. Memo
c. Number
d. Text
Q. To remove all Sorts in a table you can click the ______ command.
a. Clear All Sorts
b. Delete All Sorts
c. Eliminate All Sorts
d. Remove All Sorts
Q. A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.
a. format row
b. criteria row
c. aggregate function
d. format layout
Q. The content and application of the Search tool CANNOT be retained when you ______.
a. format an object
b. resize a column
c. use Datasheet View
d. close an object
Q. The Search tool CANNOT be used on which major Access object?
a. Forms
b. Queries
c. Reports
d. Tables
Q. In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.
a. formula
b. format
c. layout
d. record
Q. The ______ is a wild card that represents one or more characters.
a. question mark
b. asterisk
c. exclamation mark
d. dollar sign
Q. Which is not an option for Filter on a text field?
a. Begins With
b. Between
c. Contains
d. End With
Q. The Search tool is best used when searching for ______ data.
a. simple
b. multiple
c. unique
d. formatted
Q. Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?
a. Match Case
b. Match: Whole Field
c. Match: Start of Field
d. Match: Any Part of Field
Q. Which of the following functions CANNOT be used in the Totals row?
a. Average
b. Count
c. Maximum
d. Round