Lesson 3

Front 1

query

Back 1

is a database object that lets you uask the database about the data it contais.

Front 2

condition

Back 2

iss a way of ttelling the query witch data you are interested in seeing.

Front 3

sort

Back 3

sorting a field in asceding order arranges records froom the a of z or froom largest .

Front 4

auto filter

Back 4

is a menu that opens when yoyu click the arrow on the ring sidde ofa a field selector.

Front 5

filter by selection

Back 5

you select a field value or part of a field value is a datasheet , and then click the selection button in the sort.

Front 6

filter by form

Back 6

when you need to display recordw that contain one or more values based on the values stored in one or more fields.

Front 7

auto filder is a menu that opens when you click the arrow on the rigth side of a field selector

Back 7

auto filter

Front 8

relationship

Back 8

berween two tables you must desing the tables so they contain a common field.

Front 9

common field

Back 9

fields that apperarrs in both taables has the same data type and contains

Front 10

one-to-many relationsship

Back 10

one record in the firts table can math many records

Front 11

foreing key

Back 11

when it is used in a relatiosships in the primary table the common field is usually the table 's primary key

Front 12

referential integrity

Back 12

protects the data in the tables to make sure that is not acccidentally.

Front 13

subdatasheet

Back 13

whit contains the relatred records i the ordens table .