|
|
Microsoft Access
Introduction
Intermediate
Level 1
Intermediate
Level 2
Queries
Advanced
VBA Level
1
VBA Level
2
Version
2007 Upgrade
Register Now
View Course Outline PDF
(all Access Courses show in one PDF file)
|
|
Course Dates (9am to 4pm)
Course Prerequisites
Required:
Solid understanding of all Access Introduction & Intermediate Level I topics.
Course Description
This course
builds on the Level I Intermediate course. We look further at relating
tables (join types, 1-1 relationships, database analysis tools), more
about reports (sub-reports, multiple column reports, letters) and more
about forms (tab control, option groups, page breaks, sub-form
sub-totals, list boxes, synchronizing combo boxes, printing options).
Also covered are creating lookup tables and creating graphs. It is
essential that you take the Intermediate Level I course, before taking
this course.
Detailed List of Topics
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
Form Properties
Edits,
Deletions, Additions
Data
Entry
Caption
Shortcut Menu
Pictures
Grid
X/Y
Background Picture
Cycle
|
Control Defaults
For
Objects Already on Form
Setting
Defaults Before Add Field
Format
Template
Properties
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
|
|
