Course Offerings Adobe Cisco Citrix CompTIA/Computer Repair Critical & Soft Skills Crystal Reports Microsoft Office Microsoft Technical Oracle Security Seminars & User Groups VMware Public Schedule Options Classroom Customized Training Solutions for Business for Individuals for Partners Certifications Microsoft Comptia EC Council Cisco About Us Directions Cancellation Policy Solutions Student Resources

Microsoft Access Training

Microsoft Access helps you track and report information with ease. Get started quickly with prebuilt applications that you can modify or adapt to changing business needs.
Collect information through forms in e-mail or import data from external applications.
Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making.

Our instructor led courses are filled with examples and designed with hands-on lab exercises so you can practice as you learn.

Microsoft Access Queries & Reports
The Access Queries & Reports class is a one day, hands-on, instructor led course designed for students who need to work with existing Access relational databases to create queries and reports. The course introduces students to relational database concepts including fields, tables, and table relationships as well as modifying data through existing forms. During the class, students will build multi-table select queries and will create queries that can be used to perform calculations. Students will also build reports to present database information in printed format.
Queries & Reports courses currently offered:
Access 2003 Queries & Reports
Access 2007 Queries & Reports
Access 2010 Queries & Reports

Microsoft Access Level 1: Introduction to Access
Access Introduction is a hands-on, instructor-led course designed for individuals who will be creating and maintaining Access databases. The course introduces fundamental database terminology and concepts and helps prepare students to create databases for their use. During the class, students will design and build a simple multi-table relational database creating tables, fields, and table relationships. The course also introduces other database objects including creating select queries, forms, and reports.
Access Level 1 courses currently offered:
Access 2003 Level 1: Introduction to Microsoft Access
Access 2007 Level 1: Introduction to Access
Access 2010 Level 1: Introduction to Microsoft Access

Microsoft Access Level 2: Intermediate Topics
Recommended for experienced database users who want to learn the more complex features of Microsoft Access and intermediate database development skills, this course focuses on several key topics including: finding and joining data, creating flexible and advanced queries; reports, structuring data, and maintaining a database.
Access Level 2 courses currently offered:
Access 2003 Level 2: Intermediate Topics
Access 2007 Level 2: Intermediate Topics
Access 2010 Level 2: Intermediate Topics

Microsoft Access Level 3: Advanced Topics
Recommended for experienced Access users who wish to learn the essentials of database development. Key topics will include how to design Access applications including integrating data, improving forms, macros, switchboards, database startup properties, and security. Students will also be introduced to Visual Basic procedures.
Access Level 3 courses currently offered:
Access 2003 Level 3: Advanced Topics
Access 2007 Level 3: Advanced Topics
Access 2010 Level 3: Advanced Topics

Programming in Microsoft Access
This instructor-led course looks at the critical aspects of application development using Microsoft Access. You'll dig deep into forms, tables, queries, and reports, and explore modules as you learn to use Visual Basic for Applications (VBA). You'll learn how to programmatically display and manipulate data on forms and reports.

Questions? Email us at learn@vtec.org or Call us at (207)775.0244

Offers