4.8 (302 reviews)
Are you ready to finalise your database?
In this Access Advanced course you will learn the techniques to create advanced queries, forms and reports, and a user interface that will easy enough for everyone to use.
Create crosstab queries to summarize data
Design dialog boxes and forms with data from multiple sources
Secure forms limiting user access and avoiding accidental data issues
Add advanced forms controls - combo-boxes, checkboxes and tabbed form
Automate with buttons to send emails with database content
Design advanced reporting, including merging to Word or Excel
Add Charts and PivotTables to to a form
Secure your database with a front-end;
Split the database for use on a network environment
Learn how to optimize and maintain the database
Course Overview
Audience:
Participants who need to create advanced databases or need to finalise a database for other users.
Prerequisites:
Participants must have completed the Intermediate level course or have equivalent knowledge.
Inclusions
Training Manual with step by step instructions
Practice files relevant to the training material
Completed files - you are free to take away any completed files for review
Unlimited online support as training does not stop when you walk out our door
Course Content
Advanced Queries
- Finding Null Values
- Changing the Join Type
- Queries using Blank /Null Fields
- Advanced Calculations in queries
- Using Date Functions in a query
- Crosstab Queries
- Creating a Crosstab Query using the wizard
- Formatting a Crosstab Query
- Crosstab query in a Report
- Manual Crosstab Queries
- Criteria with Crosstab Queries
Advanced Forms
- Subforms and Subreports
- Displaying a Subform in Datasheet View
- Displaying a Subform Total
- Locked and Enabled Property
- Limiting User Access to a Form
Modal Forms
- Modal Dialog Boxes
- Creating a Modal Dialog Box
- Adding Controls
- Setting Properties
- Formatting your Dialog Box
Automating Forms
- Creating Navigation Buttons
- Use Buttons to Add / Find Data
- Finding Data on a Form using a Combo Box
- Exporting Your Form
- Sending a Form via E-Mail
- Managing Replies
- Exporting your Form to XML
Advanced Form Controls
- Tab Page Control
- Inserting Pages in a Tab Control
- Formatting the Tab Controls
- Page Index
- Pictures on Tab Pages
- Tab Width and Tab Height
- Other Tab Control Properties
- Adding Controls to a Tab Control
- ActiveX Controls
- Registering an ActiveX Control
- Calendar Control
Advanced Reports
- Reports using Parameter Queries
- Modify the Report Record Source
- Advanced Groups in reports
- Grouping on Text fields
- Grouping on Date/Time fields
- Grouping on Multiple Sections
- Adding Graphics to Reports
Integrating with Word and Excel
- Mail Merge with Word
- Analysing Data with Excel
Creating Charts
- Chart Wizard
- Resizing a Chart
- Modifying the Chart
- Components of a Chart
- Fill Colour, Pattern and Textures
- Legends
- Changing the Chart Type
- Adding a Chart to a Report
Pivoting Data in Access
- Creating a PivotTable
- More about PivotTable Fields
- Completing your PivotTable
- Creating a PivotChart
- More about PivotChart Fields
- Completing Your PivotChart
Database Maintenance
- Analysing Performance
- Analysing Tables
- Viewing Object Dependencies
- Splitting a Database
Brochure