logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

System Source Learning Center
410-771-5544

Call us for more information and to schedule your classes.

Access 2010/2013 Part 2

Course description

 

PREREQUISITES:

 

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

 

WHO SHOULD ATTEND:

 

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.

 

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

 

 


Disclaimer: All course objectives and outlines are a guide for students. The course topics and order of presentation may be modified based upon the needs of each individual class.