Access 97 - Intermediate


All our training courses can be tailored to suit your company's needs.
Take a look at all the features that set us apart 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  days

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