Access 2000

Creating Tables and Relationships

• A Few Words About Database Design
• Creating Tables
• Creating Tables Using Design View
• Creating Relationships
• Importing and Linking to External Data

Creating Queries

• Query Basics
• Creating Query Criteria
• Fine Tuning Your Queries
• Multi-Table Queries and Joins

Getting Started with Forms

• Why Use Forms?
• Getting Started
• Creating a Bound Form
• Working with Properties
• Working with Other Control Types
• Creating an Unbound Form
• Managing Your Form's Interface

Displaying Data with Reports

• Comparing Forms and Reports
• Creating a Basic Report
• Introducing the Sorting and Grouping Window
• Performing Calculations on Reports
• Making Sections Behave
• TextBox Properties
• Performing More Complex Calculations
• Print Setup/Output

Building a Simple Application

• Putting Together an Access Application
• Using Hyperlinks in Access Applications
• Using the Command Button Wizard
• Creating Custom Menus, Shortcut Menus, and Toolbars
• Creating a Startup Form

Making Forms and Controls Work

• Modifying a Form's Caption
• Validating a Form's Data
• Using a Control's Data Events
• Introducing Combo (and List) Box

Working with VBA IDE

• A Quick Tour of VBA IDE
• Writing Code
• Testing Code

Effective Database Design

• Why Bother with Design?
• Relational Model Basics
• Normalization

Making the Most of Your Tables

• Building the Rules of the Business into the Database
• Relationships and Referential Integrity
• Creating Indexes

Parameter and Aggregate Queries

• Creating Parameter Queries
• Aggregate Queries
• Query Properties

Creating Data Access Pages

• Introducing Data Access Pages
• Working with Data Access Pages
• Creating a Data Access Page with Groups
• Deploying Data Access Pages

Investigating VBA

• Why Use VBA?
• Introducing Modules and Procedures
• Calling Procedures
• Creating Your Own Procedures
• Using Variables
• Variable Data Types
• Finishing the Age function
• Using Constants

Programming Objects

• Working with Objects
• Working with Collections
• Using Object Variables

Report Tips and Tricks

• Getting Just the Data You Want
• Creating Reports with Multiple Columns
• Numbering Items on a Report
• Using BackColor to Create Alternate Gray Lines

Controlling Controls

• Using Subforms
• Using MultiSelect ListBox Controls
• Handling New Entries in a Combo Box
• Working with Tab Controls

Programming Forms' Data

• Filtering and Sorting Forms
• Finding a Row on a Form
• Mark a Row and Return to it Later
• Using a Form's Recordset Property (Access 2000)

Form Tips and Tricks

• Creating a Splash Screen
• Using Popup Forms
• controlling a Form's Closing
• Tapping into Keyboard Events
• Using ActiveX Controls

Mastering Debugging

• Why Do You Need Debugging?
• Getting Started with Debugging
• Stepping Through Code
• Evaluating Expressions
• Tips on Effective Debugging

Taking Advantage of Queries

• Understanding Joins
• Action Queries
• Access SQL

Managing Data with ADO

• Introducing ActiveX Data Objects
• Retrieving Data with ADO
• Searching for Data in a Recordset
• Updating Data with ADO

Using Error Handling to Bullet-Proof Your Code

• Handling Run-Time Errors
• The Error Handling Standard
• Taking a Closer Look
• Who Handles Errors?

Designing Multiuser Applications

• Multiuser Architectures
• Locking
• Keeping Recordsets Current
• Transaction Processing

Exploring Replication

• Replication Basics
• Replicating a Database
• Changes Access Makes to a Database When Your Replicate it
• Synchronizing Replicas
• Conflict Management
• Partial Replication

Automating Office Applications

• What is Automation?
• Working with Other Applications
• Example: Building an Excel Chart
• MailMerge with Word
• Access as an Automation Server

Securing Your Applications

• Choosing the Right Security System
• Workgroups
• Users and Groups
• Permissions
• Using the Security Wizard to Properly Secure Your Database

Building Access Data Projects

• Introduction to Access Projects
• Creating a New Project
• Creating SQL Server Objects

Developing Access 2000 Client/Server Applications

• Introduction to Client/Server
• MDB versus ADP
• Designing Client/Server Applications
• Designing MDB Client/Server Applications
• Designing ADP Client/Server Applications

Deploying Access Applications

• The Finishing Touches
• Managing VBA Code
• Introducing the Access Runtime Version
• Developing Runtime Applications
• Deploying Access Applications

Appendix: (Access 97) Using the ODE

Appendix: (Access 97) Using the Setup Wizard

You can email DBST at: gmw@dbst.com or call: (507) 896-4488 and Gary will be happy
to answer any questions you may have about the services offered by DBST.