Access 2010 - Part 2

Price
$590.00

Duration
2 Days

Delivery Methods
VILT Private Group

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.

Upcoming Class Dates and Times

Coming Soon:
The next class is currently being scheduled. Need it now? No problem.
Contact us and we will help you get the training you need!

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

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.

Agenda

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

Prerequisite Courses Recommended

Access 2010 - Part 1

Next Course Recommendations

Access 2010 - Level 3