Microsoft Access 2003 Level 3
| Duration: | 1 day |
| Prerequisite: | Microsoft Access 2003 Intermediate or equivalent experience |
| Course Materials: | Course manual with CD containing exercises, 144 pages |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class covers the Advanced concepts of Microsoft Access 2003 with managing database objects, creating macros and graphic reports, understanding modules, and maintaining databases. The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
Formatting Forms and Reports
Formatting Fonts with the Formatting Toolbar
Changing Text Alignment
Using AutoFormat
Changing Colors
Applying Special Effects
Using the Format Painter
Adding Pictures and Lines
Aligning Controls with One Another
Changing a Control's Formatting Properties
Working with Macros
Creating and Running a Macro
Editing a Macro
Working with Macro Groups
Assigning a Macro to an Event
Creating Conditional Expressions
Assigning a Macro to a Keystroke Combination
Macro Action Reference
Advanced Topics
Importing Information
Exporting Information
Importing Objects from Another Access Database
Linking Information from an External Source
Analyzing Records with Microsoft Excel
Exporting Records to Microsoft Word
Mail Merging Records to Microsoft Word
Using Hyperlink Fields
Using OLE Object Fields
Displaying Database Object Dependencies
Class Review
Creating an Access database from scratch