Microsoft Access Lesson 1 and 2 Vocabulary

Created by martinjr1797 

Upgrade to
remove ads

26 terms

table

contains columns and rows of data

field

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.

record

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

query

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

folders

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

backup

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.

control

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.

caption

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.

relationship

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 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.

NEW! Voice Recording

Click the mic to start.

Create Set