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

    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.

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