Question 1

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

Accepted Answer

The Navigation Pane in Access allows for easy organization and access to database objects, which are categorized into specific groups such as Tables, Queries, Forms, Reports, etc.

Question 2

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

Accepted Answer

True

Question 3

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

Accepted Answer

Access can base its queries on one or more tables or queries.

Question 4

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

Accepted Answer

Hiding a field in Datasheet view only hides the field temporarily from the current view, but it does not remove the field from the underlying table or permanently.

Question 5

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

Accepted Answer

Filter By Selection

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

In the accompanying figure, the sort order for the VisitDate field is descending . ____________________

Accepted Answer

The statement in the question indicates that the sort order for the VisitDate field is descending, which means it is sorted in reverse chronological order (from newest to oldest). Therefore, the answer is true.

Question 8

In the accompanying figure, a criterion is set for a field in the Visit table. ____________________

Accepted Answer

The answer of  
In the accompanying figure, a criterion...

Question 9

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

Accepted Answer

It is possible to create a query from multiple tables through the use of joins, subqueries, or unions.

Question 10

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

Accepted Answer

Sorting is the process of arranging records in a specific order or sequence, such as alphabetical, numerical or chronological.

Question 11

The contents of query datasheet are permanent . ____________________

Accepted Answer

temporary

Question 12

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

Accepted Answer

Expression Builder tool can be found in the Query Setup group on the DESIGN tab in Microsoft Access.

Question 13

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

Accepted Answer

When a select query is executed on a database, the result set is returned in the form of a datasheet, which displays the selected data in a tabular form.

Question 14

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.

Question 15

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

Accepted Answer

nonunique

Question 16

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

Accepted Answer

The Or logical operator expands the results of a query by including results that match any of the specified criteria. To narrow down the results, the And logical operator should be used.

Question 17

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

Accepted Answer

Fields in a query can be modified after it is saved by opening the query in design view and adjusting the fields as needed.

Question 18

The default query type for Access is the Crosstab query.

Accepted Answer

The default query type for Access is the Select query, which is used for retrieving data from one or more tables. The Crosstab query is a specialized type of query used for pivot table analysis, but it is not the default query type.

Question 19

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

Accepted Answer

When you make changes to a field in a query datasheet, it updates the same field in the table on which the query is based.

Question 20

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

Accepted Answer

Arithmetic operations are performed on fields/attributes/variables in a database using Arithmetic functions. Statistical functions are used to perform calculations such as averages, standard deviations, correlations, and regression analysis on selected records or groups of records in a database.

Quiz 4: Maintaining and Querying a Database