Access Training....

This past Friday I received an email offering training for Microsoft Access 2003. I spoke to my manager and she had me enrolled in the training. The training consists of 2 full day courses brought into the HQ building by New Horizons Computer Learning Centers. I’m very excited by getting such an advantage with taking this course, because it will actually help me understand the project I am working on more in depth on how data is structured and pulled from existing tables. It will also help me with any future projects I will work with involving databases to give me an extensive background knowledge. Here is an outline of the topics covered in the Access Level I Course:

Lesson 1: An Overview of Microsoft Access

Relational Databases

The Access Environment

The Database Environment

Examine an Access Table

Lesson 2: Managing Data

Examine an Access Form

Add and Delete Records

Sort Records

Display Record Sets

Update Records

Run a Report

Lesson 3: Establishing Table Relationships

Identify Table Relationships

Identify Primary and Foreign Keys in the Relationships Window

Working with Subdatasheets

Lesson 4: Querying the Database

The Select Query

Add Criteria to a Query

Add a Calculated Field to a Query

Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms

Form Design Guidelines

Create AutoForms

Create a Form Using the Form Wizard

Modify the Design of a Form

Lesson 6: Producing Reports

Create an AutoReport

Create a Report by Using the Wizard

Examine a Report in Design View

Add a Calculated Field to a Report

Modify the Format Properties of a Control

AutoFormat a Report

Adjust the Width of a Report

Lesson 7: Planning a Database

Design a Relational Database

Identify Database Purpose

Review Existing Data

Determine Fields

Group Fields into Tables

Normalize the Data

Designate Primary and Foreign Keys

Lesson 8: Building the Structure of a Database

Create a New Database

Create a Table Using a Wizard

Create Tables in Design View

Create Relationships between Tables

Lesson 9: Controlling Data Entry

Restrict Data Entry with Field Properties

Create an Input Mask

Create a Lookup Field

Lesson 10: Finding and Joining Data

Find Data with Filters

Create Query Joins

Join Unrelated Tables

Relate Data Within a Table

Lesson 11: Creating Flexible Queries

Set Select Query Properties

Create Parameter Queries

Create Action Queries

Lesson 12: Improving Your Forms

Enhance the Appearance of a Form

Restrict Data Entry in Forms

Add Command Buttons

Create a Subform

Lesson 13: Customizing Your Reports

Organize Report Information

Set Report Control Properties

Control Report Pagination

Summarize Information

Add a Subreport to an Existing Report

Create Mailing Labels

Lesson 14: Expanding the Reach of Your Data

Publish Access Data as a Word Document

Analyze Access Data in Excel

Export Data to a Text File

Merge Access Data with a Word Document

The class course days are July 12^th and 13^th. After completing the Access Level I course, I am also enrolled in the Access Level II course. This course involves using complex querying techniques, macro creation, and maintenance involved with multiple database structures. The following is an outline for the Access Level II course which I will be taking August 2^nd and 3^rd:

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