Microsoft Office Tutorials and References
In Depth Information
The Six Types of Access Objects
The Six Types of Access Objects
Access databases are made up of objects — things you can create, edit, and
delete, each with its own name and settings. Object-oriented systems allow
you to create these things one piece at a time, using pieces that fit together.
Book I
Chapter 1
These objects can store, display, and print your data, as well as contain
programs you write. At first, you’ll probably use only a few types of objects,
but as you customize your database, you may end up using all six types. You
start with tables for storing data, forms for editing data onscreen, reports for
printing data, and queries for selecting and combining data. Later, you may
create macros and modules, which contain programs that you write.
In this section, we describe the main types of Access objects: tables, queries,
forms, reports, macros, and modules.
Tables for storing your data
Tables are where you put your data. A table is an Access object that is made
up of a series of records — the electronic equivalent of the index cards that
make up an address list. Each record contains information about one thing,
with the same pieces of information. In an address list, each record contains
information about one person: name, address, and other facts. Each individual
piece of information — such as first name, last name, or street address — is
called a field.
Your database can contain many tables. A bookstore database, for example,
can contain a Books table (with title, publisher, price, and other information
about each book), a Vendors table for companies from which you buy books
(with company name, address, discount terms, and other information about
each vendor), and maybe a Customers table of your regular customers (with
name, address, and other information). Figure 1-1 shows a table of names
and addresses. Each row is a record, and the fields are shown in columns.
Figure 1-1:
A table
and fields
Search JabSto ::

Custom Search