Custom Search
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Access 2003 Intermediate Level 2 2 Days
Provided by: Last Minute Training

Access 2003 Intermediate Level 2 2 Days

Access

 Last Minute Training
Training Provided by Last Minute Training This two-day course picks up where the Intermediate Level I leaves off. The objective is to become more comfortable with relating tables, as well as looking further at forms, reports and queries. This course is classroom style instruction: Instructor-led, hands-on training.
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:basic
Duration:1 days
Training Presented in:English

Access 2003 Intermediate Level 2 2 Days Seminar Schedule

Date   Location    
23rd Nov, 2009   North York, ON   [Register]
Access 2003 Intermediate Level 2 2 Days Tables & Database

Tables
Review of Referential Integrity
1 to 1 Relationships
Self-joins
Join Lines
Join Types
Multiple Field Primary Keys
Lookup Tables
Combo Boxes in Tables

Database Analysis
Analyze Tables
Analyze Performance
Documenter

Forms

Creating Pop Up Forms
(Dialog Boxes)
Border Styles
Setting Properties

Sub Form Totals
Create Formula in Datasheet Form
Add Formula to Main Form
Protecting Formulas

Bound Options Groups
Creating an Option Group
Modifying & Formatting

Bound List Boxes
Creating using the Wizard
Formatting the List Box
Switching to a Combo Box
From Combo Box to List Box

The Tab Control
Creating a Tab Control
Adding Fields & Formulas
Moving Control to Pages
Changing Page Order
Adding & Deleting Pages
Formatting Pages

Control Defaults
For Objects Already on Form
Setting Defaults Before Add Field
Format Template
Properties

Form Properties
Edits, Deletions, Additions
Data Entry
Caption
Shortcut Menu
Pictures
Grid X/ Y
Background Picture
Cycle

Page Breaks & Form Printing
Page Breaks
Page Headers/ Footers
White Background Printing

Continuous Forms
Adding and Aligning Fields
Adding Formulas
2 Line Labels
Continuous View
Format to Resemble Datasheet
Dividing Lines
Form Header/ Footer
Continuous vs. Datasheet

Reports

Multi-Column Reports
Sorting & Grouping
Grouping Tricks
Setting Up Columns
Adding Fields
Adding Column Headings

Review of Mail Merge
Quick Review of Word Merge

Letters in Access
Writing the Letter
Inserting the Fields
Formatting the Letters
Limitations

Sub Reports
Designing a Sub Report
Designing a Main Report

Graphs
Using the Chart Wizard
Arranging the Chart
Setting Summary Formulas
Formatting the Chart
Using MS Graph
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Access 2003 Intermediate Level 2 2 Days
Advertise With Us
Sell access 2003 training?
tcw11-gfc-v396M-11/06/09-21:57:08-()[A]-[A]-[A] -11:23:15