Question 1

The first field specified in the sorting process is called the ____________________ field.

Accepted Answer

The answer of The first field specified in the sorting...

Question 2

Match between columns
                        Premises: The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

Accepted Answer

The Answer of Home and condition and Ctrl + End is...

Question 3

Match between columns
                        Premises: This type of datasheet displays temporary contents based on the criteria established in the design grid.

Accepted Answer

The Answer of logical operators and theme and condition and is...

Question 4

The accompanying figure illustrates the use of the ____________________ logical operator to define query criteria.

Accepted Answer

The answer of  
The accompanying figure illustrates the use...

Question 5

Match between columns
                        Premises: A dialog box used to enter text, expressions, or other values.

Accepted Answer

The Answer of query and Home and comparison operator and is...

Question 6

Match between columns
                        Premises: The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

Accepted Answer

The Answer of Ctrl + End and Home and condition is...

Question 7

Match between columns
                        Premises: The field used to determine the order of records in a datasheet.

Accepted Answer

The Answer of Zoom box and aggregate functions and Home is...

Question 8

Which method of adding all of the fields from a table to the design grid is best when record selection criteria will be used in the query?  How are the fields ordered in the design grid using this method?

Accepted Answer

The answer of Which method of adding all of the...

Question 9

Access queries provide several capabilities that allow data analysis and manipulation using tables and other Access database objects.  List five capabilities that allow for data analysis and manipulation in Access.

Accepted Answer

The answer of Access queries provide several capabilities that allow...

Question 10

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

Accepted Answer

The answer of A set of restrictions placed on records...

Question 11

Kyra has been asked to sort a database of cities and zip codes using a query.  The result should show records grouped by city with zip codes in ascending order within the city groups.  What is the best method for Kyra to use to achieve this result?

Accepted Answer

The answer of Kyra has been asked to sort a...

Question 12

Match between columns
                        Premises: Functions that perform arithmetic operations on selected records in a database.

Accepted Answer

The Answer of aggregate functions and condition and sort field is...

Question 13

In the accompanying figure, the VisitDate field is the ____________________ sort field in a sorted datasheet.

Accepted Answer

The answer of  
In the accompanying figure, the VisitDate...

Question 14

Match between columns
                        Premises: A criterion or rule that determines which records are selected when a query is run.

Accepted Answer

The Answer of logical operators and sort field and query is...

Question 15

Match between columns
                        Premises: The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Accepted Answer

The Answer of theme and Ctrl + End and condition is...

Question 16

Match between columns
                        Premises: A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

Accepted Answer

The Answer of condition and aggregate functions and logical operators is...

Question 17

Match between columns
                        Premises: Operators that allow two or more conditions to be combined such as And.

Accepted Answer

The Answer of Home and logical operators and condition and is...

Question 18

To change the order fields in the query design grid, move a field by selecting it and then  ____________________  it to the new location.

Accepted Answer

The answer of To change the order fields in the...

Quiz 4: Maintaining and Querying a Database

The first field specified in the sorting process is called the ____________________ field.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

The accompanying figure illustrates the use of the ____________________ logical operator to define query criteria.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Which method of adding all of the fields from a table to the design grid is best when record selection criteria will be used in the query? How are the fields ordered in the design grid using this method?

Access queries provide several capabilities that allow data analysis and manipulation using tables and other Access database objects. List five capabilities that allow for data analysis and manipulation in Access.

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

Kyra has been asked to sort a database of cities and zip codes using a query. The result should show records grouped by city with zip codes in ascending order within the city groups. What is the best method for Kyra to use to achieve this result?

Identify the letter of the choice that best matches the phrase or definition.

In the accompanying figure, the VisitDate field is the ____________________ sort field in a sorted datasheet.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

To change the order fields in the query design grid, move a field by selecting it and then ____________________ it to the new location.