Course Details

Microsoft Access course entails learning basics of database through areas like that of the following: 

Database design

    Theory of normal forms

    De-normalisation

    Naming conventions

2. Access performance issues

    Indexes

    Data validation

    Table level validation

    Relationships and referential integrity

    Relationships

    Field types

    Referential integrity options

    Join types

    Using Lookups for referential integrity

    Multi-table datasheet view

3. Building and modifying forms

    Using advanced forms features

    The form worksurface

    Creating a calculated control

    Adding a graphic to a form

    Multi-table forms

    Using the Subform control

    Switchboard forms