30 terms

Access Chapter 2

STUDY
PLAY

Terms in this set (...)

A special character that can represent one or more characters in the criterion of a query.
Wildcard
A characteristic of a field that determines how a field looks and behaves.
Field property
Returns only records that meet all criteria.
AND logical operator
A row in the Query Design view that determines which records will be selected.
Criteria row
Determines the type of data that can be entered and the operations that can be performed on that data.
Data type
Used to create a more readable label that displays in the top row in Datasheet view and in forms and reports.
Caption property
Enables you to ask questions about the data stored in a database.
Query
The term Access uses to describe a blank field.
Null
A data type that is a number that automatically increments each time a record is added.
AutoNumber
The unnecessary storing of duplicate data in two or more tables.
Data redundancy
A data type that can store only numerical data.
Number data type
A relationship established when the primary key value in the primary table can match many of the foreign key values in the related table.
One-to-many relationship
A field in one table that is also the primary key of another table.
Foreign key
An option that directs Access to automatically update all foreign key values in a related table when the primary key value is modified in a primary table.
Cascade Update Related Fields
Rules in a database that are used to preserve relationships between tables when records are changed.
Referential Integrity
Uses no spaces in multiword field names, but uses uppercase letters to distinguish the first letter of each new word.
CamelCase notation
A row in the Query Design view that enables you to reorder data in ascending or descending order.
Sort row
Contains two or more tables, enabling you to take advantage of the relationships that have been set in your database.
Multitable query
Returns records meeting any of the specified criteria.
OR logical operator
Provides dialog boxes to guide you through the query design process.
Simple Query Wizard
All of the following are suggested guidelines for table design except:

Link tables using common fields.

Avoid date arithmetic.

Include all necessary data.

Store data in its smallest parts.
Avoid date arithmetic.
Which of the following determines the type of data that can be entered and the operations that can be performed on that data?

Normalization

Data type

Field properties

Caption property
Data type
When entering, deleting, or editing table data: (

The table must be in Design view.

The table must be in Datasheet view.

Data may only be entered in a form.

The table may be in either Datasheet or Design view.
The table must be in Datasheet view.
When importing data into Access, which of the following statements is true?

The wizard will import the data in one step after you select the file.

The Import Wizard is found on the Create tab.

The Import Wizard only works for Excel files.

You can assign a primary key while you are importing Excel data.
You can assign a primary key while you are importing Excel data.
The main reason to enforce referential integrity in Access is to:

Limit the number of records in a table.

Keep invalid data from being entered into a table.

Keep your database safe from unauthorized users.

Make it possible to delete records.
Keep invalid data from being entered into a table.
An illustration of a one-to-many relationship would be a:

Bank branch location has an internal BranchID code.

Customer may have multiple orders.

Person changes his/her primary address.

Balance field is totaled for all accounts for each person.
Customer may have multiple orders.
A query's specifications providing instructions about which records to include must be entered on the:

Table row of the query design grid.

Criteria row of the query design grid.

Sort row of the query design grid.

Show row of the query design grid.
Criteria row of the query design grid.
When adding Value criteria to the Query Design view, the value you enter must be delimited by:

At signs (@).

Nothing ().

Pound signs (#).

Quotes (" ").
Nothing ().
It is more efficient to make a copy of an existing query rather than create a new query when which of the following is true?

The existing query and the new query have the exact same criteria.

The existing query and the new query use the same tables and fields.

The existing query contains only one table.

The original query is no longer being used.
The existing query and the new query use the same tables and fields.
Which of the following is true for the Query Wizard?

You do not need a summary.

No criteria can be added.

Fields from multiple tables are not allowed.

You can only select tables as a source.
No criteria can be added.