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

Access - Level 2 On-Site Training

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

In this course, students will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

Course Description/Agenda


Duration
Classroom Learning - 2 Day(s)
Online LIVE - 2 Sessions

Overview
Students will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

Who Should Attend
This 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.

Prerequisite(s) or equivalent knowledge
Access 2010 - Level 1

Suggested Next Steps
Access 2010 - Level 3

Outline
Lesson 1: Structuring Existing Data
Restructure the Data in a Table
Create a Junction Table
Improve the Table Structure
Lesson 2: Writing Advanced Queries
Create Subqueries
Create Unmatched and Duplicate Queries
Filter 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: Creating Effective Reports
Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Publish a Report as a PDF
Lesson 5: 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!