MicroKnowledge Computer Training and Consulting Access 2007 Advanced

MicroKnowledge Inc.

Contact | Driving Directions | Home

Access 2007 Advanced

Explore SQL and advanced queries, automate tasks with macros, work with external data, and manage the database.

Recommended preparation: Access 2007 Intermediate or equivalent knowledge.

Register for a class
Personalized training and consulting is available upon request.

Lesson 1: Querying with SQL

SQL and Access
Writing SQL statements
Attaching SQL queries to controls

Lesson 2: Advanced queries

Creating crosstab queries
Creating parameter queries
Using action queries

Lesson 3: Macros

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

Lesson 4: 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

Lesson 5: Importing, exporting, and linking objects

Importing objects
Exporting objects
Linking Access objects

Lesson 6: Database management

Optimizing resources
Protecting databases

21 British American Blvd. Latham, NY 12110 Phone: 518.786.1181 Fax: 518.786.6221

Dates:
November 3
8:30-4:30

January 12
8:30-4:30

Price:
$169 for open enrollment courses, when available.

Length: 8 Hours

Quick Links

Request information

Register for a class

Get follow-up support

Create a My MicroKnowledge profile