Welcome to Learn Access Now, a full-length book available online. Even though Learn Access Now is designed to specifically teach beginners how to use Microsoft Access, even longtime users of the program can learn a thing or two.
In order to meet the needs of the largest audience, Learn Access Now uses examples that work with Microsoft Access 2000. The techniques and the concepts covered, however, will work with all recent versions of Microsoft Access, up through Access 2003.
To use Learn Access Now, just pick a chapter from the Table of Contents below and click on the section you want to read. You can then progress from section to section, learning just the information you need.
Enjoy!
Access Terminology
Using the Access Environment
Looking at Possibilities
Exiting Access
Summary
Creating Your Own Database
Creating a Table
Entering Information in Your Table
Changing Information in Your Table
Deleting Records
Saving Your Information
Summary
Modifying Your Table Design
Editing At a Table Level
Summary
A Brand New Database
Creating a Table From Scratch
Testing Your Layout
Summary
Sorting Your Data
Filtering Your Data
Summary
Understanding Queries
Using the Query Wizards
Designing Your Own Queries
Summary
Printing a Table
Controlling the Printed Page
Printing Your Layout
Using Print Preview
Summary
What is a Report?
Creating a Report
Using Other Report Wizards
Creating Mailing Labels
Summary
Understanding Forms
Creating a Form Using the Form Wizards
Defining Your Own Forms
Summary
Using the Spell Checker
Using AutoCorrect
Analyzing a Table
Improving Table Performance
Summary
Why Use Other Programs with Access?
Sharing Data with Word
Sharing Data with Excel
Summary
What is the Web?
Using Hyperlinks
Creating Web Pages
Summary
Understanding Data Relationships
Establishing Relationships
Summary
Creating a New Report
Understanding the Design Window
Designing Your Report
Summary
Using Information from Other Databases
Preparing Information for Other Databases
Summary
Setting a Database Password
Using Database Encryption
Working with Users and Groups
Using the User-Level Security Wizard
Opening a Secured Database
Managing Security Accounts
Summary
What is OLE?
Putting Objects in Your Table
Modifying Links
Editing Objects
Summary
What Are Macros?
Creating Macros
Conditional Macros
Running Macros
Editing Your Macros
Summary
Adding Dialog Boxes
Adding Menus
Summary
What is Visual Basic for Applications?
Parts of a Program
Creating a VBA Module
Testing Your Procedure
Attaching Your Procedure to a Form
Summary
Database Design
Forms in the Database
Queries in the Database
Reports in the Database
VBA Procedures
Improvements You Could Make
Summary