Sail E0 Webinar

Computer Aptitude

MICROSOFT ACCESS MCQs

Total Questions : 168 | Page 17 of 17 pages
Question 161. Which data type should we use if we are planning to store a couple of paragraph or detailed description in a field?
  1.    Text
  2.    Para
  3.    Memo
  4.    Desc
 Discuss Question
Answer: Option C. -> Memo
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 162. The small button with three dots displayed at the right of field properties box is called :
  1.    Make Button
  2.    Expression Button
  3.    Build Button
  4.    None Of Above
 Discuss Question
Answer: Option C. -> Build Button
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 163. Which of the following shows the final result in a presentable way ?
  1.    Forms
  2.    Reports
  3.    Queries
  4.    Tables
 Discuss Question
Answer: Option B. -> Reports
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 164. A search value in SQL query can be a specific value or it can be ________
  1.    Logical Operator
  2.    Relationship
  3.    Wild card character
  4.    Comparison operation
 Discuss Question
Answer: Option C. -> Wild card character
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 165. What is the default and maximum size of text field in MS Access?
  1.    50 And 255 Characters
  2.    8 And 1 Gb
  3.    266 & 64000 Characters
  4.    8KB and 1.5 MB
 Discuss Question
Answer: Option A. -> 50 And 255 Characters
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 166. In MS Access, how can we create relationship between two tables in the GUI ?
  1.    Drag the foreign key of a table into the primary key of another table
  2.    Drag any field from parent table and drop on child table
  3.    Drag the primary key of a table into foreign key of another table
  4.    Any of these can be done to create relationship
 Discuss Question
Answer: Option C. -> Drag the primary key of a table into foreign key of another table
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 167. How can we remove a relationship defined between two tables ?
  1.    From Edit menu (by chosing Delete Relationship)
  2.    Select the relationship line and press Delete
  3.    Choose Delete option from Relationship menu
  4.    Choose Remove option from Relationship menu
 Discuss Question
Answer: Option B. -> Select the relationship line and press Delete
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 168. Which of the following storecommandto gather data from database?
  1.    Forms
  2.    Reports
  3.    Queries
  4.    Tables
 Discuss Question
Answer: Option C. -> Queries
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

Latest Videos

Latest Test Papers