About AACTT

AACTT Courses

AACTT Services

Contact AACTT

AACTT Site Map

AACTT Home
AACTT Home
CLASS SCHEDULE LIVE-ONLINE ON-SITE / CUSTOM HOW TO REGISTER WHY CHOOSE AACTT SPECIAL SAVINGS

Private, Customized, On-line and On-site training also available.
Evening and/or Saturday classes may be scheduled by request, (subject to availability).
Call 847-590-9500 or e-mail info@aactt.com for price quote.

MS Access 2007 - Three

Microsoft Access 2007

Category: Databases

Cost: $295

Course Summary:

New! Learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data.

Prerequisite: Access Part II or equivalent.

Next Course of AACTTion: Any course.

Full Course Description: click here >> Access - Part III

If you need any printable PDF material, please send a request via email or call 847-590-9500.

Date

Day

Time

Duration

MAY 23, 2008

FRIDAY

9:00AM - 4:00PM

1 - DAY(S)

JUN 30, 2008

MONDAY

9:00AM - 4:00PM

1 - DAY(S)

JUL 09, 2008

WEDNESDAY

9:00AM - 4:00PM

1 - DAY(S)

AUG 22, 2008

FRIDAY

9:00AM - 4:00PM

1 - DAY(S)

SEP 26, 2008

FRIDAY

9:00AM - 4:00PM

1 - DAY(S)

Dates, prices and course outlines are subject to change without notice.

Access Part III - Course Description
 

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 the AutoKeys and AutoExec macros
  • Creating macros for data transfer

 

Importing, exporting, and linking

  • Importing objects
  • Exporting objects
  • Interacting with XML documents
  • Linking Access objects
  • Working with Windows SharePoint Services

 

Database management

  • Optimizing resources
  • Protecting databases
  • Setting options and properties

 

Internet integration

  • Hyperlink fields
  • Working with Outlook 2007

 

Back to Top

Site Map

AACTT Home

About Us

Courses & Schedule

Services

Contact Us

CLASS SCHEDULE CLASS SCHEDULE ON-SITE / CUSTOM ON-SITE / CUSTOM HOW TO REGISTER HOW TO REGISTER WHY CHOOSE AACTT WHY CHOOSE AACTT SPECIAL SAVINGS SPECIAL SAVINGS