Access 2013 Intermediate - Full Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this course, students will be able to:

  • Design a relational database
  • Join tables to retrieve data from unrelated tables
  • Organize a database for efficiency, performance, and to maintain data integrity
  • Share data between Access and other applications
  • Customize reports to organize the displayed information and produce specific print layouts

Course Content

Lesson 1:Designing a Relational Database

  1. Relational Database Design
  2. Create a Table
  3. Create Table Relationships

Lesson 2: Joining Tables

  1. Create Query Joins
  2. Join Tables that have No Common Fields
  3. Relate Data Within a Table
  4. Work with Subdatasheets
  5. Create Subqueries

Lesson 3: Organizing a Database for Efficiency

  1. Data Normalization
  2. Create a Junction Table
  3. Improve Table Structure

Lesson 4: Sharing Data Across Applications

  1. Import Data into Access
  2. Export Data to Text File Formats
  3. Export Access Date to Excel
  4. Create a Mail Merge

Lesson 5: Advanced Reporting

  1. Organize Report Information
  2. Format Reports
  3. Include Charts in a Report
  4. Add a Calculated Field to a Report
  5. Add a Subreport to an Existing Report

Appendix A: Additional Reporting Options
Appendix B: Microsoft Office Access 2013 Exam 77-424
Appendix C: Microsoft Office Access 2013 Common Keyboard Shortcuts 

If you would like to customize this course please contact us at (888)572-1200.

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!