Microsoft Access Intermediate
Course Outline

PLANNING AND DESIGNING DATABASES
    Planning Steps
        Why Plan?
        Planning Questions
        Normalization
        Data Integrity
WORKING WITH TABLES AND RELATIONSHIPS 
    Creating and Customizing Tables 
        How To Create A New Blank Database 
        How To Create A New Table 
        How To Set Primary Key 
        How To Rearrange Fields 
        How To Add Field 
        How To Delete Field 
        How To Change Data Type 
    Get External Information 
        How To Import Table 
        How To Link Tables 
    Managing Relationships 
        How To Delete Table Relationship 
        How To Create Table Relationships
EXPLORING ADVANCED TABLE FEATURES 
    Discovering Fields Properties 
        How To Create A Database From Scratch 
        How To Create A New Table From Scratch 
        How To Set A Primary Key 
    Setting Table Fields Properties 
        How To Control Field Size 
        How To Customize Text Format 
        How To Customize Number And Currency Format 
        How To Customize Date/Time Format 
        How To Control Input Pattern Using Input Mask 
        How To Change The Display Of Field Name Using Caption 
        How To Specify A Default Value 
        How To Prompt Error Using Validation Rule 
        How To Customize An Error Message 
        How To Make A Field Compulsory 
        How To Index A Field 
        How To Create Lookup Values For A Field 
        How To Update Values In A Lookup List
OPTIMIZING DIFFERENT RELATIONSHIPS 
    Using Relationships Effectively 
        How To Create Referential Integrity Relationships 
        How To Cascade Updates Related Fields 
        How To Cascade Delete Related Records 
        How To Identify Object Dependencies 
        How To Modify The Dependent Objects 
    Discovering And Solving Complex Relationships 
        How To Create One-To-One Relationships 
        How To Solve Many-To-Many Relationships Problems
CREATING AND CUSTOMIZING QUERIES 
    Creating Select Queries 
        How To Create Queries Quickly 
    Controlling Queries Output 
        How To Open / Switch Query To Design View 
        How To Rearrange Fields 
        How To Delete A Field 
        How To Add A Field 
        How To Sort The Query Output 
        How To Filter The Query Output With Criteria 
        How To Set Multiple Criteria 
        How To Hide A Field