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
