Access Advanced

Ian Fraser Consulting
Melbourne, Victoria, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' At the end of the course participants will be able to:

Understand Table Design in a practical context
Understand and apply Field Properties
Understand the major components of Form and Report Design
Design customised Forms and Reports
Create Calculated Fields within Queries
Create and use Action Queries
Create and use Multi-Table Queries
Create Switchboards and Startup Forms
Understand and use Auto lookup
Exchange data with other applications
Build Advanced Queries and increase Query performance
Create complex Reports, incorporating sub reports and calculated controls
Export data from Access in Excel
Course Topics

Project Overview

Objects
Tables
Forms
Reports
Queries
Customising Tables

Importing Tables
Using Link Table
Field Properties
Standard and Custom Formats
Format Properties for Number Formats
The Input Mask Property and Wizard
Indexes Window
Copying Tables
Relationships
Relationship Types
Foreign Keys
Relationships Window
Adding Tables
Creating a One to Many Relationship
Creating Complex Forms

Using Wizards to Create Forms
Main/Subforms
Creating a Linked Form
Form Design
Controls
The Toolbox
Lines and Rectangles
Labels
Text Boxes
Layering Controls
AutoFormat
Applied Form Design

Control Wizards
Creating a Combo box, Button and Option Groups
Additional Design Tools
The Field List
Tab Order
Property Sheets
Builders
Building Expressions using the Expression Builder
Naming Controls
Using Wizards to Create Reports

Grouping and Subtotalling in a Report
Creating Mailing Labels
Mail Merge using Microsoft Word
Report Design

Design View
Performing Calculations in Reports
Dates and Times
Combining Text Values
Page Numbers
Summary Calculations
Sorting and Grouping in a Report
Formatting a Report
Embedding Images
White Space
Applied Queries

Creating and Formatting Calculated Fields
Using Calculated fields in Combo Boxes
Creating Action, Make-Table, Append, Update, Delete and Multi-Table Queries
Database Consolidation

Using the Switchboard Manager
Creating a Switchboard Form
Creating a Startup Form
Main/Subforms
...''

Phone:(03) 9489 7989

School Address:

Ian Fraser Consulting
10 Wakanui Street
Northcote Victoria 3070
Australia



Jobs & Resumes: Melbourne
Houses & Roommates: Melbourne
Travel Agencies: Melbourne

Search other schools for Access Advanced training resources.

Adobe Acrobat
Adobe Dreamweaver
Adobe Photoshop
Adobe Illustrator
InDesign CS3
Access Introduction
Excel Introduction
Excel Advanced
Excel - Formulas and Functions
Excel - Managing Databases
Frontpage Introduction
Outlook
Powerpoint Introduction
Powerpoint Advanced
Project Advanced

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.