Access 2010: Advanced

Course ID

27040

Course Description

Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.

Prerequisites

Access 2010: Intermediate

Audience

Students who have a comprehensive understanding of the basic and advanced features of the Microsoft ® Office Access ® 2010 application, and would like to build skill sets as an administrator, working in a web-based environment, and adapting Access applications to various environments.

Course Content

    Querying with SQL
  • SQL and Access
  • Writing SQL statements
  • Attaching SQL queries to controls

    Advanced queries
  • Creating crosstab queries
  • Creating parameter queries
  • Using action queries

    Macros
  • Creating, running, and modifying macros
  • Attaching macros to the events of database objects

    Advanced macros
  • Creating macros to provide user interaction
  • Creating macros that require user input
  • Creating AutoKeys and AutoExec macros
  • Creating macros for data transfer

    Importing, exporting, and linking objects
  • Importing objects
  • Exporting objects
  • Working with XML documents
  • Linking Access objects
  • Using hyperlink fields

    Database management
  • Optimizing resources
  • Protecting databases
  • Setting options and properties

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 1 day
Price - $250.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.