Sail E0 Webinar

Computer Aptitude

MICROSOFT ACCESS MCQs

Total Questions : 168 | Page 16 of 17 pages
Question 151. How can we create a query in Microsoft Access ?
  1.    Drag and drop fields
  2.    Type the SQL
  3.    Use query wizard
  4.    All of above
 Discuss Question
Answer: Option D. -> All of above
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 152. Which field type can store photos?
  1.    Hyperlink
  2.    OLE Object
  3.    Both can be used
  4.    It is not possible
 Discuss Question
Answer: Option B. -> OLE Object
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 153. What is the shortcut key to switch between the field names and properties panels in table design view?
  1.    F3 Key
  2.    F4 Key
  3.    F5 Key
  4.    F6 Key
 Discuss Question
Answer: Option D. -> F6 Key
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 154. Which option allows us to build a new table by entering data directly into a tabular grid ?
  1.    Datasheet View
  2.    Design View
  3.    LinkedTable
  4.    Grid View
 Discuss Question
Answer: Option A. -> Datasheet View
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 155. When creating a new table which method can be used to choose fields from standard databases and tables
  1.    CreateTable In Design View
  2.    CreateTable Using Wizard
  3.    CreateTable by entering data
  4.    None of Above
 Discuss Question
Answer: Option B. -> CreateTable Using Wizard
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 156. How many characters you can type in maximum while writing the field name?
  1.    60
  2.    64
  3.    68
  4.    Any Number Of Character
 Discuss Question
Answer: Option B. -> 64
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 157. Queries in MS Access can be used ____________
  1.    To view data
  2.    As source for Forms
  3.    As source for Reports
  4.    All of These
 Discuss Question
Answer: Option D. -> All of These
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 158. Which one of these is the most common type of query that retrieves records from one or more tables and then displays the result in tabular form ?
  1.    Tabular Query
  2.    Crosstab Query
  3.    Select Query
  4.    Pivot Query
 Discuss Question
Answer: Option C. -> Select Query
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 159. Which of the following database object hold data?
  1.    Forms
  2.    Reports
  3.    Queries
  4.    Tables
 Discuss Question
Answer: Option D. -> Tables
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 160. Microsoft Access is a ______ kind of application ?
  1.    RDBMS
  2.    OODBMS
  3.    ORDBMS
  4.    Network Database Model
 Discuss Question
Answer: Option A. -> RDBMS
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Latest Videos

Latest Test Papers