Users who need to develop databases which have complex structures or require an easy to use interface for a team or organisation to use.
Objectives:
By the end of the course the user will be able to develop databases which include automated features such as customised menus, macros and command buttons and utilise complex queries, forms and reports using grouping tools and including calculations.
Prerequisites:
Users must be able to confidently design and develop multiple table Access databases. Users will require a good understanding of relationships and the four core elements of Microsoft Access, i.e. tables, queries, forms and reports.
Duration:
2 Days
Cost:
£250 + VAT
Course Date
Location
12/03/2012
Liverpool
23/04/2012
Bradford
27/09/2012
Liverpool
25/10/2012
Bradford
Normalisation & Relationships
Understanding Normalisation
Join Types
Advanced Query Features
Changing the Join Type in a Query
Find Unmatched Queries
Find Duplicates Query
Crosstab Queries
Advanced Report Features
Multiple Table Reporting
Sorting and Grouping Report Data
Performing Calculations on Reports
Creating Custom Report Pages
Advanced Form Features
Bound and Unbound Controls
Creating a Calculated Control
Toggle Buttons, Options & Check Boxes
Option Groups
List Boxes and Combo Boxes
Page Tabs
Creating & Modifying Charts
Forms & Reports using the Chart Wizard
Creating a Global Chart
Creating a Record Bound Chart
Formatting Charts
Using PivotChart View
Macros & Database Automation
Creating a Macro
Running a Macro
Macro Examples
AutoExec Macros & Startup Defaults
Designing Application Menus
Switchboards
Creating Custom Menus and Toolbars
Customising Menus & Toolbars
Applying Custom Menus & Toolbars to Forms & Reports
