Q. The data in a Pivot Table report is categorized using

  • (A) Column headings
  • (B) Items from the Pivot Table field list
  • (C) Header rows
  • (D) All of above
πŸ’¬ Discuss
βœ… Correct Answer: (B) Items from the Pivot Table field list

Q. One of the type libraries that you can use to programmatically connect to Microsoft Access data is

  • (A) Collaborative Data Objects
  • (B) ActiveX Data Objects
  • (C) Dynamic Data Interfaces
  • (D) None of the above
πŸ’¬ Discuss
βœ… Correct Answer: (B) ActiveX Data Objects

Q. Which of the following is not a command to find specific word or phrases in a database?

  • (A) Click the find button on the toolbar
  • (B) Click the find button on the record navigation button area
  • (C) Press Ctrl+F
  • (D) Select Edit>Find from the menu.
πŸ’¬ Discuss
βœ… Correct Answer: (B) Click the find button on the record navigation button area

Q. Within Table Datasheet view, how can you display associated records from another table?

  • (A) Click the expand indicator (+) next to a record
  • (B) Double click the record.
  • (C) Apply the filter by form command
  • (D) None of the above
πŸ’¬ Discuss
βœ… Correct Answer: (A) Click the expand indicator (+) next to a record

Q. How do you freeze a field a column or field in Microsoft Access?

  • (A) Click anywhere in the column and select Edit>Freeze Column form the menu
  • (B) Place an ice cube in the column
  • (C) Click anywhere in the column and click the freeze button on the toolbar
  • (D) Right click the column and select freeze columns from the shortcut menu
πŸ’¬ Discuss
βœ… Correct Answer: (D) Right click the column and select freeze columns from the shortcut menu

Q. A good query system

  • (A) Can accept English language commands
  • (B) Allows non-programmers to access information stored in a database
  • (C) Can be accessed only by data prssing professionals
  • (D) Both (A) and (B)
πŸ’¬ Discuss
βœ… Correct Answer: (B) Allows non-programmers to access information stored in a database

Q. The ascending order of a data hierarchy ios:

  • (A) Bit, byte, field, record, file, database
  • (B) Bit, byte, record, field, file, database
  • (C) Byte, bit, field, record, file, database
  • (D) Byte, bit, record, field, file, database
πŸ’¬ Discuss
βœ… Correct Answer: (D) Byte, bit, record, field, file, database

Q. Which of the following columns can not be found in the macro design window?

  • (A) Arguments column
  • (B) Comment column
  • (C) Conditions column
  • (D) Actions column
πŸ’¬ Discuss
βœ… Correct Answer: (B) Comment column

Q. A report form

  • (A) Appears on the computer monitor during data entry
  • (B) Is used during report generation to format data
  • (C) Both (A) and (B)
  • (D) All of above
πŸ’¬ Discuss
βœ… Correct Answer: (B) Is used during report generation to format data

Q. It examines a small portion or sample of your data in a report before printing it.

  • (A) Datasheet view
  • (B) Design view
  • (C) Print preview
  • (D) Layout preview
πŸ’¬ Discuss
βœ… Correct Answer: (D) Layout preview

Jump to