Microsoft Office Access 2013: Level 2 Training in Springfield

Enroll in or hire us to teach our Microsoft Office Access 2013: Level 2 class in Springfield, Illinois by calling us @303.377.6176. Like all HSG classes, Microsoft Office Access 2013: Level 2 may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Microsoft Office Access 2013: Level 2 may be taught at one of our local training facilities.

Answers to Popular Questions:

 
Yes, this class can be tailored to meet your specific training needs.
Yes, we provide consulting services.
Yes, group discounts are provided.

Course Description

 
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.
Course Length: 1 Days
Course Tuition: $250 (US)

Prerequisites

To ensure your success, it is recommended you have completed Microsoft® Office Access® 2013: Part 1, or possess equivalent knowledge.

Course Outline

 

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

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.