Microsoft Access MCQ Question and Answer
Microsoft Access MCQ Question and Answer
61. Which of the following type s of queries re action queries?
- Update Queries
- Crosstab Queries
- Parameter Queries
- Append Queries
62. 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 parameter query
- A crosstab query
- An update query
- An action query
63. Which of the following is NOT A report section ?
- Reprt Header section
- Summary section
- Page header section
- Details section
64. You can display a database object in design view by
- Opening the database object and clicking the view button on the toolbar
- Selecting the database object and clicking the design button on the database window
- Selecting the database object and press Ctrl + V
- Opening the database object and selection Tools.Design view
65. If you are creating a cross tab query, what must table you are querying contain ?
- Lots of confusing information
- More than 100 records
- At least one field
- None of the above
66. A query summarizes information in grid, organized by regions and months. Which type of query is this ?
- A cross tab query
- An update query
- A parameter query
- An action query
67. What type of text box does the toolbox and to a form ?
- Unbound
- Bound
- Rebound
- Calculated
68. The filter by section feature allows you to filter
- Those records that match an entity in a field
- Records based on a criterion you specify
- Records that meet any of several criteria you specify
- All of above
69. What is the memo data type field used for ?
- To add table
- To store objects created in other programs
- For long text entries
- For shout text entries of no more than 255 characters
70. What is the purpose of the description column in Table Design View ?
- To define the data type applied to each field within the table
- To describe the data that should be entered in each field
- To entere lookup data that the field should refer to
- None of the above