Access Level 4
CTU-ACCESS10L4-C

 Email this information to yourself or a friend

 Remind me of this course at a later date




Official Program Description

Access Level 4


jump to schedules and register

In this course you will learn how to exchange data with other applications, automate business processes by using VBA code, and secure and share databases.This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft® Office Access® application, and are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a Web-based environment and may need to adapt Access applications to the environment.

Who Should Attend

This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft® Office Access® application, and are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a Web-based environment and may need to adapt Access applications to the environment.

Prerequisites

To ensure the successful completion of this class, it is recommended that you have completed Microsoft® Office Access® 2010: Levels 1, 2, and 3, or have equivalent knowledge.

Attend and You Will Learn

Integrating Access into Your Business

  • Importing XML data into an Access database
  • Exporting Access data to the XML format
  • Exporting data to an Outlook address book
  • Collecting data through email messages

Automating a Business Process with VBA

  • Creating a standard module
  • Developing code
  • Calling a procedure from a form
  • Running a procedure

Managing Switchboards

  • Creating a database switchboard
  • Modifying a database switchboard
  • Seting the startup options

Distributing and Securing Databases

  • Splitting a database
  • Implementing security
  • Setting passwords
  • Converting an Access database to an ACCDE file
  • Packaging a database with a digital signature

Sharing Databases Using a SharePoint Site

  • Exporting a table to a SharePoint list
  • Importing data from a SharePoint list
  • Publishing a database to a SharePoint site
  • Moving a database to a SharePoint site
  • Working offline



Sections

  Access Level 4
CTU-ACCESS10L4-C - 011
   
 
  2016 - TTS - Jul - Aug 2015   Status:  Available
 
In-Class:   Wed, Thu 9:00AM - 4:30PM
19 Aug 2015 to 20 Aug 2015
Class Schedule: 2 Sessions
Contact Hours: 12.0
Course Fee(s):
Registration Fee non-credit    $449.00
Gov't & Non-Profit Registration Fee non-credit    $349.00
Potential Discount(s):
CTU-MultClassDisc>250
  1.20 CEUs
Location:   On Campus
 
  Access Level 4
CTU-ACCESS10L4-C - 012
   
 
  2016 - TTS - Sep - Dec 2015   Status:  Canceled
 
In-Class:   Wed, Thu 9:00AM - 4:30PM
2 Dec 2015 to 3 Dec 2015
Class Schedule: 2 Sessions
Contact Hours: 12.0
Course Fee(s):
Registration Fee non-credit    $449.00
Gov't & Non-Profit Registration Fee non-credit    $349.00
Potential Discount(s):
CTU-MultClassDisc>250
  1.20 CEUs
Location:   On Campus