Basic

Lesson 1: The Basics

  • Topic A: Getting Started
  • Topic B: Signing In
  • Topic C: Creating a Database
  • Topic D: Database Terminology
  • Topic E: Saving a Database
  • Topic F: Opening a Database

Lesson 2: Your First Database

  • Topic A: About Security Warnings
  • Topic B: About Relationships
  • Topic C: Searching for Objects
  • Topic D: Opening Database Objects
  • Topic E: Changing the Object View
  • Topic F: Understanding the Types of Views Available
  • Topic G: Managing Objects

Lesson 3: Working with Tables and Records

  • Topic A: Creating a Table
  • Topic B: Understanding Table Views
  • Topic C: Adding and Editing Records
  • Topic D: Searching and Browsing Records
  • Topic E: Deleting Records
  • Topic F: Printing Records

Lesson 4: Formatting Tables

  • Topic A: Selecting Data
  • Topic B: Changing Column and Row Width and Height
  • Topic C: Applying Text Formatting
  • Topic D: Applying Gridlines
  • Topic E: Changing Fill Colors
  • Topic F: Checking Your Spelling

Lesson 5: Creating Forms

  • Topic A: Creating a Form from an Object
  • Topic B: Creating a Form with the Wizard
  • Topic C: Creating a Form from Scratch
  • Topic D: Understanding Form Views
  • Topic E: Using a Form

Lesson 6: Formatting Forms

  • Topic A: Understanding Bound and Unbound Controls
  • Topic B: Changing the Theme
  • Topic C: Using the Format Painter
  • Topic D: Adding Fields
  • Topic E: Adding Controls
  • Topic F: Adding Images and Logos

Lesson 7: Creating Reports

  • Topic A: Creating a Report from an Object
  • Topic B: Creating a Report with the Wizard
  • Topic C: Creating a Report from Scratch
  • Topic D: Understanding Report Views
  • Topic E: Printing Reports

Lesson 8: Formatting Reports

  • Topic A: Changing the Theme
  • Topic B: Using the Format Painter
  • Topic C: Grouping and Sorting Data
  • Topic D: Adding Controls
  • Topic E: Adding Images and Logos
  • Topic F: Adding Page Numbers, Headers, and Footers

Lesson 9: Creating Basic Queries

  • Topic A: Types of Queries
  • Topic B: Creating a Query with the Wizard
  • Topic C: Running a Query
  • Topic D: Understanding Query Views
  • Topic E: Sorting and Filtering a Query

Lesson 10: Creating Advanced Queries

  • Topic A: Creating and Using Parameter Queries
  • Topic B: Creating and Using Crosstab Queries
  • Topic C: Creating and Using Make-Table Queries
  • Topic D: Creating and Using Multiple Table Queries
  • Topic E: Creating and Using Append Queries
  • Topic F: Creating and Using Delete Queries
  • Topic G: Creating and Using Update Queries

Lesson 11: Managing Your Database

  • Topic A: Compacting and Repairing a Database
  • Topic B: Encrypting a Database with a Password
  • Topic C: Backing Up Your Database
  • Topic D: Exporting a Database and Database Objects
  • Topic E: Printing Database Objects

Lesson 12: Customizing the Interface

  • Topic A: Collapsing and Pinning the Ribbon
  • Topic B: Customizing the Quick Access Toolbar
  • Topic C: Hiding and Showing Ribbon Tabs
  • Topic D: Creating Custom Ribbon Tabs
  • Topic E: Resetting Interface Changes

Intermediate

Lesson 1: Managing Data

  • Topic A: Types of Relationships
  • Topic B: Viewing Relationships
  • Topic C: Viewing Object Dependencies
  • Topic D: What is Referential Integrity?
  • Topic E: Enforcing Referential Integrity
  • Topic F: Using Cascade Delete and Cascade Update

Lesson 2: Advanced Table Tasks

  • Topic A: Inserting Application Parts
  • Topic B: Using the Table Analyzer Wizard
  • Topic C: Creating Validation Rules
  • Topic D: Configuring Validation Messages

Lesson 3: Managing Data Entry in Tables

  • Topic A: Marking Fields as Required
  • Topic B: Marking a Field for Indexing
  • Topic C: Creating Lookup Fields
  • Topic D: Creating Value Lists
  • Topic E: Creating Input Masks

Lesson 4: Creating Subforms

  • Topic A: Creating Subforms
  • Topic B: Using Subforms
  • Topic C: Linking Subforms with Parent Forms
  • Topic D: Formatting a Subform within a Main Form

Lesson 5: Creating Navigation Forms

  • Topic A: Creating a Navigation Form
  • Topic B: Adding Tabs to a Navigation Form
  • Topic C: Creating a Tab Hierarchy
  • Topic D: Displaying the Navigation Form when the Database Opens

Lesson 6: Advanced Query Tasks

  • Topic A: Understanding SQL Statements
  • Topic B: Basic SQL Keywords
  • Topic C: Creating SQL Queries
  • Topic D: Using the Expression Builder

Lesson 7: Creating Modal Dialog Boxes

  • Topic A: Creating a Modal Dialog Box
  • Topic B: Adding Controls
  • Topic C: Setting Properties
  • Topic D: Formatting a Modal Dialog Box

Lesson 8: Splitting the Database

  • Topic A: Backing Up the Database
  • Topic B: Splitting the Database
  • Topic C: Configuring Access 2013 for a Multi-User Database
  • Topic D: Setting Record Locking Options

Lesson 9: Using Access with SharePoint Server

  • Topic A: Linking Tables and Lists
  • Topic B: Moving a Database to SharePoint
  • Topic C: Saving a Database to SharePoint
  • Topic D: About Access Web Apps

Lesson 10: Creating Basic Macros

  • Topic A: Creating a Standalone Macro
  • Topic B: Using the Action Catalog
  • Topic C: Adding Comments to Macros
  • Topic D: Using If-Then Actions
  • Topic E: Handling Macro Errors

Lesson 11: Advanced Macro Tasks

  • Topic A: Creating Event Procedures
  • Topic B: Creating Data Macros
  • Topic C: Creating Submacros
  • Topic D: Grouping Submacros

Lesson 12: Using Visual Basic for Applications

  • Topic A: Converting a Macro to Visual Basic
  • Topic B: Using Visual Basic for Applications
  • Topic C: Understanding Modules
  • Topic D: Building Visual Basic Procedures

Advanced

Lesson 1: SQL and Microsoft Access

  • Topic A: What is SQL?
  • Topic B: What is an SQL Statement?
  • Topic C: What is an SQL Naming Convention?
  • Topic D: What is SQL Syntax?

Lesson 2: Using the SELECT Statement

  • Topic A: Selecting All Data
  • Topic B: Selecting Specific Data
  • Topic C: Selecting Conditional Data
  • Topic D: Using the ORDER BY Statement

Lesson 3: Using SQL Joins

  • Topic A: Creating Simple Joins
  • Topic B: Using an Alias
  • Topic C: Sorting Joins
  • Topic D: Creating Outer Joins

Lesson 4: Using Subqueries

  • Topic A: What is a Subquery?
  • Topic B: Creating a Subquery
  • Topic C: Subqueries with Aggregate Functions and Nested Subqueries
  • Topic D: Using the IN Keyword with Subqueries

Lesson 5: Advanced Form Tasks, Part One

  • Topic A: Limiting User Access to a Form
  • Topic B: Creating Checkboxes and Command Buttons
  • Topic C: Building Command Button Events
  • Topic D: Creating Event Procedures

Lesson 6: Advanced Form Tasks, Part Two

  • Topic A: Using Hyperlinks in a Form
  • Topic B: Adding Links to Other Database Objects
  • Topic C: Inserting a Mailto Link in a Form
  • Topic D: Adding a Browser Control to a Form
  • Topic E: Performing Calculations in a Form

Lesson 7: Advanced Form Tasks, Part Three

  • Topic A: Exporting Your Form to XML
  • Topic B: Exporting a Form as a Word Document
  • Topic C: Exporting a Form as HTML
  • Topic D: Sending a Form as an E-mail Attachment
  • Topic E: Exporting a Form to Other Formats

Lesson 8: Creating Split Forms

  • Topic A: Creating a Split Form
  • Topic B: Splitting an Existing Form
  • Topic C: Using a Split Form
  • Topic D: Fixing the Form Separator

Lesson 9: Using Digital Signatures

  • Topic A: What is a Digital Signature?
  • Topic B: Obtaining a Digital Signature
  • Topic C: Attaching Your Signature to a Database
  • Topic D: Extract and Use a Signed Database

Lesson 10: Using the Trust Center

  • Topic A: Opening the Trust Center
  • Topic B: Trusting a Database
  • Topic C: Configuring Macro Security
  • Topic D: Customizing the Message Bar

Lesson 11: Managing COM Add-ins

  • Topic A: Viewing Add-ins
  • Topic B: Opening the Add-in Manager
  • Topic C: Installing Add-ins
  • Topic D: Disabling All Add-ins
  • Topic E: Uninstalling Add-ins

Lesson 12: Customizing Access

  • Topic A: Changing User Information
  • Topic B: Changing the Office Background and Theme
  • Topic C: Setting the Default Database Type and Location