Sail E0 Webinar

Computer Aptitude

MICROSOFT ACCESS MCQs

Total Questions : 168 | Page 13 of 17 pages
Question 121. The type of query extract the data and put them into separate table
  1.    A parameter query
  2.    A make-table query
  3.    An update query
  4.    A crosstab query
 Discuss Question
Answer: Option B. -> A make-table query
Answer: (b)
Question 122. Which field type will you select if you need to enter long text in that field?
  1.    Text
  2.    Memo
  3.    Currency
  4.    Hyperlink
 Discuss Question
Answer: Option B. -> Memo
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 123. The expression builder is an access tool that controls an expression___ for entering an expression
  1.    Table
  2.    Box
  3.    Cell
  4.    Palette
 Discuss Question
Answer: Option B. -> Box
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 124. Which of the following is not a type of MS Access databaseobject?
  1.    Table
  2.    Form
  3.    Worksheets
  4.    Modules
 Discuss Question
Answer: Option C. -> Worksheets
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 125. The size of yes/no field is always ________
  1.    1 Bit
  2.    1 Byte
  3.    1 Character
  4.    1 KB
 Discuss Question
Answer: Option A. -> 1 Bit
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 126. Which of the following option creates a Drop Down List of values ?
  1.    Ole Object
  2.    Hyperlink
  3.    Memo
  4.    Lookup Wizard
 Discuss Question
Answer: Option D. -> Lookup Wizard
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 127. What does the show check box in query design window indicate ?
  1.    It indicates whether the field is to be used or not.
  2.    It indicates whether the field is to be displayed in query result or not
  3.    It indicates whether the field names to be displayed in query result or not.
  4.    It indicates whether the field is to be used for grouping result or not.
 Discuss Question
Answer: Option B. -> It indicates whether the field is to be displayed in query result or not
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 128. In which method we don't need to specify the field type and size while creating a new Table?
  1.    Design View
  2.    While using Wizard
  3.    CreateTable By Entering Data
  4.    All of Above
 Discuss Question
Answer: Option C. -> CreateTable By Entering Data
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 129. Ho can you edit a relationship already established between two tables?
  1.    Right click the relationship line and choose Edit Relationship
  2.    Double click the relationship line
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option C. -> Both of above
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 130. The size of a field with number data type can not be _____
  1.    2
  2.    4
  3.    8
  4.    16
 Discuss Question
Answer: Option D. -> 16
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Latest Videos

Latest Test Papers