πŸ“Š Database Management System (DBMS)
Q. What’s the best Access object for an invoice you’ll mail to customers?
  • (A) A report
  • (B) A form
  • (C) A table
  • (D) All of the above
πŸ’¬ Discuss
βœ… Correct Answer: (A) A report
πŸ“Š Database Management System (DBMS)
Q. What is the primary difference between a pivot table report and a cross tab query?
  • (A) A pivot table report can contain sums, counts, and averages while a cross tab query cannot.
  • (B) You can’t pivot a cross tab query
  • (C) A cross tab query lets you group similar items. A pitot table report does not
  • (D) None of above
πŸ’¬ Discuss
βœ… Correct Answer: (B) You can’t pivot a cross tab query
πŸ“Š Database Management System (DBMS)
Q. Need to see all the information from two tables on one form. Insert
  • (A) A page break
  • (B) A subform
  • (C) A linked command button
  • (D) None of the above
πŸ’¬ Discuss
βœ… Correct Answer: (B) A subform
πŸ“Š Database Management System (DBMS)
Q. COUNT command is used to
  • (A) Count the number of data fields in an active database file
  • (B) Count the number of data files which are active
  • (C) Count the records which are updated
  • (D) Count the number of records in an active database file
πŸ’¬ Discuss
βœ… Correct Answer: (D) Count the number of records in an active database file
πŸ“Š Database Management System (DBMS)
Q. A form that is used to collect data in a structured manner for entry to a database is called a
  • (A) Database deign form
  • (B) Systems flowchart
  • (C) Data capture form
  • (D) None of above
πŸ’¬ Discuss
βœ… Correct Answer: (C) Data capture form

Jump to