Access 2013 Expert Course Outline

Access 2013 Expert

Module 1: SQL and Microsoft Access

What is SQL?

What is an SQL Statement?

What is an SQL Naming Convention?

What is SQL Syntax?

Review Questions

Module 2: Using the SELECT Statement

Selecting All Data

Selecting Specific Data

Selecting Conditional Data

Using the ORDER BY Statement

Review Questions

Module 3: Using SQL Joins

Creating Simple Joins

Using an Alias

Sorting Joins

Creating Outer Joins

Review Questions

Module 4: Using Subqueries

What is a Subquery?

Creating a Subquery

Subqueries with Aggregate Functions and Nested Subqueries

Using the IN Keyword with Subqueries

Review Questions

Module 5: Advanced Form Tasks, Part One

Limiting User Access to a Form

Creating Checkboxes and Command Buttons

Building Command Button Events

Creating Event Procedures

Review Questions

Module 6: Advanced 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

Review Questions

Module 7: Advanced 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

Review Questions

Module 8: Creating Split Forms

Creating a Split Form

Splitting an Existing Form

Using a Split Form

Fixing the Form Separator

Review Questions

Module 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

Review Questions

Module 10: Using the Trust Center

Opening the Trust Center

Trusting a Database

Configuring Macro Security

Customizing the Message Bar

Review Questions

Module 11: Managing COM Add-ins

Viewing Add-ins

Opening the Add-in Manager

Installing Add-ins

Disabling All Add-ins

Uninstalling Add-ins

Review Questions

Module 12: Customizing Access

Changing User Information

Changing the Office Background and Theme

Setting the Default Database Type and Location

Review Questions