Enter your keyword

Course

Access 2010 – Part 2

National Business Training - Computer Training

Course Summary

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.

Course Schedule

    • Start Date
    • End Date
  • Time
  • Price
  • Status
      • 9/14/2017
      • 9/15/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 11/30/2017
      • 12/1/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
  • S - ScheduledGTR - Guaranteed to Run

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

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.

Target Audience

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

 

Price $550.00

Date

Share our course