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
Keyword
Course #
State

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


Microsoft Access 2010 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  
 9/8/2017
 $199
Enroll
 9/8/2017
 $199
Enroll
 11/8/2017
 $199
Enroll
 11/8/2017
 $199
Enroll
 12/19/2017
 $199
Enroll
 12/19/2017
 $199
Enroll

To Inquire About Future Classes

Request a class date

if one is not scheduled.