CIS ACCESS

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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?

PDF

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.


Kaugnay na mga set ng pag-aaral

Philosophy Mid-Term BSU Spring 2023

View Set

BIOL 1405 Chapter 1 The Human Body

View Set

Ethics, Boundaries, Rules and Regulations Part 1

View Set

Quiz 6 Information Security Fundamentals

View Set

which of the following would not be covered under the personal and advertising injury liability coverage

View Set