Access Exam Review

44 terms by mchaps26

Create a new folder

Advertisement Upgrade to remove ads

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

Autonumber

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

Criterion

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

field

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)

grouping

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

record

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

query

question presented in a way that Access can process

redundancy

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

relationships

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

sort

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

wildcards

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set