Sail E0 Webinar

MCQs

Total Questions : 229 | Page 23 of 23 pages
Question 221. What is the primary difference between a pivot table report and a cross tab query?
  1.    A pivot table report can contain sums, counts, and averages while a cross tab query cannot.
  2.    You can’t pivot a cross tab query
  3.    A cross tab query lets you group similar items. A pitot table report does not
  4.    None of above
 Discuss Question
Answer: Option B. -> You can’t pivot a cross tab query
Answer: (b)
Question 222. The following statement is not valid about indexing
  1.    it stores the index fields
  2.    it stores the corresponding record number
  3.    it maintains the alphabetically order
  4.    it duplicate the database file
 Discuss Question
Answer: Option D. -> it duplicate the database file
Answer: (d)
Question 223. Auto Form allows you to
  1.    View a subset of your data
  2.    Create a simple report
  3.    Create a data entry form
  4.    Enter records
 Discuss Question
Answer: Option B. -> Create a simple report
Answer: (b)
Question 224. A large collections of files are called
  1.    Fields
  2.    Records
  3.    Databases
  4.    File system
 Discuss Question
Answer: Option B. -> Records
Answer: (b)
Question 225. APPEND command is used to
  1.    Add record to the end of active database file and starts full screen data entry
  2.    Add Record to the start of active database file
  3.    Add record to the start of active database file and starts full screen data entry
  4.    Add record to the end of database file
 Discuss Question
Answer: Option A. -> Add record to the end of active database file and starts full screen data entry
Answer: (a)
Question 226. The ….. presents data in a way similar to an excel spreadsheet
  1.    Datasheet view
  2.    Design view
  3.    Print preview
  4.    Layout preview
 Discuss Question
Answer: Option C. -> Print preview
Answer: (c)
Question 227. What’s the best Access object for an invoice you’ll mail to customers?
  1.    A report
  2.    A form
  3.    A table
  4.    All of the above
 Discuss Question
Answer: Option A. -> A report
Answer: (a)
Question 228. An integrated collection of all of the data about your customers. Select the best fit for answer
  1.    Record
  2.    File
  3.    Database
  4.    Key field
 Discuss Question
Answer: Option B. -> File
Answer: (b)
Question 229. The data in a Pivot Table report is categorized using
  1.    Column headings
  2.    Items from the Pivot Table field list
  3.    Header rows
  4.    All of above
 Discuss Question
Answer: Option B. -> Items from the Pivot Table field list
Answer: (b)

Latest Videos

Latest Test Papers