Advanced Access 2013

Delivery Options

• Live Online Training - Public Class (2 days): $450.00

» Free Demo

» Watch Presentation

» More Info

» Contact Education Consultant

• Customized Onsite Training (2 days): Request a Proposal

Upcoming Live eLearning Classes

There are currently no upcoming Live eLearning classes. Please contact us if you would like us to schedule a class.

Class Description

Class Overview

Class Goals

• Learn about database theory.
• Learn to work with Tables including using PivotTable and PivotChart Views.
• Learn to work with table relationships.
• Learn to work with queries at an advanced level.
• Learn to work with forms at an advanced level..
• Learn to work with reports at an advanced level..
• Learn to work with macros.

Class Outline

1. Database Theory
   1. Normalization Review
   2. Apply Normalization Principles
2. Tables
   1. Review
   2. Advanced Topics
      1. Importing
      2. Exporting
      3. Linking
   3. Properties
   4. PivotTable View
   5. PivotChart View
3. Relationships
   1. Review
   2. Creating Relationships between Tables
4. Queries
   1. Select Queries
   2. Calculated Select Queries
   3. Action Queries
      1. Make Table
      2. Append
      3. Update
      4. Crosstab
      5. Delete
   4. SQL View
   5. Expressions
   6. Subqueries
5. Forms
   1. Review
   2. Design View
      1. Adding Fields to a Form
      2. Arranging Fields on a Form
      3. Formatting
      4. Calculated Fields
      5. Setting Properties on a Form
   3. Datasheet Form
   4. Tabbed Form
   5. Modal Form
   6. Subforms
6. Reports
   1. Review
   2. Design View
      1. Report Sections
      2. Adding Fields to a Report
      3. Arranging Rields on a Report
      4. Formatting
      5. Calculated Fields
      6. Special Report Fields
      7. Setting Properties on a Report
   3. Pivot Charts
   4. Subreports
7. Macros
   1. Basic Actions
      1. Open a Table, Form, Report
      2. Run a Query
      3. Close a Window
   2. Creating a Simple Macro
   3. Running a Macro
8. Completing the Desktop Application
   1. Switchboard Form
   2. Running Macros from a Switchboard
   3. Setting the Switchboard as the Opening Form
   4. Providing User Access to Your Application
9. Database Theory
   1. Normalization Review
   2. Apply Normalization Principles
10. Tables
    1. Review
    2. Advanced Topics
       1. Importing
       2. Exporting
       3. Linking
    3. Properties
    4. PivotTable View
    5. PivotChart View
11. Relationships
    1. Review
    2. Creating Relationships between Tables
12. Queries
    1. Select Queries
    2. Calculated Select Queries
    3. Action Queries
       1. Make Table
       2. Append
       3. Update
       4. Crosstab
       5. Delete
    4. SQL View
    5. Expressions
    6. Subqueries
13. Forms
    1. Review
    2. Design View
       1. Adding Fields to a Form
       2. Arranging Fields on a Form
       3. Formatting
       4. Calculated Fields
       5. Setting Properties on a Form
    3. Datasheet Form
    4. Tabbed Form
    5. Modal Form
    6. Subforms
14. Reports
    1. Review
    2. Design View
       1. Report Sections
       2. Adding Fields to a Report
       3. Arranging Rields on a Report
       4. Formatting
       5. Calculated Fields
       6. Special Report Fields
       7. Setting Properties on a Report
    3. Pivot Charts
    4. Subreports
15. Macros
    1. Basic Actions
       1. Open a Table, Form, Report
       2. Run a Query
       3. Close a Window
    2. Creating a Simple Macro
    3. Running a Macro
16. Completing the Desktop Application
    1. Switchboard Form
    2. Running Macros from a Switchboard
    3. Setting the Switchboard as the Opening Form
    4. Providing User Access to Your Application

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following areas is required:

• Introduction to Access 2013

Courses that can help you meet these prerequisites:

• Introduction to Microsoft Access 2013

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

• Instructor-led Online course technical requirements and setup instructions.
• WebEx system requirements for Instructor-led Online delivery option.
• Onsite course technical requirements and setup instructions.