Access 3 2007

Download PDF

Next Dates:

No dates available yet

Length:

1 day

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 285

Target audience & Prerequisites:

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database. Basic and intermediate features of Access tables, relationships, queries, forms, and reports

Learning objectives:

You 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.

Course Outline:

Structuring Existing Data

Analyze Tables
Create a Junction Table
Improve the Table Structure

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

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

Making Effective Use of Forms

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

Making Reports More Effective

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

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

Remember that we build our schedule around your requests. Check out our Courses List, call us at (613) 235-6161 or email us at training@compuease.ca:

Calendar

Search

Course List