Microsoft Office Access 2013: Level 2 Training

Upcoming Instructor Led Online and Public Microsoft Office Access 2013: Level 2 classes
Microsoft Office Access 2013: Level 2 Training/Class 10 January, 2020 - 10 January, 2020 $250
HSG Training Center 1624 Market Street, Suite 202
Denver, CO 80202
Hartmann Software Group Training Registration
Microsoft Office Access 2013: Level 2 Training/Class 14 February, 2020 - 14 February, 2020 $250
HSG Training Center 1624 Market Street, Suite 202
Denver, CO 80202
Hartmann Software Group Training Registration
Microsoft Office Access 2013: Level 2 Training/Class 13 March, 2020 - 13 March, 2020 $250
HSG Training Center 1624 Market Street, Suite 202
Denver, CO 80202
Hartmann Software Group Training Registration
We offer private customized training for groups of 3 or more attendees.

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.