Microsoft Access

Microsoft Office Access 2007 is a relational database software using powerful tools that enable you to organize and manage database information as well as create your own custom applications. 

Beginners can enhance their own productivity by understanding the basic relationships and how to manipulate data. Access allows users to quickly create and use a database with pre-defined tables, queries, forms and reports. 

Access is very popular among non-programmers who can create visually pleasing and relatively advanced databases. 

Our training courses will introduce various levels of training on Access 2007 and Access 2003 from basic to advanced to fit your level of interest.  If you have the basics down and want more, try the advanced course where we will show you how to automate everyday tasks.

Beginner	Intermediate	Advanced
Exploring the Environment Getting Started with Access 2007 Using a Database Template Overview of the User Interface Navigating in the Database Building a Database Create a New Database Creating a Table Managing Tables Overview Table Relationships Managing Data in a Table Add Table Data Modify Table Data Sort Records Filter Records Working with Queries Create a Query Add Criteria to a Query Sorting a Query Using Multiple Fields Using AND and OR Operator Design Forms Creating a Form View Data Using an Access Form Create a Form Using the Form Wizard Modify the Design of a Form Format the Controls in a Form Generating Reports View an Access Report Creating a Report Create a Report Using the Report Wizard Apply an AutoFormat to a Report Prepare a Report for Print	Working with Field Properties Add a Primary Key to a Table Insert, Delete, and Reorder Fields" Change a Field's Data Type Change the Field Size Adding a Caption Create a List of Values for a Field Creating Relational Databases Understanding Table Relationships Creating Relationships Between Tables Enforcing Referential Integrity Printing and Deleting Table Relationships Overview Relationship Types More on Queries Create Query Joins Relate Data Within a Table Set Query Properties Create a Calculated Field Enhancing Forms Design a Form Layout Improve the Appearance of a Form Add a Command Button to a Form Create a Subform Customizing Reports Organize Report Information Format the Report Set Report Control Properties Control Report Pagination Summarize Report Information Integrate Data With Other Applications Import Data into Access Export Data Analyze Access Data in Excel Export Data to a Text File Merge Access Data with a Word Document	Database Management Compact and Repair a Database Backing up Your Database Editing Database Properties Writing Advanced Queries Create Unmatched and Duplicate Queries Group and Summarize Records Using Criteria Summarize Data Using a Crosstab Query Create a PivotTable and a PivotChart Simplifying Tasks with Macros Create a Macro Attach a Macro Restrict Records Using a Condition Validate Data Using a Macro Automate Data Entry Using a Macro Making Effective Use of Forms Display a Calendar on a Form Organize Information with Tab Pages Making Reports More Effective Include a Chart in a Report Print Data in Columns Cancel Printing of a Blank Report Create a Report Snapshot Maintaining an Access Database Link Tables to External Data Sources Determine Object Dependencies Document a Database Analyze the Performance of a Database

Microsoft Access Certification

Microsoft certifications demonstrate your computing skills and help advance your career prospects in a competitive job market. Microsoft Certified Application Specialist certifications are primarily for office workers who use Microsoft Office programs as a vital part of their job functions.

• Microsoft Access 2007 - Beginner
• Microsoft Access 2007 - Intermediate
• Microsoft Access 2007 - Advanced
• Microsoft Access 2007 - MCAS