Like this study set? Create a free account to save it.

Sign up for an account

Already have a Quizlet account? .

Create an account


contains columns and rows of data


one piece of data such as a customer's name in a database for contacts, or the color of a product in an inventory database.


made up of all the fields related to one particular item in the table.

scroll bars

allow you to see all the data in a table


asks Access to find data from one or more tables that matches specific criteria or conditions.


help you organize various databases so you can find them quickly

dialog box

used to enter specific information to perform a task, such as naming or and saving a document


copy of your database in another location

database template

complete with tables and fields that allow you to organize and track any kind of information, such as inventory, customer orders, personal contact information, etc.

design view

view used to design your Access table

field's property

items such as the number of characters for a particular field such as a phone number field.

data type

whether a field represents a date/time, text, number, etc.

primary key

Every table must have this field. This field ensures that each record is unique.

Totals row function

this function offers a quick and simple way to summarize columns of data in a table to get totals, averages, maximum, minimums, and other calculations.


an object that displays data or performs an action

property sheet

a list of field properties

table analyzer wizard

helps to study teh information in a table and then make changes to streamline the data.


a column heading

lookup field

contains all the possible data choices for the field.

attachment field

useful for linking to a database file and other objects that might not fit into one field.

input mask

allows you to specify how you want information such as zip codes and phone numbers to be formatted in your database.


a link between two tables based on a common field.

referential integrity

makes sure that the related data in two tables always exists and is complete

crosstab query

shows summary data(such as count, average, or sum) for data grouped by two fields.

unmatched query

finds records without matching related data.

duplicate query

finds multiple records that contain the same data in a field.

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!


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

Voice Recording