Question 1

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?
A) crosstab
B) append
C) query by example (QBE)
D) update

Accepted Answer

Query by example (QBE) provides a graphical representation of the required query, where users can provide an example of the data they are searching for. Access then retrieves information based on precisely matching that example.

Question 2

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.

Accepted Answer

This is because a query is only a view of the data in the underlying table, and any changes made to a query datasheet will update the corresponding record in the table.

Question 3

It is more efficient to use the Query Wizard for common, informational queries than to design your own query.

Accepted Answer

False

Question 4

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.
A) Run
B) Append
C) Show
D) Design

Accepted Answer

The answer of Results of a query may be viewed...

Question 5

A sort field is unique if more than one record can have the same value for the sort field.

Accepted Answer

nonunique

Question 6

Hiding a field in Datasheet view removes the field from the current table.

Accepted Answer

Hiding a field in Datasheet view only hides the column and does not remove the field from the current table.

Question 7

Access may base queries on one or more tables or queries .

Accepted Answer

Access provides the option to create queries based on one or more tables or queries. This allows users to extract data from multiple sources and combine them into a single result set.

Question 8

Fields included in a query may be modified after the query is saved.

Accepted Answer

Fields included in a query can be modified after the query is saved.

Question 9

Expression Builder is found in the Query Setup group on the DESIGN tab.

Accepted Answer

Expression Builder is indeed found in the Query Setup group on the DESIGN tab in Microsoft Access.

Question 10

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.

Accepted Answer

Pressing the F2 keyboard shortcut toggles between navigation mode and editing mode.

Question 11

When a question is asked of a database using a select query, the answer is returned as a data sheet.

Accepted Answer

When a select query is executed on a database, the result is returned in the form of a data sheet or a table containing the information that matches the specified criteria.

Question 12

The process of rearranging records in a specified order or sequence is referred to as sorting .

Accepted Answer

Sorting involves arranging records in a specific order or sequence.

Question 13

The contents of query datasheet are permanent .

Accepted Answer

temporary

Question 14

It is not possible to create a query from more than one table.

Accepted Answer

It is possible to create a query from more than one table using JOIN statements.

Question 15

Results of a query are narrowed by using the Or logical operator.

Accepted Answer

The Or logical operator is used to broaden the results of a query by including multiple criteria. To narrow the results, the And operator is used.

Question 16

Arithmetic operations are performed on selected records in a database using Statistical functions.

Accepted Answer

Arithmetic operations are performed on individual data values, while statistical functions are used to analyze and summarize data across multiple records.

Question 17

The default query type for Access is the Crosstab query.

Accepted Answer

The default query type for Access is the Select query, not the Crosstab query.

Question 18

The most simple technique to use for filtering records is Filter By Form .

Accepted Answer

Filter By Selection

Question 19

Access database objects are divided into categories on the Navigation Pane.

Accepted Answer

The Navigation Pane in Access allows for easy access to various objects such as tables, forms, queries, and more. These objects are organized into categories such as Tables, Queries, Forms, and Reports.

Question 20

Logical operators must be used in order to combine two or more conditions in a query.

Accepted Answer

Logical operators such as AND, OR, and NOT are used to combine two or more conditions in a query. This allows for more complex and specific searches to be performed on a database.

Quiz 3: Access Module Maintaining and Querying a Database

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?