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:
£300 + VAT
Course Date
Location
Demand led
Call to request dates
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 Form Features
Bound and Unbound Controls
Creating a Calculated Control
Toggle Buttons, Options & Check Boxes
Option Groups
List Boxes and Combo Boxes
Page Tabs
Advanced Report Features
Multiple Table Reporting
Sorting and Grouping Report Data
Performing Calculations on Reports
Creating Custom Report Pages
Creating & Modifying Charts
Forms & Reports using the Chart Wizard
Creating a Global Chart
Creating a Record Bound Chart
Formatting Charts
Using PivotChart View
Designing & Running Macros
Creating a Macro
Running a Macro
Macro Examples
AutoExec Macros & Startup Defaults
Designing Application Menus
Switchboards
Customising Menus and Toolbars
Creating Custom Menus and Toolbars
Customising Menus & Toolbars
Applying Custom Menus & Toolbars to Forms & Reports
