185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151
Microsoft Access Level 3 2010
Microsoft Access Level 3 2010

Course Code: GL | Hours: 8

Our public class schedule has upgraded. Please contact us at (212) 684-5151 or Info@CareerCenters.com to inquire about private tutoring or corporate classes. To view the offerings for current versions, see the links below.

Microsoft Access Level 3 2010 Training Overview

This course is designed for individuals who wish to learn more advanced operations of the Microsoft Access.

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

  • restructure data into appropriate tables to ensure data dependency and minimize redundancy
  • write advanced queries to analyze and summarize data
  • create and revise Microsoft Office Access 2010 macros
  • customize reports by using various Microsoft Office Access 2010 features
  • maintain their databases using Microsoft Office Access 2010 tools

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Related Classes:

See Also:

Microsoft Access Training Outline - Level 3

Lesson 1: Structuring Existing Data

• Topic 1A: Restructure the Data in a Table
• Topic 1B: Create a Junction Table
• Topic 1C: Improve the Table Structure

Lesson 2: Writing Advanced Queries

• Topic 2A: Create SubQueries
• Topic 2B: Create Unmatched and Duplicate Queries
• Topic 2C: Group and Summarize Records Using Criteria
• Topic 2D: Summarize Data Using a Crosstab Query
• Topic 2E: Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros

• Topic 3A: Create a Macro
• Topic 3B: Attach a Macro
• Topic 3C: Restrict Records Using a Condition
• Topic 3D: Validate Data Using a Macro
• Topic 3E: Automate Data Entry Using a Macro

Lesson 4: Creating Effective Reports

• Topic 4A: Include a Chart in a Report
• Topic 4B: Print Data in Columns
• Topic 4C: Cancel Printing of a Blank Report
• Topic 4D: Publish Reports as PDF

Lesson 5: Maintaining an Access Database

• Topic 5A: Link Tables to External Data Sources
• Topic 5B: Manage a Database
• Topic 5C: Determine Object Dependency
• Topic 5D: Document a Database
• Topic 5E: Analyze the Performance of a Database