Ability Software Consultants +44 (0)1531 828366
info@officecourseware.com
Instructor with Microsoft Office, OpenOffice and StarOffice training coursewareOfficecourseware.com

Home Titles Costs Contact Us Links

Table of contents from instructor-led courseware notes. Page numbers are for guidance only and may vary. Courseware notes are formatted for double-sided printing.

Microsoft Access 2000 Developer

Before Programming

Macros

Simple Macros
Automating Applications
Macro Limitations

Programming Concepts

Programming for Windows
Visual and Code Programming

Using VBA

Event Procedures
Changing Properties
Changing Data
Exercise: Setting a field's value in response to an event.

Memory Variables and Constants

Variables
Data Types
Constants

Sub Routines

Exercise: An Error Logging Sub Routine

Functions

Declarations
Exercise: String Manipulation Function

Responding to Events

Exercise: More Complex Validation Rules
Exercise: The NotInList Event

ACTIVEx Controls

The Calendar
Exercise: Multipurpose PickDate() Function
Common Dialogs
Exercise: The Common Dialog

Security

Users and Groups
The Admin User
Permissions
Ownership
Securing a Database. Method 1
Securing a Database. Method 2
Setting a Password on a Database

Data Access Objects

Object Containers
Databases
Table Definitions
Exercise: Refreshing Linked Tables with Data Access
Query Definitions
Recordsets
Workspaces

Error Handling

Exercise: Trapping Referential Integrity Errors
Exercise: Trapping Expected Errors

The Access Developers Toolkit

Development Considerations
Running an ADT application

The Windows Registry

ACTIVEX Automation

Exercise: Spellcheck using Automation

  Word 2000 Intro
Word 2000 Adv
Word 2000 VBA
Excel 2000 Intro
Excel 2000 Adv
Excel 2000 Dev
PowerPoint 2000
Access 2000 Intro
Access 2000 Adv
Access 2000 Dev
Outlook 2000
FrontPage 2000
Project 2000
Visio 2000		  


All trademarks and product names used on this web page are for identification purposes only and are acknowledged as the registered trademarks of their respective owners. Officecourseware.com and Ability Software Consultants do not claim the endorsement of, or to represent, any of the companies whose names or products are presented on this page.