All our training courses can be designed to suit your company's needs.
Take a look at all the different features that separate us from other Access 97 Intermediate training courses.
Objectives:This course provides Intermediate level of training.
Who should Attend:Delegates who have attended Access '97 Introduction course. Course objective is to improve upon Access Database Usage & Design.
Duration : 1 day
Course Content
| |
RELATIONAL DATABASES
|
 |
Related Tables |
|
Defining Relationships |
|
Queries with Related Tables
|
| |
ADVANCED QUERY TYPES
|
|
Summary Queries |
|
Functions in Queries |
|
Cross Tab Queries |
|
Update Queries |
|
Make Table Queries |
|
Parameter Queries |
|
Chained & Composite Queries
|
| |
CUSTOM REPORTS
|
|
Designing a Custom Report |
|
Derived Fields on Reports |
|
Summary Reports & Fields |
|
Graphics in Reports |
|
Sub Reports |
|
| |
CREATING CUSTOM FORMS
|
|
Designing Data Entry Forms |
|
Field Types & the Design Tool |
|
Adding Enhancements |
|
Assigning Field/Object Properties |
|
Using Data Entry Forms & Sub Forms |
|
Graphs in Forms & Reports
|
| |
DATABASE SECURITY
|
|
Security Aspects on Single User Systems |
|
Assigning Security
|
| |
INTRODUCTION TO MACROS |
|
|
