New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

Access 2007 - Level 2 On-Site Training

This on-site training class is also available as Public Schedule Seminar.

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.

Course Description/Agenda


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. (Second Edition)

At Course Completion:
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.

Prerequisite(s) or equivalent knowledge:
Access 2007 - Level 1

Suggested Next Steps:
Access 2007 - Level 3

Other Related Classes:
Access 2007 New Features
Office 2007 New Features

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

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

 On-Site Training On-Site Training

Also Available As

 Seminar Seminar

  		Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!