|
Module
1 - Access 2000 Development
Foudation
This course covers the
Access 2000 environment / language and development issues including:
Object based development using Objects, Properties, Event Procedures
and Methods; Windows 95 Interface development (GUI standards); using
Access 2000 and the VBA programming language.
Other topics covered include:
The Tools - Tables, Forms, Queries,
Reports,
Modules
GUI Development and effective
Form design
Microsoft GUI standards
Developing Effective Menus and Toolbars
SQL and Queries
Recordset Types and Access Query Objects
Effective Database Design, Normalization
Effective use of Data Access Objects
(DAO)
VBA - Visual Basic for Applications
Data Types (Scope and Lifetime), Procedures
and Functions, Control Structures,
Parameters and Return Values
User defined types / Arrays
Debugging and Error Handling
Using
Object and Collections
Naming
Conventions
Containers
and Documents
ActiveX
Objects
Introduction
to Access and the Internet
On completion
of this module students will have a firm foundation in Windows programming
using Access 2000 and be able to write intermediate level Access
2000 programs using VBA.
|
|
Module
2 - Access 2000 Development
Advanced
This course
covers developing multi-user databases with an emphasis on locking,
performance, security and database design issues. Extending Access
2000 capabilities by using the Win32 API and ODBC calls are also
covered.
Other
topics include:
Advanced Error Handling
Database Optimization and Performance
Mutli-User Development Issues and
Performance
Locking and Conflicts and Transaction
Processing
Access Security, Groups and Permissions
Replication and Synchronization
Advanced SQL
Using the Windows API, Declaring and
Calling
Useful Windows API calls and other DLLs
Accessing External Data
Code Optimization and Performance
Client
Server Design and Development
ODBC
Setup and Direct ODBC API Calls
ODBC
Direct
Distributing
Applications and the Developers
Toolkit
ActiveX
Automation
Advanced
Internet Features
On
completion of this module the student will have an in-depth understanding
of relational database design and data access issues as well as
the Windows API and 3rd party OCX controls. These tools extend the
capabilities of the Access 2000 / VBA language. The student will
know how to effectively deploy multi-user systems and use ODBC to
develop a working Client Server system.
Furthermore
the student will understand advanced concepts such as concurrency,
locking, stored procedures, referential integrity, etc. This knowledge
can be applied to Access or any relational database on the market.
|
