Microsoft Access Application Development
Course Duration: 2 days
 Printer-friendly
version
Course Objective
By the end of the course, delegates will be able to:
- Use design considerations
to adopt a consistent development style
- Manage data integrity
- Build front end , popup and dialog forms and
amend the switchboard form created by the database wizard
- Introduction
to Visual Basic and when to use VBA instead of macros
- Set database
options for multi-users
- Determine security requirements
- Document a database using database
documentor
- Use the add-in manager
- Understand how to optimise performance
- Understand the issues involved
in distributing applications with the Microsoft Office Developer
Delegate
Profile
This course is intended for business productivity
users who wish to distribute applications using
Microsoft Access.
Pre-Requisites
Experience of using the Windows operating system
Experience of database design using Access objects (i.e. attendance
on the Access - Introduction to
Database Design Course)
Structure
Each delegate has the exclusive use of a PC and training includes extensive
hands-on activity.
Course Content
Application design process
Application design considerations
Managing data integrity
Creating relationships – different types
Using referential integrity
Cascading updates and deletes
Managing the user interface
Building front-end forms
Building pop-up and dialog forms
Using the database wizard
Managing external data sources
When to import tables & when to
attach
Using OLE to view data in other applications
Use hyperlinks to navigate between Microsoft Office documents
Advanced
features
Distributing applications with the Microsoft Office
Developer
Rolling out an application
Customise the application
start-up process
Split the application for ease of maintenance
Set database options for multi-users
Determine security requirements
Access configuration
Optimising performance
1. Access
2. Form Opening
3. Event Processing
Macros vs modules
Introduction to Visual Basic for
Applications and when to use it
Creating a VBA function
Creating & de-bugging a procedure in a general module
 Back
to the top
|
