Question 1

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 when the query is run as it involves performing calculations on the data during the execution of the query.

Question 2

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 3

____ 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 a user-defined grouping of objects that may be more logical or practical than the default groupings based on object type. This can improve the organization and management of the database in the Navigation Pane. The other options listed are not relevant to creating custom categories.

Question 4

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

Accepted Answer

The + symbol is used to perform addition, which is an arithmetic operation. Logical operators include && (logical AND), || (logical OR), and ! (logical NOT). Comparison operators include == (equal to), != (not equal to), < (less than), > (greater than), <= (less than or equal to), and >= (greater than or equal to). Calculation is a general term and not a specific type of operator.

Question 5

The default name for a new Access query is ____________________.

Accepted Answer

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

Question 6

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 7

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

Accepted Answer

The comparison operator that matches a pattern with wildcards is the "LIKE" operator. It allows the use of the "%" symbol as a wildcard to represent any number of characters, and the "_" symbol to represent a single character. For example, "LIKE 'a%'" would match any string that starts with the letter "a", followed by any number of characters.

Question 8

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

Accepted Answer

The Count aggregate function supports the Yes/No field data type. It counts the number of records that have the Yes value (True) in a Yes/No field. It does not count records with No value (False) or records with Null value in the field.

Question 9

Case-Based Critical Thinking Questions
Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name,When to Plant,Amount of Sun,Annual,and Perennial.  He needs to answer the following questions using his database.
Which plants need full sun?
Which plants are Perennials?
- 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" in the query for the Perennial field to list all herbs that are Perennials. This criterion will filter the data and only show items where the Perennial field has a value of "Yes".

Question 10

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 11

____ 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

The answer of  ____ is the default entry for each...

Question 12

Case-Based Critical Thinking Questions
Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name,When to Plant,Amount of Sun,Annual,and Perennial.  He needs to answer the following questions using his database.
Which plants need full sun?
Which plants are Perennials?
- 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 13

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 answer of  The Expression Builder dialog box is available...

Question 14

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 minimum aggregate function would calculate the lowest field value for the selected records. The average aggregate function calculates the average value of a field, the maximum function calculates the highest value of a field, and the count function counts the number of records in a selection.

Question 15

Case-Based Critical Thinking Questions Jorge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name,When to Plant,Amount of Sun,Annual,and Perennial. He needs to answer the following questions using his database. Which plants need full sun? Which plants are Perennials? - 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

Jorge should use quotation marks around the text "full sun" to search for an exact match of the phrase in the Amount of Sun field. Options A and B use symbols that are used for numerical comparisons, not text matches. Option C searches for all entries except for "full sun", which is not what Jorge needs.

Question 16

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 for performing statistical calculations on sets of values, such as calculating totals and averages. Comparison operators are used to compare values, mathematical operators perform basic arithmetic operations, and logical functions evaluate whether a condition is true or false.

Question 17

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

Question 18

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 19

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 allows for the formatting of a calculated field, including setting the data type and format of the field. The criteria, expression builder, and operator are all used in creating the formula for the calculated field but do not involve formatting.

Question 20

The ___________________ command allows hidden fields to be redisplayed.

Accepted Answer

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

Quiz 3: Maintaining and Querying a Database

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

The default group in the Navigation Pane is ____.

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

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

The default name for a new Access query is ____________________.

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

Which comparison operator matches a pattern that includes wildcards?

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

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.

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

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

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

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

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

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

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

The ___________________ command allows hidden fields to be redisplayed.