Menu
Popular Courses
Search

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)

Share this page with your friends!

Share this page with your friends!

Latest Videos

Chapter 1 - GLOBAL STEEL SCENARIO & INDI Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Chapter 3.1 : Overview of Finance & Acco Chapter 3 : Finance & Accounts SAIL E0 - GFM 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management SAIL E0 - GFM 2024
Chapter 1.1 : Personnel Functions- An ov Chapter 1 : Personnel Management SAIL E0 - GFM 2024
GPOE / GPA Combined 1 Free CBT Mock Test SAIL E0 2024
CBT Mixed Test 1 GPOE/GPA SAIL E0 2024