side bar:  IT Training, computer training in Scotland, Edinburgh iTrain Scotland Logo:  Phone us on 07711 341 320. Superior computer training for microsoft word, excel, access, office 97, office 2000, office xp, macromedia dreamweaver, fireworks, web design side bar:  IT Training, computer training in Scotland, Edinburgh
Go Back to courses
   
Access 97: Advanced

Overview & Prerequisite

This course is designed for users of Access. This course is aimed at those people who will be designing the database.

Course content

Querying
Crosstabs

Parameters
Calculated
Totals
Action Queries
Make table
Append
Delete
Update

Multiple Table Queries
Joining tables
Types of joins
Relationships Vs Joins
AutoLookup Query


Relationships
Understanding relational databases
Types of relationships
1-1
1-Many
Many-Many
Bridging tables

Forms
Using expressions
Inherited filters
Subforms / subreports
Grouping and sorting data

 

Object Linking and embedding
Adding a picture / object
Editing objects
drag and drop database objects

Protecting data
Valadating data entry
Setting passwords
Hiding objects
Introduction to database sucurity

Creating and using macros
Creating
Editing
Running
Grouping
Conditional macros

Creating a database application
Using forms
Autostart-ups
Hiding windows options
Creating buttons

| home | why choose us | courses | contact us | site map |
2000-2003 iTrain Scotland - Site Last Updated: 9 December, 2003 1:41 PM - Website problems e-mail: Support