|
Introduction | Creating a Database | Tables | Queries | Forms | Reports
MS Access 2000
Introduction
Databases can help store, sort, analyze, retrieve and display a
wide variety of information that's related to a particular subject
or purpose. With databases you can print address labels, contact
customers on a regular schedule while keeping track of what they've
bought from you historically, and monitor who you already sent your
resume to.
Microsoft Access is the database included on your
Campus Software CD. It is web-compatible, extremely powerful and
flexible. As part of the Microsoft Office Suite it is integrated
with Word and Excel, making it easy to use your database to send
out a form letter or incorporate financial information into your
database.
Access uses:
- Tables to store your data.
- Queries to find and retrieve just the data you want.
- Forms to view, add, and update data in tables.
- Reports to analyze or print data in a specific layout.
- Data access pages to view, update, or analyze the database's data from the Internet or an intranet.
Access is called a "relational" database. That
means it keeps track of data in tables and relates it when necessary
to other tables. In this way, you need only enter data once but
it is reflected in other tables, forms, or reports. When you update
the data, it's automatically updated everywhere it appears.
Here are 10 lessons to help you review some of the most important
and commonly used features of databases and Access. Use the links
below to move through them either sequentially or to help you cover
a specific topic.
Access is not as intuitive as Word or Excel. It will be very useful
to take the complete Microsoft Interactive tutorial on Access.
|
