Professional Development Center

Access Advanced

Course Description

This course utilizes hands-on examples to demonstrate the benefits of Microsoft Access 2010. Students will learn how to write SQL statements to create queries. In addition crosstab, parameter, and action queries will be covered. Also, creating and running macros to automate tasks and attaching macros to events of database objects. Importing, exporting, and linking database objects will be taught. Finally, optimizing databases and basic database security.

Participants will gain an advanced skill set by learning to:

• Write SQL statements to create queries and attach an SQL statement to a command button.
• Create crosstab queries to summarize, parameter queries for criteria, and action queries to add, delete or modify table data.
• Create and run macros to automate tasks and attach macros to the events of database objects.
• Import objects into an active database, export objects from a database, and link database objects.
• Use a password to secure a database.

Who Should Attend

Administrative assistants, business systems analysts, database designers and help desk technicians will benefit from this course.

Prerequisites

Participants should the complete Access 2010 Intermediate course or have equivalent knowledge.

Course schedule

Thursday, August 8, 2013
8:30 a.m. -4:30 p.m.

Fall 2013 date: Thursday, Dec. 5, 2013 from 8:30 a.m.-4:30 p.m.
Call 216.687.6957 to register for Fall 2013.

CEUs: 0.7

Location

CSU's West Center, 26202 Detroit Road, Suite 312, Westlake, Ohio (map)

Fee

Standard:$195
CSU Alumni: $170

Includes course materials, a light morning snack, lunch, and parking.
*Participants who register for more than one Access course will receive a reduced rate.

Refund Policy

Registrants who cancel will receive a refund, less a $50 processing fee, if we receive written notification a minimum of seven business days prior to the first day of class. No refunds will be issued if notification is not received seven business days prior to the first day of class.

Registration Deadline:
Thursday, August 1, 2013