CIS ACCESS
When you are entering data in a new record in a form, the UNDO command will _________
C. undo the entire record at once
Which of these provides a complete database structure to use as a base for your own desktop database?
Desktop database template
AutoFilter and Filter By Selection settings are saved with the database object.
False
If you require a value in a field to always be less than 25, which of the following should be used?
Field validation rule
If you wanted to display records of all employees who live in the same city (from the City field in the table), would use a _______.
Find Duplicate query
You can export Access data to which of the following type of file formats?
If you require the value in one field in a table to always be greater than the value of another field in the table, which of the following should be used?
Record validation rule
A _____ displays a value returned by an expression.
calculated field
Entering <>80 as the criteria for a query will return results that are _______.
do not equal 80
The Currency field format is the same as the Currency data type.
false
Each column in a table represents a specific data value called a __________
field
An input mask _______.
forces users to enter data in a consistent format.
Each row in a table contains all the data for a single ________
record
To rename a field, _________ (select all correct answers).
right-click the column header, select Rename Field, and type the new field name. double-click the column header and type the new field name.
A well-designed database ___________.
stores each unique piece of data in only one table.
All data entered into a form are stored in the underlying __________
table
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
When importing data into Access, you can identify a column or field from the imported data as the primary key.
true
You cannot import data into Access from which of these file types?
word
If two tables have referential integrity enforced, _____________. (select all that are correct)
you cannot make changes to the primary table that would cause records in the secondary table to be unmatched (orphans). you cannot add a record to the secondary table without an associated record in the primary table.