Objects Microsoft Office Access 2003

Objects Microsoft Office Access 2003
Objects
The user interacts with Microsoft Office Access and develops a database application using
a number of objects:
n Tables The base tables that make up the database. Using the Microsoft terminology,
a table is organized into columns (called fields) and rows (called records).
n Queries Allow the user to view, change, and analyze data in different ways. Queries
can also be stored and used as the source of records for forms, reports, and data access
pages. We examined queries in some detail in the previous chapter.
n Forms Can be used for a variety of purposes such as to create a data entry form to
enter data into a table.
n Reports Allow data in the database to be presented in an effective way in a customized
printed format.
n Pages A (data access) page is a special type of Web page designed for viewing and
working with data (stored in a Microsoft Office Access database or a Microsoft SQL
Server database) from the Internet or an intranet. The data access page may also include
data from other sources, such as Microsoft Excel.
n Macros A set of one or more actions each of which performs a particular operation,
such as opening a form or printing a report. Macros can help automate common tasks
such as printing a report when a user clicks a button.
n Modules A collection of VBA declarations and procedures that are stored together as
a unit.
Before we discuss these objects in more detail, we first examine the architecture of
Microsoft Office Access.