ACCESS INTERMEDIATE 2000-2003
Sponsored links
Duration 2 Days
Course Objectives To ensure that participants can use Access queries effectively, use the full potential of forms, feel confident when customising reports, can include macros to simplify procedures and have an understanding of multi-user security options
Prerequisites Ideally delegates should have attended the Introduction to Access course or alternatively they should be very familiar with database concepts and have experience of creating tables, queries, forms and relating tables
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
Course Contents
• Relating Tables and Join Types (consolidation)
• Consolidation of common query usage
• Using Query Parameters
• Setting up and running Action Queries
• Archiving data
• Importing and Export Data
• Mailmerging with Word documents
• Working with Linked Tables
• Setting up Forms to include: calculated fields, drop down lists, checkboxes, and option groups
• Making efficient use of Format Alignment and Sizing options
• Understanding and using Form Object properties
• Using, Creating and Customising Sub-forms
• Customising Reports
• Introduction to creating and using Pages
• Introduction to Macros
• Conditional Macros
• Running macros from buttons and properties
• Setting up database for multi-users
This Training Course is taught in classrooms in the following locations:
Bournemouth
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
