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
