|
Course aim
This course is for those wishing to develop advanced desktop applications
in Microsoft Access 2003.
Who should attend?
Delegates should have a good introductory knowledge of tables, queries,
forms, pages, reports and macros, together with some experience in creating
applications in Access. No knowledge of programming languages is required.
Training style
Informal and participative using a combination of trainer input, discussion
and practical exercises. This approach ensures the training meets the
needs of both the group and individual participants.
|
| |
Course contents
Access Review
Objects and terminology
Tables and External Data
Table design and relationships
Normalisation of data
Primary and secondary keys
Joint primary keys
Multiple indexes
Maintaining data integrity
Importing and linking tables
Application design
Advanced Queries
Parameter queries
Criteria in forms
Table joins
Action queries
Query wizards
SQL specific queries: Union pass-through
and data definition
Advanced Forms and Reports
Form layout properties
Pop-Up and modal forms
Report layout and grouping properties
Calculated fields in forms and reports
Sub-forms and sub-feports
Embedding charts on forms and reports
Advanced controls: Combo Box, List Box,
Option groups and command buttons
Control wizards
Combining queries and macros with forms
and reports
Macros and Event Procedures
Introduction to macros
Events on forms and reports
Macros groups
Conditional actions
Referring to controls on forms and reports
Attaching macros to events
Debugging macros
Using expressions
|
Developing the Application
Customising menus and toolbars
Startup dialog
Switchboard wizard
Multi-User Applications
Access workgroups
Exclusive and shared use
Record Locking - No locks, edited records and all records
Security
User and group accounts
Activating Access security
Setting permissions
Problems and pitfalls with Access security
Replication
Replicating databases on local and remote access networks
Database Optimisation
Compacting and repairing databases
Database performance
The analysers and documentor
Visual Basic for Applications
Where does VBA fit in?
When to choose macros or VBA
|
|
