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.
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
used to enter specific information to perform a task, such as naming or and saving a document
copy of your database in another location
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.
view used to design your Access table
items such as the number of characters for a particular field such as a phone number field.
whether a field represents a date/time, text, number, etc.
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
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
contains all the possible data choices for the field.
useful for linking to a database file and other objects that might not fit into one field.
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.
makes sure that the related data in two tables always exists and is complete
shows summary data(such as count, average, or sum) for data grouped by two fields.
finds records without matching related data.
finds multiple records that contain the same data in a field.