44 terms

Access Exam Review

AND criteria
each individual criterion must be true in order for the compound criterion to be true
Advanced Filter/Sort
to filter records using complex criteria
Append query
add the results of a query to an existing table
field can store a unique sequential number that Access assigns to a record; Access will increment the number by 1 as each new record is added
Calculated field
field that can be computed from other fields
Cascade the update
allows the change but make the corresponding change in the foreign key on all related records
Cascade the delete
Access allows the deletion but then deletes all related records
Common filters
filter an individual fields by clicking the arrow to the right of the field name
Comparison operators
when you have more than one criterion that the data for which you are searching for must satisfy
condition that the records to be included must satisfy
Crosstab query
calculates a statistic (sum, average, count) for data that is grouped by two different types of information; one will appear down the side and the other across the top
Datasheet view
table is represented as a collection of rows and columns called a datasheet
Delete query
allows you to delete all the records satisfying some criterion
design view
view that allows you to specify fields, criteria, sorting, calculations, and so on
contains a specific piece of information within a record
Filter by form
use to restrict records that appear
Filter by selection
you give Access an example of the data you want by selecting the data within the table then choose the option you want on the selection menu
Form view
where data is displayed in a form on the screen; you can usually see all the fields but only for one record
Format (change to upper case)
creating groups of records that share some common characteristic (> in format to automatically change everything to uppercase)
creating separate collections of records sharing some common characteristics
join line
line drawn between matching fields in the two tables indicating that the tables are related
lookup field
allows the user to select from a list of values
maintaining database
modifying the data to keep it up-to-date; such as adding new records, changing data in existing records, and deleting records
multivalued field
fields that contain more than one value
OR criteria
is true when either individual criterion is true
rows in a table containing information about a given person, product, or event
parameter query
query that prompts for input whenever it is used
primary key
given value that will appear only once in a single record in the table; unique identifier
question presented in a way that Access can process
storing the same fact in more than one place
referential integrity
property that ensures that the value in a foreign key must match that of another table's primary key
how tables are related; most common is one-to-many meaning one record from the first table is related to many records in the second table
required field
field in which in which the user actually must enter data
RUN button
runs or applies the query
to order the records in the answer to a query in a particular way
split form
combines both a datasheet a form, thus giving the advantage of both views
Text (type of data)
the field that contains any character; maximum number of characters allowed is 255
total row (how to activate it)
unique values
omits duplicates
update query
allows you to make the same changes to all records satisfying some criterion
validation rules
rules that a user must follow when entering the data
symbols that represent any character or combination of characters (asterisks&question marks)
action query
adds, deletes, or changes data in a table
make-table query
adds the results to a new table