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 12th and 13th. 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 2nd and 3rd:
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