0
  • An empty cart

    You have no item in your shopping cart

0
  • An empty cart

    You have no item in your shopping cart

Enter your keyword

Course

Access 2010 – Part 2

National Business Training - Computer Training

Course Summary

Students will expand their knowledge of Microsoft® Access® 2010 to include relational database design, writing advanced queries, structuring existing data, sharing data across applications, and customizing reports.

Course Schedule

    • Start Date
    • End Date
  • Time
  • Price
  • Status
      • 3/27/2017
      • 3/28/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 5/18/2017
      • 5/19/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 6/26/2017
      • 6/27/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 7/20/2017
      • 7/21/2017
    • 9:00 am - 5:00 pm
    • $550
    • GTR
      • 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

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Course Objectives

 

Target Audience

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

 

Price $550.00

Date

Share our course