Question 1

Press and hold down the ____ key to select multiple columns.
A)Ctrl
B)Esc
C)F1
D)Shift

Accepted Answer

Pressing and holding down the Shift key allows you to select multiple columns by clicking on the column headers.

Question 2

The ____ property for a query lets you limit the number of records in the query results.
A)Limit
B)Show Records
C)Top Values
D)Restrict

Accepted Answer

The "Top Values" property in a query is used to limit the number of records returned in the query results by specifying a certain number or percentage of top records.

Question 3

A(n)____ match selects records whose value for the selected field matches one of two or more simple condition values.
A)list-of-values
B)exact
C)position
D)pattern

Accepted Answer

A list-of-values match selects records whose value for the selected field matches one of two or more simple condition values.

Question 4

As shown in the above figure a ____ query prompts you for information when the query runs.
A)parameter
B)list-of-values
C)pattern
D)logical

Accepted Answer

A parameter query prompts the user to enter specific criteria when the query is run. It allows for more dynamic and customizable queries. List-of-values queries display a list of options for the user to choose from and pattern queries use wildcard characters to search for specific patterns in the data. Logical queries simply use boolean logic to filter data.

Question 5

Of the aggregate functions shown in the figure above the ____ function returns the standard deviation of the field values in a selection of records.
A)StDev
B)Var
C)Sum
D)Count

Accepted Answer

The StDev function returns the standard deviation of the field values in a selection of records. The Var function returns the variance of the field values, which is not the same as the standard deviation. The Sum function returns the sum of the field values, the Count function returns the number of records in a selection.

Question 6

When you use the ____ comparison operator if a record's field value matches one value from the list of defined values then Access selects and includes that record in the query results.
A)As
B)Like
C)In
D)Or

Accepted Answer

The "In" comparison operator is specifically designed to match a record's field value with a list of defined values. Using "In" in your query allows you to specify multiple possible values for a field and retrieve all records whose values match any of the values in the list. This saves you the time and effort of running separate queries for each individual value.

Question 7

The ____ comparison operator lets you define a condition with two or more values.
A)Like
B)In
C)As
D)Or

Accepted Answer

The "In" comparison operator is used to define a condition with two or more values. For example, you can use it to search for a specific value within a list of values. The other options listed (Like, As, Or) do not serve this purpose.

Question 8

You can change a select query to a crosstab query in Design view using the Crosstab button in the Query Type group on the ____ tab.
A)Crosstab
B)Query Tools Design
C)Selection
D)Wizard

Accepted Answer

The Crosstab button is located in the Query Tools Design tab, so the best choice is B. The Crosstab button allows you to quickly convert a select query into a crosstab query by rearranging the fields in the query design grid. The other choices (A, C, and D) are not relevant to changing a select query to a crosstab query.

Question 9

Which of the following commands is used to keep selected columns visible no matter where you scroll in the datasheet?
A)Keep Visible
B)No Scroll
C)Display Columns
D)Freeze

Accepted Answer

The command used to keep selected columns visible no matter where you scroll in the datasheet is Freeze. It is commonly used to freeze the leftmost columns which contain important information and keeping them visible while scrolling.

Question 10

What you could accomplish with several Or conditions in the design grid you can do more easily with the ____ comparison operator.
A)Like
B)In
C)As
D)Or

Accepted Answer

The IN comparison operator allows you to specify multiple values in one expression, making it easier and more efficient than using several OR conditions in the design grid. For example, instead of writing "OR Country = 'USA' OR Country = 'Canada' OR Country = 'Mexico' OR Country = 'Brazil' OR Country = 'Argentina'", you can simply write "Country IN ('USA', 'Canada', 'Mexico', 'Brazil', 'Argentina')".

Question 11

The ____ logical operator negates a criterion.
A)Nor
B)Or
C)Not
D)Nand

Accepted Answer

The "Not" logical operator is used to negate a criterion, meaning it reverses the logic of a statement. For example, if the criterion is "X is less than 5," applying the Not operator would result in "X is not less than 5." This operator is essential in creating complex logical statements and making decisions based on multiple criteria.

Question 12

Aggregate functions like those shown in the above figure perform ____ operations on selected records in a database.
A)composite
B)comparative
C)join
D)arithmetic

Accepted Answer

Aggregate functions, as shown in the figure, perform arithmetic operations on selected records in a database. Examples of aggregate functions include SUM, AVG, MIN, MAX, COUNT, etc.

Question 13

The aggregate function ____ returns the total of the field values in a selection of records.
A)Sum
B)Tot
C)Total
D)Aggr

Accepted Answer

The correct aggregate function for returning the total of field values in a selection of records is the Sum function. Option B (Tot) is not a valid aggregate function, and Option C (Total) may be mistaken with the name of a table or field. Option D (Aggr) is not a recognized aggregate function.

Question 14

Of the aggregate functions shown in the figure above the ____ function returns the lowest of the field values in a selection of records.
A)Avg
B)First
C)Min
D)Last

Accepted Answer

The MIN function returns the lowest value in a selection of records.

Question 15

Of the aggregate functions shown in the above figure the ____ function returns the average of the field values in a selection of records.
A)Count
B)Avg
C)Var
D)StDev

Accepted Answer

The average function (Avg) returns the average of the values in a selected field.

Question 16

The Freeze command is available in the ____ group on the Home tab under the More button.
A)File
B)View
C)Records
D)Table

Accepted Answer

The Freeze command is available in the Records group on the Home tab under the More button in certain software applications like Microsoft Access.

Question 17

Of the aggregate functions shown in the above figure the ____ function returns the highest of the field values in a selection of records.
A)Max
B)StDev
C)Min
D)Avg

Accepted Answer

The Max function is specifically designed to return the highest value in a selection of records.

Question 18

In the Input Mask Wizard the practice area is called the ____ text box.
A)Sample
B)Try It
C)Practice
D)Experiment

Accepted Answer

In the Input Mask Wizard, the practice area is referred to as the "Try It" text box, where users can test how their input mask works.

Question 19

A(n)____ query performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format.
A)aggregate
B)function
C)crosstab
D)Both A and B

Accepted Answer

A crosstab query is the type of query that performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format. This type of query allows you to summarize and analyze data in a way that is easy to read and understand, making it a useful tool for decision-making and reporting. Options A and B are incorrect because while they are elements of a crosstab query, they do not fully describe what a crosstab query is or does.

Question 20

A find ____ query is a select query that finds all records in a table or query that have no related records in a second table or query.
A)unrelated
B)unmatched
C)free
D)empty

Accepted Answer

The term "unmatched" indicates a record that does not have a match in a second table or query. Therefore, a find unmatched query would be the best choice to find all records in a table or query that have no related records in a second table or query.

Quiz 1: Access: Creating Advanced Queries and Enhancing Table Design

Press and hold down the ____ key to select multiple columns.

The ____ property for a query lets you limit the number of records in the query results.

A(n) ____ match selects records whose value for the selected field matches one of two or more simple condition values.

As shown in the above figure a ____ query prompts you for information when the query runs.

Of the aggregate functions shown in the figure above the ____ function returns the standard deviation of the field values in a selection of records.

When you use the ____ comparison operator if a record's field value matches one value from the list of defined values then Access selects and includes that record in the query results.

The ____ comparison operator lets you define a condition with two or more values.

You can change a select query to a crosstab query in Design view using the Crosstab button in the Query Type group on the ____ tab.

Which of the following commands is used to keep selected columns visible no matter where you scroll in the datasheet?

What you could accomplish with several Or conditions in the design grid you can do more easily with the ____ comparison operator.

The ____ logical operator negates a criterion.

Aggregate functions like those shown in the above figure perform ____ operations on selected records in a database.

The aggregate function ____ returns the total of the field values in a selection of records.

Of the aggregate functions shown in the figure above the ____ function returns the lowest of the field values in a selection of records.

Of the aggregate functions shown in the above figure the ____ function returns the average of the field values in a selection of records.

The Freeze command is available in the ____ group on the Home tab under the More button.

Of the aggregate functions shown in the above figure the ____ function returns the highest of the field values in a selection of records.

In the Input Mask Wizard the practice area is called the ____ text box.

A(n) ____ query performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format.

A find ____ query is a select query that finds all records in a table or query that have no related records in a second table or query.