Microsoft Access advanced training 2 days Level 2

Advanced tables in Microsoft Office Access

• Sharing data with Microsoft Office Excel
• Linking tables with Microsoft Office Access
• Use multiple columns in a list box
• Using database tools
• Changing a table property
• Creating list boxes in Microsoft Office Access
• Using a search query

Customize forms in Microsoft Office Access

• Using existing features
• Changing Form Properties in Microsoft Office Access
• Composing a sub-form
• Insert/Add Record Dependent & Non Dependent Illustrations
• Using Microsoft Office Access Controls for View
• Creating group boxes in Microsoft Office Access

Formatting reports in Microsoft Office Access

• Add chart to a report
• Adjusting the properties of a report
• Create subreport in Microsoft Office Access
• Exporting a report to Microsoft Office Word
• Designing a report template
• Adjusting the properties for control
• Group reports in Microsoft Office Access

Web capabilities of Microsoft Office Access

• Creating and Editing a Data Access Page
• Using the page wizard
• Adding hyperlinks to a page
• Grouping and sorting a page
• Apply a theme to the web

Using a Macro in Microsoft Office Access

• Run the action commands and set the action value
• Setting Determining Conditional Action Rules
• Create and run macros
• Using autokeys (macro group)

The control capabilities of Microsoft Office Access

• Build a macro for an event
• Run a macro from another macro
• Creating a Switchboard in Microsoft Office Access
• Setting a password
• Setting Startup Options in Microsoft Office Access
• Synchronizing Microsoft Office Access Forms
• Creating a Macro Button in Microsoft Office Access

If you do not yet master the basic knowledge, it is better to Microsoft Access Basic training 2 days Level 1 Follow.

For more related training, please visit the Microsoft look at overview page, examples are the Advanced VBA Excel training 2 days, Microsoft Azure Fundamentals 1 day (AZ-900-1), Microsoft Excel Power Pivot Advanced – DAX (1 day) Level 2, Microsoft Office Sharepoint Advanced training 2 days level 2, Microsoft Powerpoint advanced training 1 day level 2 & Microsoft Word Advanced training 1 day level 2 of Microsoft Word Expert 1 day level 3.