|
|
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:
This course is not intended for beginners. An
Intermediate or better knowledge of
Access
(versions 97, 2000, 2002 XP, or 2003) is essential.
Course Description
Access version 2007 has significant changes in the design
aspect. This course is essential if you want to get back to developing
where you left off. Topics include: new, improved user interface,
templates, enhanced sorting and filtering, layout view, stacked and
tabular layouts, automatic calendar, rich text in memo fields, enhanced
quick create, improved datasheet view, total row in datasheets, field
templates, split forms, multivalued fields, attachment data type,
background color, navigation pane, embedded macros, improved help viewer
and more.
Detailed List of Topics
|
Database
Creating
New Database
Using
Templates
Converting Existing Databases to 2007
Converting 2007 to older versions
Compact
and Repair
General
New
Interface
The
Ribbon
Viewing
Objects
Grouping
Tables and Related Objects
Creating/Modifying Groups
Object
Dependencies
Improved
Help Viewer
Tables &
Queries
Creating
and Editing Tables
Alternate
Row Colour
Adding
Fields in Datasheet View
Field
Templates
MultiValue Fields
Attachment Data Type
Choosing
Dates with Calendar
Rich Text
in Memo Fields
Testing
Validation Rules
Navigating Records
Formatting Cells
Hiding &
Freezing Columns
Totals
Row
Sorting,
Finding & Search
Multiple
Field Indexes
New
Filtering Tools
Filter by
Form
Save
Filter as Query/Load Filter from Query
Creating/Editing Queries
|
Forms
New
Quick AutoForms/Auto SubForms
Layout View
Selecting Tools
Split Forms
Multiple Items
New
Form Wizard
Add
Logo
Add
Title
Conditional Formats
Reports
Report Wizard
New
Quick AutoReports
Layout View
Sorting and Grouping
Totals, Counts, etc.
Add
Logo
Add
Title
Conditional Formats
Import/Export
Import from Excel
Saved Imports
Link from Excel
Linked Table Manager
Export to Excel
Saved Exports
Export to Word
Mail Merge with Word
|
|
