Microsoft Access Advanced
Course Outline

CREATING AND CUSTOMIZING FORMS 
    Customizing Forms 
        How To Resize Control 
        How To Move Both Control And Label 
        How To Move Control And Label Separately 
        How To Delete A Field Control 
        How To Add A Field Control 
        How To Control Cursor With Tab Order 
        How To Change Control Properties 
        How To Change A Form Properties 
        How To Select Multiple Controls 
        How To Make Form Header/Footer Visible 
    Creating User Friendly And Powerful Controls On Form 
        How To Create A Form From Scratch 
        How To Create Form Header And Footer 
        How To Insert Label 
        How To Format Text Properties 
        How To Change Form Background Color 
        How To Apply Special Effects 
        How To Change Form Background Image 
        How To Add Text Box Field Control 
        How To Add Unbound Text Box Control 
        How To Rename A Control And Its Label
CREATING AND CUSTOMIZING REPORTS 
    Working With Report Sections 
        How To Create Report Using Wizard 
        How To Reorganize Labels And Controls In Sections 
        How To Insert Calculated Control 
        How To Change The Format For A Control 
    Customizing Report Sections 
        How To Create Report From Scratch 
        How To Insert Report Header And Footer Section 
        How To Insert Group Header And Footer Sections 
        How To Insert Controls And Labels Into Sections
CREATING ADVANCED QUERIES 
    Creating Advanced Queries 
        How To Create Multiple Related Tables Query 
        How To Use Formula And Calculated Fields 
        How To Change Field Name Display For Calculated Column 
        How To Change Field Name Display 
        How To Change Record Display Format 
        How To Concatenate Text Fields 
        How To Eliminate Field Names Confusion 
        How To Group And Summaries Records 
        How To Prompt Input In Parameter Query 
        How To Produce Crosstab Queries