Microsoft Access 2013: Beginner to Advanced

Course Curriculum

Chapter 1: Access 2013, Beginner – Course Overview

Lecture 1: Course Overview

Chapter 2: Lesson One – Getting Started with Access 2013

Lecture 1: Getting Started with Access 2013 – Lesson Introduction

Lecture 2: Orientation to Microsoft Access

Lecture 3: Edit Table and Rows

Lecture 4: The Records Bar

Lecture 5: Use Forms for Data Entry

Lecture 6: Use Queries

Lecture 7: Use Reports

Lecture 8: Explore Access Ribbon Commands

Lecture 9: Create a Simple Access Database

Lecture 10: Create a Form

Lecture 11: Get Help in Microsoft Access

Lecture 12: Getting Started with Access 2013 – Summary

Chapter 3: Lesson Two – Working with Table Data

Lecture 1: Working with Table Data – Lesson Introduction

Lecture 2: Modify Table Data

Lecture 3: Sort and Filter Records

Lecture 4: Purpose of Primary Key

Lecture 5: Configuring Form Lookup Field

Lecture 6: Working with Table Data – Summary

Chapter 4: Lesson Three – Querying a Database

Lecture 1: Querying a Database – Lesson Introduction

Lecture 2: Join Data from Different Tables in a Query

Lecture 3: Sort and Filter Data in a Query

Lecture 4: Perform Calculations in a Query

Lecture 5: Querying a Database – Summary

Chapter 5: Lesson Four – Creating Advanced Queries

Lecture 1: Creating Advanced Queries – Lesson Introduction

Lecture 2: Create Parameter Queries

Lecture 3: Use Wildcards in a Parameter Query

Lecture 4: Create a Query with Multiple Parameters

Lecture 5: Create Action Queries

Lecture 6: Create Unmatched and Duplicate Queries

Lecture 7: Summarize Data

Lecture 8: Creating Advanced Queries – Summary

Chapter 6: Lesson Five – Generating Reports

Lecture 1: Generating Reports – Lesson Introduction

Lecture 2: Create a Report

Lecture 3: Use the Report Wizard

Lecture 4: Add Controls to a Report

Lecture 5: Enhance the Appearance of a Report

Lecture 6: Prepare a Report for Print

Lecture 7: Generating Reports – Summary

Chapter 7: Lesson Six – Customizing the Access Environment

Lecture 1: Customizing the Access Environment – Lesson Introduction

Lecture 2: The Access Options Dialog Box

Lecture 3: Customizing the Access Enviroment – Summary

Chapter 8: Access 2013, Intermediate – Course Follow-Up

Lecture 1: Course Follow-Up

Chapter 9: Access 2013, Intermediate – Course Overview

Lecture 1: Course Overview

Chapter 10: Lesson One – Designing a Relational Database

Lecture 1: Designing a Relational Database – Lesson Introduction

Lecture 2: Analyzing the Relational Database Design Process

Lecture 3: Create a Table

Lecture 4: Create Table Relationships

Lecture 5: Designing a Relational Database – Summary

Chapter 11: Lesson Two – Joining Tables

Lecture 1: Joining Tables – Lesson Introduction

Lecture 2: Create Inner and Outer Joins

Lecture 3: Join Unrelated Tables

Lecture 4: Create a Self Join

Lecture 5: Modify Data in a SubDatasheet

Lecture 6: Create Subqueries

Lecture 7: Joining Tables – Summary

Chapter 12: Lesson Three – Organizing a Database for Efficiency

Lecture 1: Organizing a Database for Efficiency – Lesson Introduction

Lecture 2: Run the Table Analyzer Wizard

Lecture 3: Create Many to Many Relationship

Lecture 4: Improve Table Structure

Lecture 5: Organizing a Database for Efficiency – Summary

Chapter 13: Lesson Four – Sharing Data Across Applications

Lecture 1: Sharing Data Across Applications – Lesson Introduction

Lecture 2: Import Data from Text File

Lecture 3: Import Data from Excel File

Lecture 4: Export Data to Text File Formats

Lecture 5: Export Data to Excel

Lecture 6: Merge Access Data with Word

Lecture 7: Sharing Data Across Applications – Summary

Chapter 14: Lesson Five – Advanced Reporting

Lecture 1: Advanced Reporting – Lesson Introduction

Lecture 2: Make Report Design Modifications

Lecture 3: Format Reports

Lecture 4: Add Data Bars to Reports

Lecture 5: Add a Calculated Field to a Report

Lecture 6: Add a Subreport to an Existing Report

Lecture 7: Advanced Reporting – Summary