Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. Which of the following components has a property sheet that includes settings for the frame and the option group?
a. Option group label
b. Option group frame
c. Option button
d. Option button labels
Q. Which control lets a user create multiple pages in a form?
a. Check box control
b. Combo box control
c. Option group control
d. Tab control
Q. On the property sheet, which of the following tabs contains the Caption property?
a. Data
b. Event
c. Format
d. Other
Q. In Access 2007, to set a table to open as a document tab, you need to go to the ____.
a. Microsoft Office button
b. Navigation Pane
c. Quick Access toolbar
d. Database Tools command tab
Q. Which of the following is the file extension for an Extensible Markup Language?
a. EML
b. HTML
c. XML
d. XSD
Q. A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency.
a. standardized
b. fixed
c. delimited
d. text
Q. A(n) _____ is an image control that displays in the background of a page on a form or report.
a. legend
b. icon
c. logo
d. watermark
Q. Which colors are used to define a custom color?
a. Red, Blue, Yellow
b. Red, Green, Blue
c. Blue, Green, Orange
d. Green, Orange, Violet
Q. If a color property contains "#336699", how many blue units are in the color?
a. 33
b. 66
c. 99
d. 255
Q. The _____ function returns a string that has been converted to uppercase text.
a. AllCap
b. UCase
c. UpCase
d. Upper
Q. Which part of the IIF expression is the action performed if the true condition exists?
a. inner
b. first
c. second
d. third
Q. If you need a calculation in an unbound control, you can create a custom _____.
a. string
b. expression
c. relationship
d. syntax
Q. The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.
a. Color
b. Expression
c. Palette
d. Property
Q. Which function evaluates a "true/false" expression and then performs one of two actions?
a. Case
b. IF
c. IIF
d. IsTrue