 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 97 Developer
Course Aims
This intensive course is designed to introduce new MS Access 97 developers to some of the more advanced features and facilities of this software and to encourage confidence, control and creative use of MS Access. The course takes a structured look at some of the more advanced features, many using VBA. Access 97 features covered include writing Class Modules, programmatically changing menus and toolbars and linking into Outlook and other Office applications. |
Assumed Knowledge
A good working knowledge of Windows, the MS Access interface, table creation, basic query and report writing functions, macro development and relational database concepts gained from practical experience in developing simple applications. Prior attendance on an "Access Advanced User" course plus programming experience is essential. |
Course Audience
This course has been designed to help programmers and developers get up and running with Microsoft Access 97 as quickly as possible. |
|
Table of Contents
|
Creating Microsoft Access 97 Databases
|
System Tables - The MDB Data Dictionary
|
|
Relational Database Terminology
|
|
Organising Data into Tables ~ or Normalisation
|
|
Creating Tables in Access 97
|
|
Enforcing Referential Integrity
|
|
|
|
The VBA Programming Environment
|
When to use VBA instead of Macros
|
|
VBA Development Environment
|
|
Programming in the VBA Language
|
|
AutoData - A Debugging Feature
|
|
|
|
Error Handling in VBA Manipulating Data through Data Access Objects and SQL
|
Data Access Objects (DAO)
|
|
Opening Databases Programmatically
|
|
Database and Recordset Objects
|
|
Manipulating Data with VBA Methods
|
|
Finding Records in a Recordset
|
|
Editing Data in a Recordset
|
|
Using Recordsets to Manipulate Imported Data.
|
|
Creating, Using, and Deleting Queries from VBA
|
|
Changing Database Definitions through VBA
|
|
Using SQL to Manipulate Databases
|
|
|
|
Class Modules and Form-Event Procedures
|
Solutions: Soft Validation
|
|
Solutions: Value Derivation
|
|
Creating New Form Instances
|
|
Tying Forms/Reports Together
|
|
|
Optimizing Access 97 Databases
|
Using Indexes and the Rushmore™ Optimizer
|
|
De-normalizing for Maximum Performance
|
|
Optimizing Multi-user Systems
|
|
Optimizing Storage and Other Performance Enhancements
|
|
|
|
Interacting with other Applications through Automation
|
Sending Database Data to Word
|
|
Manipulating an Excel Spreadsheet from Access 97
|
|
Writing to Microsoft Outlook from Access 97
|
|
Access 97 as an OLE Server
|
|
|
|
Access 97 Security
|
Key Application Objects to Secure
|
|
|
|
|
Access 97 Database Replication
|
|
|
Using Access in a Multi-user Environment
|
Transaction Processing Statements
|
|
Handling Locking Errors in Access 97
|
|
|
|
Upsizing Access Databases to SQL Server
|
When and Why to Upsize to SQL Server
|
|
Preparing to Upsize - Planning in Advance
|
|
Modifying Upsizing Tool Settings
|
|
Post-Upsizing Considerations
|
|
|
|
Using Access 97 with the World Wide Web
|
Introduction to HTML and Web Pages
|
|
Outputting to Static Web Pages
|
|
|
|
|
|
