Database Ch. 3/4

55 terms by breiche0 

Ready to study?
Start with Flashcards

Create a new folder

Advertisement Upgrade to remove ads

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set