Access 2007 - Level 2 Course Outline | Access 2007 Training In Baltimore | Access 2007 Courses in Baltimore | Access 2007 Learning in Baltimore | Microsoft Access 2007 Training In Baltimore | Microsoft Access 2007 Courses in Baltimore | Microsoft Access 2007 Learning in Baltimore | New Horizons Computer Learning Center of Baltimore | Computer Training in Baltimore, MD | Computer Training | Microsoft Solutions Provider | Microsoft Certified Gold Partner Learning Solutions | Microsoft Office 2007 Training | Computer Learning in Baltimore | Computer Learning in Maryland | Computer Training in Baltimore | Computer Training in Maryland | IT Training in Baltimore | IT Training in Maryland | IT Professional | Technology Specialist | Database Administrator | Database Developer | database end-user | database enduser | database end user

Home Business Solutions eLearning Room Rentals Resources About Us Careers Directions Contact Us

New Horizons Computer Learning Center
410-597-9722

Access 2007 - Level 2

Course Length: 1 Day

Overview:
In this course, students will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and also by performing database maintenance.

Prerequisites:
Access 2007 - Level 1

Course Objectives:
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 Access macros
Display data more effectively in a form
Customize reports by using various Access features, thus making them more effective
Maintain your database using tools provided by Access

Course Content

Lesson 1: Structuring Existing Data

Analyze Tables
Create a Junction Table
Improve Table Structure

Lesson 2: Writing Advanced Queries

Create Subqueries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart

Lesson 3: 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

Lesson 4: Making Effective Use of Forms

Display a Calendar on a Form
Organize Information with Tab Pages
Display a Summary of Data in a Form

Lesson 5: Making Reports More Effective

Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Create a Report Snapshot

Lesson 6: Maintaining an Access Database

Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com