Microsoft Access† O365/2019 - Level 2 & 3 / Adv

Advanced Table Tasks

• Inserting Application Parts
• Using the Table Analyzer Wizard
• Creating Validation Rules
• Configuring Validation Messages
• Creating Lookup Fields
• Creating Value Lists
• Marking Fields as Required
• Marking a Field for Indexing
• Creating Input Masks

Advanced Form Tasks

• Limiting User Access to a Form
• Adding Calculated fields in a Form
• Using the expression Builder
• Creating Checkboxes and Command Buttons
• Building Command Button Events
• Creating Event Procedures
• Using Hyperlinks in a Form
• Adding Links to Other Database Objects
• Inserting a Mailto Link in a Form
• Adding a Browser Control to a Form
• Exporting Your Form to XML
• Exporting a Form as a Word Document
• Exporting a Form as HTML
• Sending a Form as an E-mail Attachment
• Exporting a Form to Other Formats

Creating Subforms

• Creating Subforms
• Using Subforms
• Linking Subforms with Parent Forms
• Formatting a Subform within a Main Form

Creating Split Forms

• Creating a Split Form
• Splitting an Existing Form
• Using a Split Form
• Fixing the Form Separator

Creating Navigation Forms

• Creating a Navigation Form
• Adding Tabs to a Navigation Form
• Creating a Tab Hierarchy
• Displaying the Navigation Form when the Database Opens

Creating Advanced Queries

• Creating and Using Parameter Queries
• Creating and Using Crosstab Queries
• Creating and Using Make-Table Queries
• Creating and Using Multiple Table Queries
• Creating and Using Append Queries
• Creating and Using Delete Queries
• Creating and Using Update Queries

Using Subqueries

• What is a Subquery?
• Creating a Subquery
• Subqueries with Aggregate Functions and Nested Subqueries
• Using the IN Keyword with Subqueries

Pivoting Data

• Creating a PivotTable
• Creating a PivotChart
• Using PivotTables and PivotCharts

Creating Advanced Report

• Adding Calculated Fields
• Adding Concatenated Fields
• Inserting Sub Reports
• Exporting Reports in Different Formats

Splitting the Database

• Backing Up the Database
• Splitting the Database

Add-Ons to Access

• COM Add-ins
• Digital Signatures
• Smart Tags
• Managing Your Database
• Customizing Access

SQL and Microsoft Access

• An Introduction to SQL
• Understanding SQL
• Using the Select Statement
• Using Subqueries
• Using SQL Joins

Students will learn,

• Advanced Table Tasks
• Advanced Form Tasks
• Creating Subforms
• Creating Split Forms
• Creating Navigation Forms
• Creating Advanced Queries
• Using Subqueries
• Pivoting Data
• Creating Advanced Report
• Splitting the Database
• Add-Ons to Access
• SQL and Microsoft Access

The prerequisites for this course are Access Level 1 or a solid working knowledge of Access or other database applications.

The prerequisites for this course are Access Level 1 or a solid working knowledge of Access or other database applications.