|
MICROSOFT ACCESS XP – Specialists
Course Aims:
Students will learn to develop an application and tie the objects together into a cohesive system. Participants will also learn to use advanced Form design and how to analyse data by creating complex queries. The course also looks at considerations of database administration and security.
Contents:
Planning Access Applications
System Analysis
The Database Design
System Updates
Advanced Queries
Calculations in Queries
Specifying Criteria in calculating totals
Cross Tab Queries
Action Queries
Advanced Forms
Form Controls
Form Buttons
Multi-Table Forms
Advanced Reports
Report Bands
Report Controls
Grouping Data
Adding Sub Reports
Using Functions in Reports
Graphing
Creating Graphs
Embedding Graphs
Object linking and embedding
Understanding OLE Objects
Embedding OLE Objects
Bound and Unbound Objects
Switchboards and Dialogue Boxes
Creating Pop-up Forms and Dialog Boxes
Creating a Switchboard
Custom Toolbars and Menus
Creating
Modifying
Attaching to Forms
Administration and Security
Security Overview
Networking
Record Locking
Assigning and Removing Permissions
Securing a database with a Password
Target Audience:
Individuals with an intermediate knowledge of database design who wish to build and administrate sophisticated database applications.
Assumed Knowledge:
Access XP Essentials and Access XP Specifics
Duration: 1 Day
printer friendly version
|
