Enquiry Form

Duration: 1 Day

MICROSOFT ACCESS 2007 ADVANCED

Objectives

To enhance database designs by using the principles of table relationships. Delegates will learn how to perform more complex queries and create more efficient forms, reports and databases.

Designed for

Experienced users of Microsoft Access 2007.

MODULE 1: MANAGING RELATIONAL DATABASES

• Database Concepts
• Database Design
• Normalisation
• Normalisation With The Table Analyzer Wizard
• Database Integrity
• Types Of Relationship
• Creating The Links
• Join Types
• Referential Integrity
• Lookup Fields
• Subdatasheets

MODULE 2: CUSTOMISING FORMS

• List And Combo Boxes
• Altering The Control Properties
• Check Boxes, Option & Toggle Buttons
• Option Groups
• Command Buttons
• Calculated Fields
• Entering A Page Number Control
• Entering A Date And Time Control:
• Using A Form's Input Values
• Create A Form With Multiple Pages Or Tabs
• Creating A Form With More Than One Page (Screen)
• Tab Order
• Inserting An Unbound Object In Forms Or Reports
• Create A Bound Object Frame Control
• Image Control
• Background Pictures
• Autoformat

MODULE 3: ADVANCED FORMS

• Multiple Item Forms
• Split Forms
• Datasheet Forms
• Subforms

MODULE 4: OPTIMISING AND ADMINISTERING DATABASES

• Optimising Performance
• Optimising General Table Performance
• Achieving Optimal Performance With Linked Tables
• Optimising Multi-User Performance
• Query Performance
• The Performance Analyzer
• Enabling And Disabling Add-Ins
• Compacting Your Database
• The Database Documenter
• The Database Splitter
• Importing And Linking Tables
• The Linked Table Manager
• Protecting Databases

MODULE 5: MACROS

• Creating, Running, And Modifying Macros
• Attaching Macros To The Events Of Database Objects
• Creating Macros To Provide User Interaction
• Creating Macros That Require User Input Via Parameters
• Creating The Autokeys And Autoexec Macros
• Creating Macros For Data Transfer