Microsoft Access Level Three
1 or 2 day course depending on experience and requirements
This
course is aimed at delegates who understand the structure of Access
databases and how to create and edit basic Tables, Forms, Queries and
Reports. At the end of the course the learner will be able to customise
Access and use advanced features to create professional and efficient
queries and reports. During the course the learner will practice their
skills with skill reviews and exercises. An evidence of learning form will
be completed during the course and verified by the trainer. This can be
used to prove competency in the areas covered by the learner. A
certificate of completion will also be issued.
· Customising Access
Menus and Toolbars
· Creating a Subform
· Removing a Form
Header and Footer
· Customising a Form
· Creating Nested
Subforms
· Creating Expressions in Forms
· Calculating Totals
in a Subform
· Creating Custom Calculations
· Using Aggregate
Functions with Calculated Fields
· Using Dates in a Query
·
Creating Calculated Date Fields
· Creating a Parameter Query
·
Creating a Crosstab Query
· Creating an Append Query
· Creating
a Select Query
· Customising a Report
· Adding Background
Pictures and Colour to a Report
· Creating Command Buttons
·
Adding a ScreenTip
