Microsoft Access

Introduction

Intermediate

Advanced

 

Getting started

Database Concepts

Exploring the Access environment

 

Databases and tables

Planning and designing databases

Exploring tab les

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

Sorting and filtering records

 

Working with reports

Creating reports

Modifying and printing reports

 

 

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

Graphics

Adding calculated values

Adding combo boxes

Advanced form types

 

Reports and printing

Report formatting

Calculated values and subreports

Printing

Label printing

 

Charts

Charts in forms

Charts in reports

 

 

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 AutoKeys and AutoExec

macros

Creating macros for data transfer

 

Importing, exporting, and linking

objects

Importing objects

Exporting objects

Working with XML documents

Linking Access objects

Using hyperlink fields

 

Database management

Optimizing resources

Protecting databases

Setting options and properties

 

Computer Training of America, Inc.

Telephone: (413) 283-7740

Toll Free: (877) 283-7740

Fax: (413) 283-7730

Web Site: www.computertrainingofamerica.com