Question 1

____ is the default entry for each field in the Total row of the query design grid.
A)Group By
B)SUM
C)Totals
D)Maximum

Accepted Answer

"Group By" is the default entry for each field in the Total row of the query design grid in Microsoft Access.

Question 2

A calculated field created in a query generates results when ____.
A)the database is opened
B)the query's underlying table is opened
C)when a report is created
D)when the query is run

Accepted Answer

A calculated field is generated based on a formula or expression defined in the query, and it will only generate results when the query is executed or run. It will not generate results when the database or report is opened or when the underlying table is opened.

Question 3

The + symbol is an example of a(n)____ operator.
A)arithmetic
B)logical
C)comparison
D)calculation

Accepted Answer

The + symbol is used for addition which is an arithmetic operation. Arithmetic operators include addition, subtraction, multiplication, and division. Logical operators involve boolean logic (AND, OR, NOT). Comparison operators are used to compare values (>, <, ==). Calculation is a general term that can include any type of mathematical operation.

Question 4

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

Accepted Answer

The answer of Typing a value in a highlighted field...

Question 5

Which aggregate function would be used to calculate the lowest field value for the selected records?
A)Average
B)Minimum
C)Maximum
D)Count

Accepted Answer

The aggregate function used to calculate the lowest field value for the selected records is Minimum. Therefore, the best choice is B.

Question 6

The default group in the Navigation Pane is ____.
A)Object Type
B)All Access Objects
C)Table
D)Design Grids

Accepted Answer

The default group in the Navigation Pane is "All Access Objects," which displays all objects in the current database, including tables, queries, forms, reports, macros, and modules. This is the most comprehensive option and allows users to quickly access all objects in the database.

Question 7

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?
A)Query Type
B)Show/Hide
C)Query Setup
D)Results

Accepted Answer

The Query Setup group on the Query DESIGN tab of the Ribbon contains the Expression Builder dialog box.

Question 8

The default name for a new Access query is ____________________.

Accepted Answer

The answer of The default name for a new Access...

Question 9

The ___________________ command allows hidden fields to be redisplayed.

Accepted Answer

The answer of The ___________________ command allows hidden fields to...

Question 10

Which aggregate function supports the Yes/No field data type?
A)Count
B)Average
C)Minimum
D)Sum

Accepted Answer

The Count function can be used with Yes/No fields to count the number of records where the field is Yes (True).

Question 11

Which comparison operator matches a pattern that includes wildcards?
A)Between...And...
B)Or
C)Not
D)Like

Accepted Answer

The "Like" comparison operator matches a pattern that includes wildcards. It can be used with the % symbol to represent any number of characters and the _ symbol to represent a single character.

Question 12

A calculated field is formatted using the ____ for the field.
A)Property Sheet
B)Criteria
C)Expression Builder
D)Operator

Accepted Answer

The Property Sheet is used to format a calculated field, which includes setting properties such as data type, decimal places, and formatting masks. Criteria is used to filter data in a query or form, Expression Builder is used to create complex calculations or expressions, and Operator is used to perform mathematical operations in a formula. However, none of these options are directly related to formatting a calculated field.

Question 13

Statistical information such as totals and averages is calculated using ____.
A)comparison operators
B)mathematical operators
C)aggregate functions
D)logical functions

Accepted Answer

Aggregate functions are specifically designed to calculate statistical information such as totals and averages. Comparison and logical operators are used to compare values or evaluate expressions, while mathematical operators perform basic arithmetic operations.

Question 14

After creating the query,Jorge must set criteria to have the query return only those plants that need full sun. Entries for the Amount of Sun field include: partial sun,little sun,and full sun.How should Jorge enter the criteria for the exact match of full sun? A)=>full sun B)<=fullsun C)<> full sun D)"full sun"

Accepted Answer

To specify an exact match, Jorge should use quotation marks around the term "full sun". This ensures that the query will only return results where the Amount of Sun field contains the exact phrase "full sun", rather than partial or little sun as well.

Question 15

To locate a specific field value or part of a field value,a user may search a table datasheet,a query datasheet,or a form using the ____________________.

Accepted Answer

The answer of To locate a specific field value or...

Question 16

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.
A)SUM
B)New Row
C)Totals
D)Add All

Accepted Answer

Clicking the "Totals" button in the Show/Hide group on the DESIGN tab on the Ribbon allows you to add a row labeled "Total" to a query design.

Question 17

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.
A)Table Name
B)Custom
C)Query Name
D)Relationship

Accepted Answer

Custom categories allow for flexibility in grouping objects in a way that suits the specific needs of the database, rather than being limited to pre-defined categories such as table names, query names, or relationships.

Question 18

To create a datasheet that lists all herbs that are Perennials,Jorge will create a new query. The Perennial field has a data type of Yes/No. Which criterion should Jorge use in the query for the Perennial field?
A)Yes
B)>No
C)check=yes
D)'yes'

Accepted Answer

Jorge should use the criterion "Yes" for the Perennial field, as this will only show results where the Perennial field has a value of "Yes". The other options are incorrect as they either include results where the field is null or could potentially include results where the value is not actually "Yes".

Question 19

When creating a query to determine which plants need full sun,which fields must be included in the query?
A)Plant Name and When to Plant
B)Amount of Sun and Annual
C)Plant Name and Amount of Sun
D)Amount of Sun and When to Plant

Accepted Answer

The fields that must be included in the query to determine which plants need full sun are the Plant Name and Amount of Sun. The Amount of Sun field will specify if a plant needs full sun, partial sun, or shade. The Plant Name field is necessary to identify the plants that require full sun. The other fields, such as When to Plant and Annual, are not relevant to determining which plants need full sun.

Question 20

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

Accepted Answer

The answer of The _________________ prompts for information by asking...

Quiz 3: Maintaining and Querying a Database

____ is the default entry for each field in the Total row of the query design grid.

A calculated field created in a query generates results when ____.

The + symbol is an example of a(n) ____ operator.

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

Which aggregate function would be used to calculate the lowest field value for the selected records?

The default group in the Navigation Pane is ____.

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

The default name for a new Access query is ____________________.

The ___________________ command allows hidden fields to be redisplayed.

Which aggregate function supports the Yes/No field data type?

Which comparison operator matches a pattern that includes wildcards?

A calculated field is formatted using the ____ for the field.

Statistical information such as totals and averages is calculated using ____.

After creating the query,Jorge must set criteria to have the query return only those plants that need full sun. Entries for the Amount of Sun field include: partial sun,little sun,and full sun.How should Jorge enter the criteria for the exact match of full sun?

To locate a specific field value or part of a field value,a user may search a table datasheet,a query datasheet,or a form using the ____________________.

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

To create a datasheet that lists all herbs that are Perennials,Jorge will create a new query. The Perennial field has a data type of Yes/No. Which criterion should Jorge use in the query for the Perennial field?

When creating a query to determine which plants need full sun,which fields must be included in the query?

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.