Create an account
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
Cascade the update
allows the change but make the corresponding change in the foreign key on all related records
when you have more than one criterion that the data for which you are searching for must satisfy
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
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
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)
line drawn between matching fields in the two tables indicating that the tables are related
modifying the data to keep it up-to-date; such as adding new records, changing data in existing records, and deleting records
given value that will appear only once in a single record in the table; unique identifier
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
Text (type of data)
the field that contains any character; maximum number of characters allowed is 255
symbols that represent any character or combination of characters (asterisks&question marks)
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 and try again
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