Microsoft Access Questions and Answers

Practice Mode
Showing 10 of 94 questions
Q61
Which of the following type s of queries re action queries?
  • A Update Queries
  • B Crosstab Queries
  • C Parameter Queries
  • D Append Queries
Answer: Option D
Q62
A query prompts a user for a data and then displays only records that contain the specified date. The type of a query is this
  • A A parameter query
  • B A crosstab query
  • C An update query
  • D An action query
Answer: Option A
Q63
Which of the following is NOT A report section ?
  • A Reprt Header section
  • B Summary section
  • C Page header section
  • D Details section
Answer: Option B
Q64
You can display a database object in design view by
  • A Opening the database object and clicking the view button on the toolbar
  • B Selecting the database object and clicking the design button on the database window
  • C Selecting the database object and press Ctrl + V
  • D Opening the database object and selection Tools.Design view
Answer: Option B
Q65
If you are creating a cross tab query, what must table you are querying contain ?
  • A Lots of confusing information
  • B More than 100 records
  • C At least one field
  • D None of the above
Answer: Option C
Q66
A query summarizes information in grid, organized by regions and months. Which type of query is this ?
  • A A cross tab query
  • B An update query
  • C A parameter query
  • D An action query
Answer: Option A
Q67
What type of text box does the toolbox and to a form ?
  • A Unbound
  • B Bound
  • C Rebound
  • D Calculated
Answer: Option A
Q68
The filter by section feature allows you to filter
  • A Those records that match an entity in a field
  • B Records based on a criterion you specify
  • C Records that meet any of several criteria you specify
  • D All of above
Answer: Option A
Q69
What is the memo data type field used for ?
  • A To add table
  • B To store objects created in other programs
  • C For long text entries
  • D For shout text entries of no more than 255 characters
Answer: Option C
Q70
What is the purpose of the description column in Table Design View ?
  • A To define the data type applied to each field within the table
  • B To describe the data that should be entered in each field
  • C To entere lookup data that the field should refer to
  • D None of the above
Answer: Option B
Questions and Answers for Competitive Exams Various Entrance Test