Database Management

Helpfulness: +1
Set Details Share
created 7 years ago by tlthweatt
7,104 views
Chapter 2
updated 7 years ago by tlthweatt
Grade levels:
College: Second year
show moreless
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
Show:
1

The area directly below the ribbon that displays information such as security alerts.

Message bar

2

An area where you can view the security and privacy settings for your Access installation.

Trust Center

3

An association that you establish between two tables based on common fields.

Relationship

4

A relationship between two tables, where one record in the first table corresponds to many records in the second table.

One-to-many relationship

5

In the query design window, in the table area, the list of field names in a table.

Field list

6

The primary key field is connected to this field in the related table to create a relationship.

Foreign key

7

A set of rules that ensures that the data between related tables is valid.

Referential integrity

8

The visual cue in the Relationships window that indicates tables are related by connecting common fields.

Join line

9

In Datasheet view, clicking the plus sign (+) displays the related records in this format.

Subdatasheet

10

The process of arranging data in a specific order based on the data in a field.

Sorting

11

A sorting order that arranges text alphabetically (A to Z) and numbers from the lowest number to the highest number.

Ascending

12

A sorting order that arranges text alphabetically (Z to A) and numbers from the Highest number to the Lowest number.

Descending

13

In Datasheet view, when sorting using multiple fields, the field that is used for the first level of sorting.

Outermost

14

In Datasheet view, when sorting using multiple fields, the field that is used for the second level of sorting.

Innermost

15

The process in which Access looks for records in a table based on the fields and criteria in the query design, finds those records, and then displays the records in a datasheet.

Run

16

Relationship options that enable you to update records in related tables when referential integrity is enforced are known as:

Cascade options

17

The lower area of the query design window where criteria is entered is the:

Design grid

18

Min, Max, Avg, and Sum are examples of:

Aggregate functions

19

Conditions in a query that identify the specific data for which you are looking are known as:

Criteria

20

A criteria that searches for fields that are empty is:

Is Null

21

The symbols of =,>,and<, are known as:

Comparison operations

22

A comparison operator that searches for values within a range is:

Between...And

23

the logical operator that requires all criteria to be met is:

AND

24

A wildcard character that serves as a placeholder for one or more unknown characters is the:

*

25

A field that stores the value of a mathematical operation is:

A calculated field

26

For a calculated field, the new field name must be followed by:

A colon

27

A query that uses an aggregate function and displays data grouped by two types of information is:

A crosstab query

28

A query that prompts you for criteria when it is run is a:

Parameter query

29

Criteria that can be changed when a query is run is a:

Parameter

30

A good parameter for a City field is:

[Enter a City]