Microsoft Office Access 2016 Advanced

Candidates will learn specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports and maintaining a database .

Essentials training

1. SQL and Microsoft Access

  • Importing Information
  • Exporting Information
  • Copying o and from Other Office Programs

2. Using the SELECT Statement

  • Selecting All Data
  •  Selecting Specific Data
  •  Selecting Conditional Data
  •  Using the ORDER BY Statement

3. Using SQL Joins

  • Creating Simple Joins
  •  Using an Alias
  •  Sorting Joins
  •  Creating Outer Joins

4. Using Subqueries

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

5. Advanced Form Tasks, Part One

  • Limiting User Access to a Form
  •  Creating Checkboxes and Command Buttons
  •  Building Command Button Events
  •  Creating Event Procedures

6Advanced Form Tasks, Part Two

  • 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
  • Performing Calculations in a Form

7Advanced Form Tasks, Part Three

  • 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

8. Creating Split Forms

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

9.Using Digital Signatures

  • What is a Digital Signature?
  • Obtaining a Digital Signature
  • Attaching Your Signature to a Database
  • Extract and Use a Signed Database

10. Using the Trust Center

  • Opening the Trust Center
  • Trusting a Database
  • Configuring Macro Security
  • Customizing the Message Bar

11. Managing COM Add-ins

  • Viewing Add-ins
  • Opening the Add-in Manager
  • Installing Add-ins
  • Disabling All Add-ins
  • Uninstalling Add-ins

12Customizing Access

  • Changing User Information
  • Changing the Office Background and Theme
  • Setting the Default Database Type and Location

Course Days: 1 Day