cis 305 - intro

When you enter dates in the Criteria row, Access places _______ symbols around the date.

#

The _______ wildcard replaces a single character.

?

Criteria in the same row implies _______. Records must meet both criteria.

and

A(n) _______ control is a control that displays the field data.

bound

The prompt you create in a parameter query should be enclosed in _______.

brackets

In a query, a _______ displays a value returned by an expression (a formula).

calculated field

In the _______ box, type the field name as it should appear in labels and column headings.

caption

Instead of preventing updates or deletions when enforcing referential integrity, you can set relationship options to delete or update the related records in the secondary table. These options are known as _______ options.

cascading

Use the _______ view when entering records into a table.

datasheet

_______ refers to the number of characters the field can hold in the database.

field size

Access is a relational database; objects in your database are related to one another through relationships defined by common _______ between tables.

fields

The _______ property does not affect the data stored in the table; it only controls how the data is displayed to the end user.

format field

Sorting query results in ascending order sorts them _______.

from a to z

Use _______ orientation for reports with many columns.

landscape

Once you have created your form or report, it is easy to change formatting in _______ view.

layout

You can modify report grouping or sorting choices by editing the report in _______ view.

layout

Which of the following is not a valid comparison operator used in criteria?

non zero (!)

_______ relationships in Access are the most common.

one to many

_______ key fields are identified with a key icon next to the field name.

primary

_______ extract data from a table or related tables and can include actions such as updating data values or deleting data.

queries

Each row in a table contains all the data for a single _______.

record

If the field you are changing is the primary or foreign key in a relationship, Access may _______ before changing the data type.

requires you to delete the relationship

To delete the relationship between two tables you can _______ the relationship line and select Delete.

right click

Use the _______ box next to the navigation buttons at the bottom of the datasheet or form for a simple search in a table, form, or query.

search

The _______ Query Wizard will create a simple select query.

simple