Question 1

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

Accepted Answer

Filter By Selection

Question 2

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

Accepted Answer

aggregate

Question 3

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

Accepted Answer

Sorting involves arranging records according to a specific order or sequence, such as alphabetical, numerical, or chronological order. It is true that sorting is the process of rearranging records in a specified order or sequence.

Question 4

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

Accepted Answer

Any changes made to a field in a query datasheet will update the same field in the table on which the query is based.

Question 5

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

The query by example (QBE) is the type of query that gives Access an example of the information being requested and retrieves information based precisely on matching the example. With QBE, the user enters specific field values in a grid which serve as the criteria for the query. This can help users who are not familiar with SQL to easily retrieve data from a database. Crosstab, append, and update queries perform different functions.

Question 6

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

Accepted Answer

The answer of It is more efficient to use the...

Question 7

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 "Run" button in the Results group on the Ribbon is used to execute a query and view its results.

Question 8

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

Accepted Answer

nonunique

Question 9

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 as a set of data organized in the form of a table or data sheet. Therefore, the statement is true.

Question 10

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

Accepted Answer

This is correct. Pressing the F2 keyboard shortcut toggles between navigation mode and editing mode in various applications and programs.

Question 11

The default query type for Access is the Crosstab query.____________________

Accepted Answer

The default query type for Access is the Select query.

Question 12

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

Accepted Answer

This statement is true. Access allows for creating queries based on one or more tables or queries.

Question 13

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.

Question 14

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

Accepted Answer

This is true. Fields can be added, removed or modified in a query after it is saved.

Question 15

The contents of query datasheet are permanent.____________________

Accepted Answer

temporary

Question 16

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

Accepted Answer

The Or logical operator actually expands the results of a query by including records that meet either one of two or more conditions. It does not narrow the results. Therefore, the statement is false.

Question 17

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

Accepted Answer

Hiding a field in Datasheet view only removes it from view in that particular view, but the field itself still exists in the table. It can be displayed again by customizing the view.

Question 18

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 multiple conditions in a query.

Question 19

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

Accepted Answer

This statement is true. The Navigation Pane in Access organizes database objects into categories such as Tables, Queries, Forms, Reports, Macros, and Modules.

Question 20

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 clauses.

Quiz 3: Maintaining and Querying a Database