Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Access 2010 - Level 2 & 3 / Advanced

New – Learn to perform advanced form task using subfoms and macros.

GK# 6697

Course Overview

TOP

Students will learn to perform advanced form task using subfoms and macros. Students will create pivot tables, and pivot charts and be introduced to SQL statements.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP

In this course, you will be given the tools to become an Access 2010 power user. Learn in depth methods to manage data and data entry; create forms, and dialog boxes; split databases; create and use pivot tables and charts; utilizing Add-Ons and SQL.

Outline

TOP
Viewing outline for:

Classroom Live Outline

Advanced Table Tasks

  • Using the Table Analyzer Wizard
  • Creating Validation Rules
  • Configuring Validation Messages

Managing Data Entry in Tables

  • Creating Lookup Fields
  • Creating Value Lists
  • Creating Input Masks

Creating Advanced Queries

  • Creating and Using Parameter Queries
  • Creating and Using Crosstab Queries
  • Creating and Using Make-Table Queries
  • Creating and Using Multiple Table Queries
  • Creating and Using Append Queries
  • Creating and Using Delete Queries
  • Creating and Using Update Queries

Creating Subforms

  • Creating Subforms
  • Using Subforms
  • Linking Subforms with Parent Forms
  • Formatting a Subform Within a Main Form

Creating Navigation Forms

  • Creating a Navigation Form
  • Adding Tabs to a Navigation Form
  • Creating a Tab Hierarchy
  • Displaying the Navigation Form when the Database Opens

Splitting the Database

  • Backing Up the Database
  • Splitting the Database

Advanced Data Management

  • Referential Integrity
  • Table Relationships
  • Switchboards
  • Modal Dialogue Boxes

Advanced Form Tasks

  • Using Subforms
  • Advanced Form Tasks
  • Exporting Your Form
  • Using Outlook and SharePoint with Access

Pivoting Data

  • Creating a PivotTable
  • Creating a PivotChart
  • Using PivotTables and PivotCharts

Access and Windows

  • Access and Windows
  • Using the Access Viewer
  • An Introduction to SQL

Add-Ons to Access

  • COM Add-ins
  • Digital Signatures
  • Smart Tags
  • Managing Your Database
  • Customizing Access

Using Scripts in Access

  • Macro Basics
  • Other Macro Tasks
  • Visual Basic and Macros
  • Macro Groups

Using Access to Collaborate

  • SharePoint Basics
  • SharePoint Data
  • Your Personal SharePoint Space

SQL and Microsoft Access

  • Understanding SQL
  • Using the Select Statement
  • Using Subqueries
  • Using SQL Joins

Prerequisites

TOP

The prerequisites for this course are Access Level 1 or a solid working knowledge of Access or other database applications.

Who Should Attend

TOP

For those who require greater complexity and utility in their data management than Access Level 1 provides.

Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 2 day

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 2 day

Request this course in a different delivery format.
Enroll