Microsoft Access

Course Outline
Microsoft Access (Advanced)

|   Home     |     Training     |     TNAs  |    Courseware    |   Course Outlines   |   About   |    Contact    |    Index    |
    Application:  Microsoft Access
Level:  Advanced
Duration:  1 Day
Target:  Existing users of Access who have experience of building databases and want to take their skills to a higher level.
Objectives:  This course is designed to give an insight into some of the more advanced features in Access. It will give
 participants a further understanding of database design principles, advanced forms, reports and query design,
 including using calculations.
1. Database design
    Theory of normal forms
    Naming conventions

2. Access performance issues
    Data validation
    Table level validation
    Relationships and referential integrity
    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

     4. Advanced queries
    Filtering query results
    Parameter queries
    Creating summary queries
    Formatting query output
    Query join types
    Self joins and aliases
    Cross joins

5. Access and the Internet
    Using hyperlinks
    Using hyperlinks in forms
    Exporting datasheet views to HTML
    Data access pages

6. Action queries
    What is an action query?
    Planning an action query
    Make table queries
    Append queries
    Delete queries
    Update queries

     7. Producing reports
    Applying sorting and grouping to reports
    Performing calculations on reports
    Adding a graphic to a report
    Using the sub-report control
    Modifying section properties
    Using the Chart Wizard

8. Database Management Tools
    Setting a database password
    Sharing a database
    Start-up options
    Splitting a database

9. Access Macros
    What is a Macro?
    Creating a Macro
    Running a Macro
    Using Macros with events
    Macro examples

Download a printable copy of this course outline as a PDF file [30KB].
  2006 Martin Green. All rights reserved. Contact: