OBJECTS:
TABLES: In Access, data
is stored in tables. A table is a set of columns and rows, with each
column referred to as a field. Each value in a field represents a
single type of data. Each row of a table is referred to as a record.
QUERIES:
You use queries to retrieve specific
data from your database and to answer questions about your data. For
example, you can use a query to find the names of the employees in
your database who live in a particular state.
FORMS:
Forms give you the ability to choose
the format and arrangement of fields. You can use a form to enter,
edit, and display data.
REPORTS:
Reports organize or summarize your
data so you can print it or view it onscreen. You often use reports
when you want to analyze your data or present your data to others.
MACROS:
Macros give you the ability to automate
tasks. You can use a macro to add functionality to a form, report, or
control.
MODULES:
Like macros, modules give you the
ability to automate tasks and add functionality to a form, report, or
control. Macros are created by choosing from a list of macro actions,
whereas modules are written in Visual Basic for Applications.
