MS Access MCQ with Answers

The Top Values property displays only the highest values from the query.

The Top Values property requires the fields to have a defined sort order.

The Top Values property finds a specified number of records.

The Top Values property finds a specified percentage of records.

A calculated field does not store data in a recordset.

Calculated fields use an expression or formula as its data source.

Data contained in a calculated field is created the first time a query is run.

A calculated field can be created using the Expression Builder dialog box.

Between

Is Null

Like

Not

Renormalizations

Filtering

Normalization

Sorting

It is used to graphically summarize and analyze data in a table, query, or form.

It can be used to view different levels of detail or to specify custom layout.

It displays field values that can be switched for different views of data.

It displays the same information as a crosstab query, except for the counts and sums of numeric fields.