Microsoft Access : Intermediate

Microsoft Access : Intermediate

Course duration:

Course Objectives

To give a deeper understanding of the concepts behind and methods of using and designing Access Tables, Forms, Queries and Macros. The course will cover the following features:

Further Queries

• Using Totals queries for Summarising data
• Using Crosstab queries for Cross tabulating and Summarising data
• Using Action queries
• Make table queries
• Update queries
• Append queries
• Delete queries

Further Macros Design

• Collection macros into groups
• Naming macros
• Referring to a macro in a group
• Using the expression builder
• Controlling the properties of objects trough macros

Further Forms Design

• Main/Sub forms
• Linking main forms to sub forms
• Creating forms which contain charts
• Using the Pivot Table Wizard
• More advanced controls
• List boxes and combo boxes to lookup data in other tables/queries
• Option groups
• Calendar controls
• Tab Controls

Further Report DesignMain/Sub reports

• Linking main reports to sub reports
• Working with calculated controls and summary groups
• Referring to control values in a report
• Using conditional statements in a report
• Creating reports which contain charts