Microsoft Access - Advanced
Course Description
This is a Microsoft Access Advanced course. The teaching approach contains a mix of lectures, practical and one-to-one work and varies according to the people attending. For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.
Course Duration
1 day
Course Objectives
This course provides candidates with practical experience of the topics listed in the course outline below. On completion, candidates should have an excellent knowledge of the advanced features.
Course Content
CONCEPTS OF NORMALISATION
Database Design
TRANSFERRING DATA
Using Data from Another Source
Exchanging Data With Excel
Using The Linked Table Manager
Exporting Data
DATABASE UTILITIES
Adding Security Encryption To A Database (Password Protecting)
Compacting And Repairing A Database
Backing Up A Database
SPECIAL QUERIES
Join Types In A Query
Using The Crosstab Query Wizard
Using The Find Duplicates Query Wizard
Using The Unmatched Query Wizard
CREATING RELATIONSHIPS
Creating A Relationship
Setting Referential Integrity
Adding Cascade Options
Viewing Subdatasheets
Deleting A Relationship
FORM DESIGN TOOLS AND METHODS
Form Headers and Footers
Setting The Tab Order
Creating A PivotTable View
Filtering a PivotTable View
Using AutoCalc in a PivotTable View
Changing PivotTable View Properties
SPECIAL FORM DESIGN TECHNIQUES
Automating Forms with Controls
Creating A Command ButtonCreating A Combo Box
Creating A List Box
Creating An Option Group
Adding A Logic Control
ActiveX Controls
SPECIAL REPORT DESIGN TECHNIQUES
Controlling Sections in Report Design View
Creating A Calculated Control
Sorting a Report
Grouping Data In A Report
Creating Summary Calculations
Inserting a Page Break
USING SUBFORMS/SUBREPORTS
Creating MainForm/Subform and MainReport/SubReport Arrangements
Formatting Main/Sub Form/Report Arrangements
Displaying A Subform/Subreport Total
WORKING WITH MACROS
Introduction to the Macro Designer
Creating A Macro
Saving A Macro
Using Single Step Mode For Testing A Macro
Running A Macro
Editing An Existing Macro
Creating An Autoexec Macro
Macro Examples
USING SWITCHBOARDS
Using the Switchboard Manager
Opening A Switchboard Automatically
Database Design
TRANSFERRING DATA
Using Data from Another Source
Exchanging Data With Excel
Using The Linked Table Manager
Exporting Data
DATABASE UTILITIES
Adding Security Encryption To A Database (Password Protecting)
Compacting And Repairing A Database
Backing Up A Database
SPECIAL QUERIES
Join Types In A Query
Using The Crosstab Query Wizard
Using The Find Duplicates Query Wizard
Using The Unmatched Query Wizard
CREATING RELATIONSHIPS
Creating A Relationship
Setting Referential Integrity
Adding Cascade Options
Viewing Subdatasheets
Deleting A Relationship
FORM DESIGN TOOLS AND METHODS
Form Headers and Footers
Setting The Tab Order
Creating A PivotTable View
Filtering a PivotTable View
Using AutoCalc in a PivotTable View
Changing PivotTable View Properties
SPECIAL FORM DESIGN TECHNIQUES
Automating Forms with Controls
Creating A Command ButtonCreating A Combo Box
Creating A List Box
Creating An Option Group
Adding A Logic Control
ActiveX Controls
SPECIAL REPORT DESIGN TECHNIQUES
Controlling Sections in Report Design View
Creating A Calculated Control
Sorting a Report
Grouping Data In A Report
Creating Summary Calculations
Inserting a Page Break
USING SUBFORMS/SUBREPORTS
Creating MainForm/Subform and MainReport/SubReport Arrangements
Formatting Main/Sub Form/Report Arrangements
Displaying A Subform/Subreport Total
WORKING WITH MACROS
Introduction to the Macro Designer
Creating A Macro
Saving A Macro
Using Single Step Mode For Testing A Macro
Running A Macro
Editing An Existing Macro
Creating An Autoexec Macro
Macro Examples
USING SWITCHBOARDS
Using the Switchboard Manager
Opening A Switchboard Automatically
Who should attend?
Aimed at those people who wish to learn the advanced features of Microsoft Access. This course provides candidates with practical experience of the topics listed in the course outline. On completion, candidates should have an excellent knowledge of the advanced features.
Pre-requisites
Those attending should have an above average understanding of Microsoft Access to an intermediate level, be competent Windows users and be familiar with the basics of file and disk management.
