Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Gold Training Partner
Search for a Course Topic:
Public Courses
Corporate Services & Training



 Course Search
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
View Courses
Site Index

Microsoft Access 2013 Level 2 Overview

  • Lesson 1: Designing a Relational Database

    • Topic A: Relational Database Design

    • Topic B: Create a Table

    • Topic C: Create Table Relationships

  • Lesson 2: Joining Tables

    • Topic A: Create Query Joins

    • Topic B: Join Tables That Have No Common Fields

    • Topic C: Relate Data within a Table

    • Topic D: Work with Subdatasheets

    • Topic E: Create Subqueries

  • Lesson 3: Organizing a Database for Efficiency

    • Topic A: Data Normalization

    • Topic B: Create a Junction Table

    • Topic C: Improve Table Structure

  • Lesson 4: Sharing Data Across Applications

    • Topic A: Import Data into Access

    • Topic B: Export Data to Text File Formats

    • Topic C: Export Access Data to Excel

    • Topic D: Create a Mail Merge

  • Lesson 5: Advanced Reporting

    • Topic A: Organize Report Information

    • Topic B: Format Reports

    • Topic C: Include Control Formatting in a Report

    • Topic D: Add a Calculated Field to a Report

    • Topic E: Add a Subreport to an Existing Report

  • Appendix A: Additional Reporting Options

  • Appendix B: Microsoft Office Access 2013 Exam 77-424

  • Appendix C: Microsoft Access 2013 Common Keyboard Shortcuts


View Printer Friendly Page

Course Schedule
  Start Date  City  Price  

To Inquire About Future Classes

Request a class date

if one is not scheduled.