Q. Which of the following is NOT true about background images?

  • (A) They can be inserted on a form or a report
  • (B) They do not print when a form or a report is printed
  • (C) They are displayed behind the controls in a form
  • (D) They are similar to watermarks in Word
πŸ’¬ Discuss
βœ… Correct Answer: (B) They do not print when a form or a report is printed

Q. A(n) _________ query makes changes to or moves records in a dynaset, in a single operation.

  • (A) Parameter
  • (B) Action
  • (C) Summary
  • (D) Select
πŸ’¬ Discuss
βœ… Correct Answer: (B) Action

Q. In a query, which row do you need to place wildcards to affect a parameter?

  • (A) Tables
  • (B) Fields
  • (C) Criteria
  • (D) Arguments
πŸ’¬ Discuss
βœ… Correct Answer: (C) Criteria

Q. Which of the following is the DBMS type?

  • (A) Flat File System
  • (B) Hierarchical DBMS
  • (C) Relational DMBS
  • (D) All of the Above
πŸ’¬ Discuss
βœ… Correct Answer: (D) All of the Above

Q. Macros can recover from _______ in a controlled manner.

  • (A) Modules
  • (B) Events
  • (C) Errors
  • (D) Arguments
πŸ’¬ Discuss
βœ… Correct Answer: (B) Events

Q. To assign a macro to an event, users need to open the form in Design View.

  • (A) Macro
  • (B) Title
  • (C) Property
  • (D) Event
πŸ’¬ Discuss
βœ… Correct Answer: (D) Event

Q. A(n) ________ is the default control for a Yes/No field.

  • (A) List box
  • (B) Toggle button
  • (C) Option button
  • (D) Check box
πŸ’¬ Discuss
βœ… Correct Answer: (D) Check box

Q. Which of the following options is NOT a part of an option group?

  • (A) Option group button
  • (B) Option group label
  • (C) Option group frame
  • (D) Option button label
πŸ’¬ Discuss
βœ… Correct Answer: (A) Option group button

Q. In Access 2007, to set a table to open as a document tab, you need to go to the

  • (A) Navigation Pane
  • (B) Microsoft Office button
  • (C) Database Tools command tab
  • (D) Quick Access toolbar
πŸ’¬ Discuss
βœ… Correct Answer: (B) Microsoft Office button

Q. The ________ function returns a string that has been converted to uppercase text.

  • (A) Upper
  • (B) UpCase
  • (C) UCase
  • (D) AllCap
πŸ’¬ Discuss
βœ… Correct Answer: (C) UCase