Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. When adding an image, which size mode will change the height or width of the image fit the control?
a. Clip
b. Stretch
c. Zoom
d. Crop
Q. The three parts of an IIF function are separated by _____.
a. dashes
b. asterisks
c. semicolons
d. commas
Q. A Smart Tag can be set using the _____ tab in the property sheet.
a. Format
b. Tag
c. View
d. Data
Q. A(n) _____ is a control that, when clicked, executes an action or series of actions.
a. combo box control
b. AutoFormat
c. Conditional Format
d. command button
Q. According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
a. txt
b. txb
c. tbc
d. tex
Q. How can a user open the Expression Builder dialog box?
a. By clicking the drop-down arrow on the Control Source property
b. By clicking the drop-down arrow of the Input Mask property in the Data tab
c. By clicking the Build button of the Input Mask in the Data tab
d. By clicking the Build button of the Control Source property in the Data tab
Q. According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?
a. cbo
b. cob
c. cmb
d. cbx
Q. You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?
a. Detail
b. Form Footer
c. Form Header
d. Page Header
Q. The Allow _____ property controls whether new records can be added through the form.
a. Additions
b. Edits
c. Deletions
d. Data Entry
Q. The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.
a. Date
b. Time
c. Calendar
d. Appointment
Q. The _____ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote.
a. MSN Money
b. Portfolio
c. Financial
d. Stock
Q. A(n) _______________ query locates data from one or more tables.
a. select
b. summary
c. parameter
d. action
Q. Which function extracts the name of the month from a date/time value?
a. Month
b. MonthName
c. MonthLabel
d. MonthValue
Q. Which of the following queries prompts users for input data by displaying dialog boxes?
a. Append
b. Delete
c. Parameter
d. Update
Q. A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.
a. select
b. summary
c. parameter
d. action