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

Access 2003 - Level 2 On-Site Training

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

In this course, student will extend their knowledge into some of the more specialized and advanced capabilities.

Course Description/Agenda


Duration:
Instructor-led Classroom Learning - 2.00 Day(s)
Online Anytime - Self Paced
Mentored Learning - Flexible

Overview:
In this course, student will extend their knowledge into some of the more specialized and advanced capabilities.

Who Should Attend:
Access 2003: Level 2 is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft Access Database program. The Level 3 course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft MOS Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.

Prerequisite(s) or equivalent knowledge:
Access 2003 - Level 1
 
Outline:
Lesson 1: Structuring Existing Data
Import Data
Analyze Tables
Create a Junction Table
Improve Table Structure

Lesson 2: Writing Advanced Queries
Create Unmatched and Duplicates Queries
Group and Summarize Records Using the Criteria Field
Summarize Data with a Crosstab Query
Create a PivotTable and a PivotChart
Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros
Create a Macro
Attach a Macro to a Command Button
Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros
Require Data Entry with a Macro
Display a Message Box with a Macro
Automate Data Entry

Lesson 5: Making Forms more Effective
Change the Display of Data Conditionally
Display a Calendar on a Form
Organize Information with Tab Pages

Lesson 6: Making Reports More Effective
Cancel Printing of a Blank Report
Include a Chart in a Report
Arrange Data in Columns
Create a Report Snapshot

Lesson 7: Maintaining an Access Database
Link Tables to External Data Sources
Back Up a Database
Compact and Repair a Database
Protect a Database with a Password
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!