|
Course aim
This course is for those wishing to develop advanced desktop applications
in Microsoft Access 2007.
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
Using Action Queries
What are action queries?
Make table queries
Delete queries
Append queries
Update queries
The Query Wizard
Advanced Queries
Parameter queries
Criteria in forms
Table joins
Action queries
Query Wizards (find duplicates, find unmatched and crosstab)
SQL specific queries
Union and pass-through
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-reports
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
The Quick Access toolbar
Adding extra database options
Adding macros to the Quick Access toolbar
Modifying the buttons
Startup Dialog
Switchboard Manager
Security Settings
User and group accounts
Activating Access security
Setting permissions
Problems and pitfalls with Access security
The Office Button - Access Options Object Designers - setting up defaults
for forms, queries and reports
Trust Centre Settings - Trusted Locations
Database Optimisation
Compacting and repairing databases
Database performance
The Analyze Performance and Table and Database Documentor
Visual Basic for Applications
Where does VBA fit in?
When to choose macros or VBA
|
