Course List >> Microsoft® Access® Level 3

MICROSOFT® ACCESS ® LEVEL 3

Description:
In this course, you will cover how to query with SQL, write SQL statements, attach SQL queries to controls, create cross tab queries, create parameter queries, use action queries; create, run, and modify macros, attach macros to the events of the database objects; work with advanced macros to provide user interaction, user input and data transfer; importing, exporting, and linking objects, database management including optimizing resources, replicating, and synchronizing databases, security fundamentals, protecting databases, encrypting and decrypting databases, and user-level security.

Upon successful completion of this course, students will be able to:

• restructure an existing set of data to improve the design of a database.
• use a variety of techniques to summarize and present data with queries.
• create and revise basic Access macros.
• create macros that improve data entry efficiency and integrity.
• improve the effectiveness of data entry in forms.
• improve the effectiveness of data displayed in reports.
• maintain an Access database by using various utility tools.
• (topics listed are for Access 2003; may vary slightly for Access 2007)

Prerequisite: Access® Level 2 or equivalent knowledge

Training Type: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Max # of students = 6.
**Available for Private or Group Sessions**

Cost: $159

Course Includes:

• Professional Textbook
• Take-home CD or downloadable materials with practice examples
• 1 month of email/phone support
• 1 year for a free re-take of the same course

Class Info: 1 day course | Time: 9:30am-approx 3pm (class times may vary). Several breaks are taken throughout the day. | Class size limited

How to register:Use our Course Information Request Form . We will contact you regarding scheduling and availability.