Access 2010 - Part 2

Course Overview

Students will learn advanced Access features such as, database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.

Who Should Attend

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2010 and need to learn advanced skills.

Course Objectives

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

  • Restructure data into appropriate tables to ensure data dependency and minimize redundancy.
  • Write advanced queries to analyze and summarize data.
  • Create macros.
  • Customize reports by using various Access features.
  • Maintain your database using Access tools.

    Suggested Prerequisites

    Next Steps and Related Courses

    Course Outline

    1 - Advanced Form Design

    • Adding Controls to Forms
    • Creating Subforms
    • Organizing Information with Tab Pages
    • Displaying a Summary of Data in a Form
    • Applying Conditional Formatting

    2 - Data Validation

    • Field and Record Validation
    • Form Validation

    3 - Using Macros to Improve User Interface Design

    • Creating a Macro
    • Restricting Records Using a Condition
    • Validating Data Using a Macro
    • Automating Data Entry Using a Macro
    • Converting a Macro to VBA

    4 - Advanced Database Management

    • Linking Tables to External Data Sources
    • Managing a Database
    • Determining Object Dependency
    • Documenting a Database
    • Analyzing the Performance of a Database

    5 - Distributing and Securing a Database

    • Preparing a Database for Multiple User Access
    • Implementing Security
    • Setting Passwords
    • Converting an Access Database to an ACCDE File
    • Packaging a Database with a Digital Signature

    6 - Managing Switchboards

    • Creating a Database Switchboard
    • Modifying a Database Switchboard
    • Setting Startup Options

  • Enroll Today

    This is a 2-day class

    Price: $590.00
    Payment Options

    ILT Instructor‑Led Training

    OLL Online LIVE

    GTR  Guaranteed to Run

    Class times are listed Central time. This class is available for Private Group Training

    To sort by location or date, click the ‘When’ and ‘Where’ column headings.

    Class dates not listed.
    Please contact us for available
    dates and times.