Microsoft Office Access 2003 Step by Step

What’s New in Microsoft Office Access 2003;
Getting Help;
Getting Help with This Book and Its CD-ROM;
Getting Help with Microsoft Office Access 2003;
More Information;
Using the Book’s CD-ROM;
What’s On the CD-ROM?;
Minimum System Requirements;
Installing the Practice Files;
Using the Practice Files;
Uninstalling the Practice Files;
Conventions and Features;
Taking a Microsoft Office Specialist Certification Exam;
About the Microsoft Office Specialist Program;
What Does This Logo Mean?;
Selecting a Microsoft Office Specialist Certification Level;
Microsoft Office Specialist Skill Standards;
The Exam Experience;
For More Information;
Microsoft Office Specialist Skill Standards;
About the Authors;
Online Training Solutions, Inc. (OTSI);
Quick Reference;
Chapter 1 Getting to Know Microsoft Access 2003;
Chapter 2 Creating a New Database;
Chapter 3 Getting Information Into and Out of a Database;
Chapter 4 Simplifying Data Entry with Forms;
Chapter 5 Locating Specific Information;
Chapter 6 Keeping Your Information Accurate;
Chapter 7 Working with Reports;
Chapter 8 Making It Easy for Others to Use Your Database;
Chapter 9 Keeping Your Information Secure;
Chapter 10 Working with Pages and Modules;
Chapter 1: Getting to Know Microsoft Access 2003;
Understanding Databases;
Discovering What’s Special About Access;
Opening an Existing Database;
Exploring Tables;
Exploring Queries;
Exploring Forms;
Exploring Reports;
Exploring Other Access Objects;
Previewing and Printing Access Objects;
Key Points;
Chapter 2: Creating a New Database;
Creating a Database Structure the Simple Way;
Checking the Work of a Wizard;
Creating Tables the Simple Way;
Refining How Data is Displayed;
Manipulating Table Columns and Rows;
Key Points;
Chapter 3: Getting Information Into and Out of a Database;
Importing Information from Excel;
Importing Information from a Delimited Text File;
Importing Information from a Fixed-Width Text File;
Importing Information from an Access Database;
Importing Information from Other Databases;
Importing Information from an HTML File;
Importing Information from an XML File;
Exporting Information to Other Programs;
Linking a Database to Information in Another Database;
Other Ways to Share Access Data;
Key Points;
Chapter 4: Simplifying Data Entry with Forms;
Creating a Form by Using a Wizard;
Refining Form Properties;
Refining Form Layout;
Adding Controls to a Form;
Using Visual Basic for Applications to Enter Data in a Form;
Creating a Form by Using an AutoForm;
Adding a Subform to a Form;
Key Points;
Chapter 5: Locating Specific Information;
Sorting Information;
Filtering Information in a Table;
Filtering by Form;
Locating Information that Matches Multiple Criteria;
Creating a Query in Design View;
Creating a Query with a Wizard;
Performing Calculations in a Query;
Key Points;
Chapter 6: Keeping Your Information Accurate;
Using Data Type Settings to Restrict Data;
Using Field Size Properties to Restrict Data;
Using Input Masks to Restrict Data;
Using Validation Rules to Restrict Data;
Using Lookup Lists to Restrict Data;
Updating Information in a Table;
Deleting Information from a Table;
Key Points;
Chapter 7: Working with Reports;
Creating a Report by Using a Wizard;
Modifying a Report;
Creating a Report from Scratch;
Adding a Subreport to a Report;
Previewing and Printing a Report;
Key Points;
Chapter 8: Making It Easy for Others to Use Your Database;
Creating a Switchboard by Using Switchboard Manager;
Creating a Splash Screen;
Setting Startup Options;
Keeping Your Application Healthy;
Key Points;
Chapter 9: Keeping Your Information Secure;
Encrypting and Decrypting a Database;
Assigning a Password to a Database;
Sharing a Database;
Replicating a Database;
Splitting a Database;
Setting Up a Workgroup;
Maintaining a Workgroup;
Preventing Changes to a Database;
Securing a Database for Distribution;
Key Points;
Chapter 10: Working with Pages and Modules;
Creating Static Web Pages;
Exploring Visual Basic for Applications (VBA);
Using VBA to Create a Web Page;
Creating a Data Access Page with AutoPage;
Creating a Data Access Page Using the Page Wizard;
Allowing Others to Analyze Data On the Web;
Key Points;
Glossary;