Microsoft Access Advanced

Module 1: Creating Forms

• Working in Form design view
• Applying Form controls
• Date Picker control
• Adding Combo, List and Check Boxes to the Form
• Creating forms using Mainform – Subform
• Tabular forms
• Using Conditional formatting
• Additional Form topics

Module 2: Advanced Reports

• Using the Report Wizard
• Working with Report properties
• Grouping Reports
• Applying calculations in Reports
• Additional topics

Module 3: Advanced Query Techniques

• Working with Join properties
• Unmatched data
• Crosstab queries
• Union queries
• Action Queries
• Find duplicates query
• Find unmatched query

Module 4: Importing and Exporting Access Data

• Importing a spreadsheet from Excel
• Linking data tables to an Access database
• Export a table to Excel and text files
• Exporting reports
• Export to HTML format
• Export linked data source information to Excel (new)

Module 5: Access Macros

• Developing macros with Macro Designer
• Triggering data macros
• Running a macro
• Attaching a macro to a command button
• Running a macro from field properties
• Creating conditional macros
• Using sub macros

Module 6: Customising Access databases

• Database tools and utilities
• Compacting a database
• Hiding database objects
• Start-up options
• Create a user Switchboard

Module 7: Discussion Only (new)

• Access Web App features in Access Services (coming for SharePoint 2016)
• Cascading controls
• Datasheet filter improvements
• Related item control enhancements
• Image storage and performance improvements
• Office Add-ins integration with Access Web Apps
• Additional packaging and upgrade functionality for Access Web App packages
• On Deploy macro action for upgrade scenarios
• Lock tables from editing functionality
• Download in Excel feature for datasheet views