|
|
|
ms203-ver12.7-sg
Microsoft Office Access 2007 - Level 3 (1 day)
Description
Your training in and use of Microsoft Office Access2007 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft Office Access 2007.
You have worked with the various Access objects, such as tables, queries, forms, and reports.
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
Prerequisites• Microsoft Access 2007 - Level 1
• Microsoft Access 2007 - Level 2
Supplemental Instructor ResourcesInstructor class workshop files are available for download after purchasing this product.
Course OutlineLesson 1: Database Application Structures • Design the Application • Define the Database Configuration • Name Rules in Access
Lesson 2: Creating Advanced Objects • Use the AutoFill Query • Assign Field Properties • Use the Expression Builder • Enter Advanced Calculated Controls • Refer to Controls on Subforms • Use Advanced Properties
Lesson 3: Creating Dialog Boxes • Create Dialog Boxes • Specify Dialog Box Form Properties • Use the Option Group Control • Use the Command Button Control • Pass Form Values to Quote
Lesson 4: Creating Simple Macros • Understand the Macro • Understand Event Properties • Attach Macros to Events • Use the Macro Editor
Lesson 5: Creating Macro Groups • Understand the Advantages of a Macro Group • Use the Macro Editor and Groups
Lesson 6: Creating Conditional Macros • Understand the Use of Conditional Access Expressions • Work with the Macro Editor and Conditional Macros
Lesson 7: Creating Switchboards • Use the Switchboard Manager • Use the Switchboard Manager Interface
Lesson 8: System Wrap Up • Programming Tips • Testing Methodology • Complete the Final System Setup • Document the System • Lock the Database
|
|
|
|
| Students interested in this course book have also been interested in the following virtual digital books (vBooks). |
|
 |
|
|
|
|
|
|
