Category: Databases

Cost: $300

Course Summary:

New Version! This course covers the basic functions and features of Access. An introduction to database concepts and the Access environment and Help systems, learn how to design and create databases. Work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Learn to create queries, forms, and reports.

Prerequisite: Intro to Windows or equivalent.

Next Course of AACTTion: Access - Part II (Save 10% when registering for both)

Course Topics: Access - Part I

Microsoft Access 2010 - Part One

CLASS DATES

MS Access Part I - Course Topics

Getting Started

• Database concepts
• Exploring the Access environment
• Getting help

 

Databases and Tables

• Planning and designing databases
• Exploring tables
• Creating tables

 

Fields and Records

• Changing the design of a table
• Finding and editing records
• Organizing records

 

Data Entry Rules

• Setting field properties
• Working with input masks
• Setting validation rules

 

Basic Queries

• Creating and using queries
• Modifying query results and queries
• Performing operations in queries

 

Using Forms

• Creating forms
• Using Design view
• Sorting and filtering records

 

Working with Reports

• Creating reports
• Modifying and printing reports

Back to Course Top

Back to Top of Page

 

MS Access Part II - Course Topics

Relational Databases

• Database normalization
• Table relationships
• Referential integrity

 

Related Tables

• Creating lookup fields
• Modifying lookup fields
• Subdatasheets

 

Complex Queries

• Joining tables in queries
• Using calculated fields
• Summarizing and grouping values

 

Advanced Form Design

• Adding unbound controls
• Adding Graphics
• Adding calculated values
• Adding combo boxes
• Advanced form types

 

Reports and Printing

• Customized headers and footers
• Calculated values
• Printing
• Labels

 

Charts

• Charts in forms
• Charts in reports

 

PivotTables and PivotCharts

• PivotTables
• Modifying PivotTables
• PivotCharts
• PivotTable forms

Back to Course Top

Back to Top of Page

 

MS Access Part III - Course Topics

Querying with SQL

• SQL and Access
• Writing SQL statements
• Attaching SQL queries to controls

 

Advanced queries

• Creating crosstab queries
• Creating parameter queries
• Using action queries

 

Macros

• Creating, running, and modifying macros
• Attaching macros to the events of database objects

 

Advanced macros

• Creating macros to provide user interaction
• Creating macros that require user input
• Creating the AutoKeys and AutoExec macros
• Creating macros for data transfer

 

Importing, exporting, and linking

• Importing objects
• Exporting objects
• Interacting with XML documents
• Linking Access objects
• Working with Windows SharePoint Services

 

Database management

• Optimizing resources
• Protecting databases
• Setting options and properties

 

Internet integration

• Hyperlink fields
• Working with Outlook 2007

 

Back to Course Top

Back to Top of Page

Access Part I

Access Part II

Access Part III

Category: Databases

Cost: $300

Course Summary:

New Version! Learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

Prerequisite: Access Part I or equivalent.

Next Course of AACTTion: Access - Part III (Save 15% when registering for all 3 parts)

Course Topics: Access - Part II

Microsoft Access 2010 - Part Two

CLASS DATES

Category: Databases

Cost: $310

Course Summary:

New Version! Learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data.

Prerequisite: Access Part II or equivalent.

Next Course of AACTTion: Any Course

Course Topics: Access - Part III

Microsoft Access 2010 - Part Three

CLASS DATES