Excel Lesson Lesson 3

Front 1

query

Back 1

a dtabase object that lets you ask the database about the data it contains.

Front 2

condition

Back 2

is a way of telling the query which data you are interesting in seeing.

Front 3

simple query wizard

Back 3

ask you which data you want to see by letting you select option in dialog box.

Front 4

sort

Back 4

sorts files in assending order from a to z.

Front 5

filter

Back 5

temporailty displays records in a database based on the condition that you specify.

Front 6

filter by selection

Back 6

helps you to use different types of filters to display the data you need.

Front 7

filter by form

Back 7

use when you need yp display records that contain one or more values based on values stored in one or more fileds.

Front 8

autofilter

Back 8

is a menu that opens when you click the arrow on the right side of a field selectors.

Front 9

relationship

Back 9

between two tables must design the tables so that they contain a common field.

Front 10

common field

Back 10

field that appears in both tables and have the same data type.

Front 11

one-to-many-relationships

Back 11

one record in the first table can match many records in the second table.

Front 12

foreign key

Back 12

the common feild in the related tables.

Front 13

referential integrity

Back 13

protects the data in the tables to make sure the data isent deleted or changed.