Microsoft Access MCQs for Competitive Exams

151

What is the result of using the `OR` row in the query design grid?

A It requires a record to meet both the criteria on the "Criteria" row AND the criteria on the "Or" row. B It allows a record to be included if it meets the criteria on the "Criteria" row OR the criteria on the "Or" row. C It sorts the results in a different order. D It performs a logical NOT operation.

Answer & Solution Discuss Save Report

152

How do you include a field in your query but not show it in the results?

A Delete the field from the grid B Uncheck the "Show" checkbox for that field in the design grid C Change its data type to Hidden D You cannot hide a field that is used in a query

Answer & Solution Discuss Save Report

153

The `?` (question mark) wildcard in an Access query criterion represents:

A Any number of unknown characters B A single unknown character C A question from the user D An invalid character

Answer & Solution Discuss Save Report

154

The `SELECT` clause in an SQL statement specifies:

A The tables to use B The criteria for filtering C The fields (columns) to include in the result D The sort order

Answer & Solution Discuss Save Report

155

What is the purpose of a "Delete Query"?

A To delete a table from the database B To delete records from one or more tables that meet a certain criteria C To delete a query from the Navigation Pane D To remove a field from the query design

Answer & Solution Discuss Save Report

156

A query can be based on:

A Only one table B Only another query C One or more tables, or other queries D Only forms

Answer & Solution Discuss Save Report

157

What does the "Totals" row in the Query Design grid allow you to do?

A Perform aggregate calculations like Sum, Avg, Count, Max, Min on your data B Add a new row to the bottom of the results C Set the total number of records to be returned D Change the data type to Currency

Answer & Solution Discuss Save Report

158

Which of the following criteria would find all products with a price between $10 and $50 (inclusive)?

A `>10 OR <50` B `<10 AND >50` C `Between 10 And 50` D `10-50`

Answer & Solution Discuss Save Report

159

A query that creates a new table from the results of the query is called a:

A Select Query B Update Query C Make-Table Query D Delete Query

Answer & Solution Discuss Save Report

160

The SQL clause `ORDER BY` is used to:

A Filter the records B Sort the records C Join the tables D Select the fields

Answer & Solution Discuss Save Report