Microsoft Access Expert Topics
Course Outline


CREATING ACTION QUERIES 
    Running Action Queries
 
        How To Run Make Table Queries To Create New Tables 
        How To Run Append Queries To Add Records 
        How To Run Delete Queries To Remove Records 
        How To Run Update Queries To Change Records Content
CREATING ADVANCED FORMS 
    Creating & Customizing Effective Forms 
        How To Insert Function In Control 
        How To Insert Calculated Control 
        How To Insert Option Group Control 
        How To Insert Combo Box Control 
        How To Insert List Box Control 
        How To Insert Command Button 
        How To Use Windows XP Themes 
    Integrating Main And Subform 
        How To Create Subform 
        How To Create Main Form 
        How To Integrate Subform Into The Main Form 
        How To Hide Record Navigator Buttons For Subform 
        How To Hide Field Information In Subform 
        How To Change Subform Size
CREATING ADVANCED REPORTS 
        How To Change Group Properties 
        How To Change Section Properties 
        How To Insert Analytical Values To Sections 
        How To Insert Page Numbers 
    Creating Chart Report 
        How To Create Chart Report Using Wizard 
        How To Select Chart Type And Layout
AUTOMATING DATABASE WITH MACROS 
    Working With Macros 

        How To Create A Macro 
        How To Run Macro 
        How To Edit And Rename Macro 
        How To Group Macro 
        How To Insert Button To Run Macro 
        How To Filter Record Using Macro 
        How To Create Conditional Macro 
        How To Secure Database With Autoexec Macro

Optional WVSTO Content