Call

Microsoft® Access® 2013: Level 2

< Back to Course Catalog

Duration:

1 Day (6.5 instructional hours)

Access 2013
Course Number: 091005

Course Objective:

Upon successful completion of this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports.

Target Student:

This course is intended for students who wish to gain intermediate-level skills or individuals who job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

Course Objective:

To ensure success, students will need to be familiar with using or have the equivalent knowledge of Microsoft® Office Access® 2013: Level 1.

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

< Back to Course Catalog