How can we help?

You can also find more resources in our Help Center.

55 terms

Database Ch. 3/4

STUDY
PLAY
A selection condition that dictates that the value in the specified field must precisely match the condition is known as a(n) ____ match.
Exact
You can tell Access which records are to be selected by specifying a(n) ____.
condition
Access provides query capabilities that allow you to update data in the tables in a database.
true
If more than one sort field has been selected, the first one is called the primary sort key and the others are called related sort fields.
false
To choose fields for a select query in Design view, _____.
both a and b
When you sort a field with a Yes/No data type in ____ sort order, the no values display first, followed by the yes values.
descending
In the condition InvoiceAmt > 100 and InvoiceAmt <>200, ">" and "<>" are ____.
comparison operators
Pine Hill Music School After reviewing the Pinehill database, Yuka Koyama wants to modify some records and then view specific information about the students, teachers, and contracts for her music school. She asks you to update and then query the Pinehill database to perform these tasks.

Yuka wants to change to an alternating background color for the rows in the Current Guitar Lesson datasheet. To do this she would use the ____ button.
Alternate row color
A query can be run at any time during the creation of the query by clicking the ____ button in the Results group on the Query Tools Design tab.
view
The Navigation Pane divides database objects into categories, and each category contains
groups
true
Specialized and technical queries can be easily created using the Query Generator.
false
A ____ datasheet is temporary, and its contents are based on the criteria you establish in the design grid.
query
When viewing a two-table query in Design view, which is not an indicator of whether the tables have a one-to-many relationship?
the fact that you have not enforced referential integrity
When you save a query with sort fields defined in it, the sort fields ____
are saved with the query
One example of a predefined function in Access is the Count function, which determines ____.
the number of records selected
Values that are produced by calculated fields should be stored in a table
false
The symbols for the Access comparison operator for not equal to are _____.
< >
Parkhurst Health & Fitness Center Martha Parkhurst needs to change a few records in the Fitness database, and analyze the records for members enrolled in different programs at the fitness center.

Martha would like to create a list of all the aerobics classes being held in the Red room and in the Blue room. Which of the following comparison operators would work
In ("Red", "Blue")
Multiple selection conditions can be specified in a query by using relational operators.
false
The ____ comparison operator selects records that match a pattern that includes wildcards.
Like
A calculation can be defined in a query by typing it directly into a Field box in the ____.
design grid
Rossi Recycling Group Tom Rossi needs to modify some records in the Rossi database, and then he wants to find specific information about the donors, agencies, and donations to his not-for-profit agency. Tom asks you to help him update the database and create queries.

To create a query that displays the Donor Name, Agency, Donations, and Date fields for all donors who are not from Illinois or who have donated in the month of June 2010, Tom should use a(n) ____.
OR logical operator
Queries can be created by using the Query ____, which prompts you for the information required to build the query.
wizard
In order to delete a record in a table, you must first ____.
delete any related records in a subdatasheet
You must place Text values inside parentheses when using these values as selection criteria.
false
When a query is run, the datasheet contents are ____.
temporary
A ____ datasheet is temporary, and its contents are based on the criteria you establish in the design grid.
query
A sort field is unique if more than one record can have the same value for the sort field.
false
Parkhurst Health & Fitness Center Martha Parkhurst needs to change a few records in the Fitness database, and analyze the records for members enrolled in different programs at the fitness center.

Martha knows that if she is selecting fields using a condition, she does not need to use the default operator because it is optional. Which one of the following is the default operator
=
n navigation mode, you can insert or delete characters in a field value based on the location of the insertion point.
false
Rossi Recycling Group Tom Rossi needs to modify some records in the Rossi database, and then he wants to find specific information about the donors, agencies, and donations to his not-for-profit agency. Tom asks you to help him update the database and create queries.

Tom wants to create a single query to display the sum, average, and count of the Donation Value field for all donations. To do this, he must double-click the Donation Value field ___
three times
The ____ is a dialog box used to enter text, expressions, and other values.
zoom box
The AutoNumber, Currency, Date/Time, Memo, Number, OLE Object, Text, and Yes/No data types all support the Max aggregate function
false
The default All Access Objects category is a predefined category.
true
One way to transfer all the fields from the field list to the design grid is to double-click the asterisk in the field list. The advantage of using this method is that changes to the table structure are reflected automatically in the query
true
Multiple conditions can be defined to control which records are selected through the use of ____.
logical operators
To divide records into groups based on the values in a specified field, you would use the ____ operator.
group by
Generalized queries that specify fields and records to be selected are called ____ queries.
select
Rearranging the order of records is called resequencing.
false
Selection criteria that are placed in different rows in the query design grid indicate an ____ operator
or
When you run a query that contains a ____ field, Access evaluates the expression defined by the field and displays the resulting value in the query datasheet, form, or report.
calculated
The AutoNumber, Currency, Date/Time, Memo, Number, OLE Object, Text, and Yes/No data types all support the Max aggregate function
false
A form that accesses data from two tables has a main form and a(n) ____.
subform
The navigation mode and editing mode keystroke techniques for forms are the same as those you use for datasheets
true
In a grouped report, the data for the primary table is first and is followed by the related records from the related table.
true
The Access feature that defines reports by asking you a series of questions and creates the report based on the answers is the Report Designer
false
You choose a field to be used as the basis for a search by making the field a sort key.
false
The themes are available under the Themes group on the ____ tab.
design
To change a form's style, you must switch to ____.
layout view
____ levels are useful for reports with multiple levels
grouping
You use ____ view to view, enter, and maintain data in the table on which a form is based.
form
You specify the value you want to find in the ____ text box in the Find and Replace dialog box.
find what
The Form Wizard allows you to select one of ____ layout types
four
Forms that include a main form and a subform will have two sets of navigation buttons.
true
To begin to create a form in Access, you click ____.
the Create tab on the Ribbon