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

Q. The largest unit of a database is

  • (A) A record
  • (B) A field
  • (C) A subfield
  • (D) None of above
πŸ’¬ Discuss
βœ… Correct Answer: (B) A field

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

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

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

Q. What is the term to ask the computer to pt information in order numerically or alphabetically ?

  • (A) Crop
  • (B) Report
  • (C) Sort
  • (D) Organize
πŸ’¬ Discuss
βœ… Correct Answer: (C) Sort

Q. The term refers to a collection of related information

  • (A) Database
  • (B) List
  • (C) Outline
  • (D) Record
πŸ’¬ Discuss
βœ… Correct Answer: (C) Outline

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

Q. The following command is used for inserting records

  • (A) INSERT
  • (B) ADD
  • (C) Both of the above
  • (D) None of the above
πŸ’¬ Discuss
βœ… Correct Answer: (A) INSERT

Jump to