26 terms

Microsoft Access Lesson 1 and 2 Vocabulary

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.