CIS Midterm

A ____ text control displays data from a field.

Bound

An unbound text box control that contains an expression (formula) is called a(n) _____ control.

Calculated

_____are conditions that the records must meet in order to be included in the query results.

Criteria

A stacked layout places labels across the top, with columns of data (similar to a datasheet or a spreadsheet).

False

AutoFilter and Filter by Selection settings are saved with the database object.

False

Creating a backup of the database removes unnecessary file space and hidden, temporary objects from your database.

False

Page numbers can only be added to a footer section.

False

The Currency Field format is the same as the currency data type

False

The upper pane in query Design view shows the query grid where you specify which fields to include in the query.

False

To rename a database object, double-click the name in the Navigation Pane and type the new name.

False

Users can enter and edit data in an AutoNumber field

False

You can undo a record deletion.

False

You must manually save the record each time you enter data in a table or form

False

Each column in a table represents a specific data value called a ____

Field

Click and drag fields from the _____ to add controls to a blank report.

Field List pane

If you wanted to display records of all employees who live in the same city (from the City field in the table), you would use a

Find Duplicate query

If you want to create a query that shows records from one table that have no corresponding records in another table, use a _____

Find Unmatched query

An input mask

Forces users to input data in a consistent format

Which of these design elements is not available in forms?

Page Numbers

You can export Access data to which of the following file formats?

PowerPoint

If two tables have referential integrity enforced _____ you cannot add a record to the secondary table without an associated record in the you cannot make changes to the primary table that would cause records in the

Primary Table Secondary table to become unmatched.

Each row in a table contains all the data for a single______

Record

A ____ combines the convenience of a continuous Datasheet form with the usability of a Single Record form displaying one record at a time.

Split form

A well-designed database

Stores each unique piece of data in only one table

A ____ is a form within a form that displays records related to the record in the main form.

Subform

All data entered into a form are stored in a underlying

Table

______ are the basic building blocks of a database.

Tables

To limit query results to only records that meet all the criteria, enter criteria for multiple fields on the Criteria row, or enter multiple criteria for the same field separated by the word And.

True

Table's primary key must...

be unique for every field

A _____ displays a value returned by an expression.

calculated field

To rename a field...

double-click the column header, and type the new field name right-click the column header, select Rename Field, and type the new field name

Entering < >80 as the criteria for a query will return results that are _____

not equal to 80

To change the direction a report prints on the page, change the page _____

orientation

When you create a _______ , you specify the field or fields that the query will use, but you don't specify the exact criteria.

parameter query

Grand totals in a report are added to the ______

report footer section

A ____ displays data from one or more tables or queries, based on the fields that you select.

select query

To control the number of characters a user can enter into a table field, use...

the field size property

When you are entering data in a new record in a form, the Undo command will ___

undo the entire record at once