Combo with "Access Test Review" and 1 other

In Access, you can specify up to ____ fields on which to sort the query results.

10

The Decimal property setting for Number fields stores positive and negative numbers to precisely ____ decimal places and uses 12 bytes.

28

An Access database can contain up to ____ objects.

32768

How many fields are there in that chart

4

The ____ character will match any single alphabetic character.

?

Statistical information, such as totals and averages, can be calculated in a query by using a(n) ________

Aggregate function

A field that consist of integer values that are controlled by Access is a (n) __

Autonumber

A range of values may be specified as a selection criteria by using the ____ operator.

Between... and

A range of values may be specified as selection criteria by using the ____ operator.

Between...And

Pine Hill Music School Yuka Koyama uses the Pinehill database to maintain information about the students, teachers, and contracts for her music school. Yuka asks you to help her build the database by updating one table and creating two new tables. If you choose the ____, Access permits the change in value to the primary key and changes the appropriate foreign key values in the related table, thereby eliminating the possibility of inconsistent data in Yuka's database.

Cascade Update Related Fields option

A field defined as a Yes/No field type will be displayed as a ____

Check box

A table can be logically connected to another table by defining a ____.

Common field

You need to connect one table to another in related fields. Use a ____

Common field

Tom notices that he often needs to type the same data that he just typed in the previous record. He can speed up the data entry process by using ____.

Ctrl+'

Tom wants to know at a glance how many records are contained in the current table. Where should he look?

Current Record Box

Which of the following could be defined as a field in a database?

Customer name, phone number, order number - all of the above

The ___ determines what field values are allowed and what other properties the field will have.

Data type

You should carefully design your ____ to meet the needs of those who will use it.

Database

You can modify an existing table's structure in ____

Design view

To Choose fields for a select query design view __.

Double click the fields in the field list, drag the field from the field list.

A form is used to

Enter, edit, and view records in a database

When you use the number data type to define a field, you should set the field's ___ property based on the largest value you expect to store in that field

Field Size

Selects all or part of a field value in a datasheet and then when the filter is applied, displays only those records with the selected value.

Filter by selection

An Autoformat can be applied to a form in its entirety, or you can choose to change some of its features by selecting the options on the ____ tab.

Form layout tools

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")

The ____ operator is a comparison operator that allows you to check whether or not a particular field value is part of a list of values.

In ()

You can use a common field to create relationships between tables by performing a(n)

Join

In the figure above, the arrow labeled 2 is pointing to the

Key symbol indicating the table's primary key.

To Change a form's style you must switch to ___.

Layout view

To indicate a pattern that includes wildcards, use _____.

Like "617*"

Using the Number data type for the Country Population field in a database, with characteristics of the lowest data value starting at over 1 million and the highest at 2 billion, set the Field Size Property to _____.

Long Integer

In the figure above, the large arrow labeled 4 is pointing to a circled area

Move to the next record.

The last step in creating a table is to

Name the table and save it to disk

Access searches for objects only in the categories and groups currently displayed in the ____.

Navigation Pane

If you do not enter any value for a field, you have given the field a ____ value.

Null

Selection criteria that are placed in different rows in the query design grid indicates an ___ operator.

OR

A ___ relationship exists between two tables when one record in the first table matches zero, one or many records in the second table

One to many relationship.

A field or a combination of fields, that has a unique value is a

Primary Key

After all primary key fields have been selected, you must click the ______ to complete the key definition

Primary Key button in the tools group on the table tools design tab

If you want to see how many pages are likely to print in a report, you must use the

Print preview

The characteristics of a field, such as name, size, and type, are caked the field ____.

Properties

Using__________________ you give access an example of the information you are requesting; Access then retrieves the information that precisely matches your example

QBE

In datasheet view, clicking a row selector selects an entire __

Record

In Datasheet view, the pencil symbol indicates the ____.

Record is being edited

The items marked 3 in the figure above are __ records.

Related

Which of the following is not an example of an Access object?

Report tool

After you have finished defining a table, you must ___ it in order to enter data into it.

Save

When you right-click a row selector in the Design view, access will display a ________.

Shortcut Menu

If you are unable to see all of the fields on your display, click the ____ to give you more room on the screen to view the object's contents.

Shutter Bar Open/Close Button on the Navigation Pane

For a special report, Tom wants his donation fields to display in a Currency format that does not display dollar signs, so he will use the ____ format.

Standard

The final step in the creation of a table is to save the table ___ to disk.

Structure

A form can be used to display fields from multiple records at one time by specifying the ____ layout.

Tabular

One example of a predefined function in access is the Count Function, which determines ____.

The number of records selected

Access can guide you through the steps to create a query by using the Query ____.

Wizard

Each ____ in the design grid contains specifications about a field you use in a query.

column

A form that shows only one record at a time has a ____ layout.

columnar

____ a database rearranges data and objects in a database to make its size smaller.

compacting

You can tell access which records are to be selected by specifying a(n).____

condition

Calculations performed using the __ data type are not subject to round-off error.

currency

For a field in Tom's database that holds dollar amounts, what is the most appropriate data type?

currency

In the figure, above, the primary key is in the ____ table and the foreign key is in the ___ table

customer (top), Contract (bottom).

The ____ determines what field values are allowed and what other properties the field will have.

data type

Maintaining data using a form is often easier than using a(n) ____ because you can focus on all the changes for a single record at one time.

datasheet

The themes are available under the Themes group on the ____ tab.

design

The items marked 2(signing date, contract num) in the accompanying figure are ____ records.

detail

Selecting data by means of a query ____

displays only the data that matches the query selection criteria.

You can automatically include all of the fields in a table in a query by ____ the asterisk that appears in the Field List box in Query Design view.

double-clicking

If a table is defined with a primary key, Access will require you to enter a value for the key when adding a record in a process known as ____.

entity integrity

A selection condition that dictates that the value in the specified field must precisely match the condition is known as _____ match

exact value

Under field properties, the default value of zero means ___

false or no

In ____ view, you cannot make any design changes to a form.

form

You use ____ view to view, enter, and maintain data in the table on which a form is based.

form

A report that shows the data from a record in the primary table and then all joined records from the related table is called a(n) ____ report.

grouped

Yuka wants to create a report using the Report Wizard. She will select fields from the Student table and the Contract table. She has asked that you sort the detail records in ascending order by Contract ID. This will be a(n) ____ report.

grouped

You can activate the Find command from the button on the ____ tab.

home

The item indicated in the figure above is a(n) ___ line.

join

You can resize columns easily in ____ view.

layout

When you create a form containing data from two tables that have a one-to-many relationship, you create a(n) ____ for data from the primary table.

main form

A field name

must be unique within a table

To move from record to record in a form, you can use the ____.

navigation buttons

In Datasheet view, the star symbol that appears in the record selector area always identifies the ____ in the database.

next available row for a new record

Tom forgot to set off the date values in a condition that he was constructing from the operators, but Access automatically placed ____ around the date values to distinguish them from the operators

number signs

Parkhurst Health & Fitness Center Martha Parkhurst is using the Fitness database to track and analyze the business activity of the fitness center members and their programs. To make her work easier, you'll create a form and report in the Fitness database. Martha is concerned that her form data may be longer in length than the size of the field control. To check this, she should use ____.

print preview

To see a sample of your form before it is printed, you can click the ____ button.

print preview

Which of the following can Martha use before printing to show exactly how one of the reports you designed for her will look when printed?

print preview

The characteristics of a field, such as name, size, and type, are called the field ____.

properties

A ____ datasheet is temporary, and its contents are based on the criteria you establish in the design grid.

query

A ____ is a question you ask about data stored in a database.

query

In the accompanying figure, the last ROW of data shown (11053, Hwan, Tang, etc.) is a ____.

record (a set of field values is called a record)

It is best to ____ a database object—query, form, or report—only if you anticipate using the object frequently or if it is time-consuming to create because all objects use storage space on your disk.

save

Clicking a record selector ____.

selects an entire row

____ fields can be unique or nonunique.

sort

The final step in the creation of a table is to save the table ____ to disk.

structure

You can move from field to field within a form by using the ____.

tab key

why do you have a primary key?

unique data (it cannot be duplicated)

A primary key ____.

uniquely identifies each record in a table

A __ is a question you ask about data stored in a database.

wizard

Queries can be created by using the Query ___, which prompts you for the information required to build the query

wizard

The ____ is a large text box used to enter text, expressions, and other values.

zoom box