Access for Developers

Access Developer

Parameter And Action Queries

• Creating Parameter Queries
• Creating Action Queries

Query Joins And Crosstab Queries

• Joining Tables
• Join Properties
• Crosstab Queries
• Editing Limitations In Datasheets

Using Advanced Form Techniques

• Organising Field Placement
• Using Functions To Control Data Entry
• Adding An Option Group To A Form
• Using A Form As The User Interface
• Creating A Form That Contains A Subform

Creating Macros To Automate Forms

• Macro Basics
• Attaching A Macro To A Command Button
• Revising A Macro
• Attaching Macros To Form Event

Macros For User Interaction And Automation

• Using A Macro To Provide User Interaction
• Using Macros To Automate Data Entry
• Autokeys And Autoexec Macros

Using Advanced Report Techniques

• Customizing Their Appearance And Functionality
• Mailing And Other Types Of Labels

Application Design Concepts

• Planning An Application
• Examining A Completed Application
• Developing A Distributed Application Design

Adding Command Buttons To Guide User Navigation

• Using One Form To Add Or Edit Records

Automating A Dialog-Box Form With A Macro Group

• Creating A Macro Group
• Customising An Unbound Form As A Dialog Box
• Documenting A Macro Group

Creating A Switchboard Form

• Using The Switchboard Manager
• Setting Database Startup Properties

Working With Custom Toolbars And Menus

• Using A Macro Group To Show And Hide A Toolbar
• Using Visual Basic To Show And Hide A Customised Form-View Toolbar
• Creating A Custom Menu Bar For A Form
• Startup Properties For Toolbars And Menus

Creating A Splash Screen Form

• Creating A Form As A Splash Screen
• Automating The Splash Screen Form
• Modifying Startup Properties To Display A Splash Screen Form
• Documenting The Application

Using Visual Basic Procedures

• Creating A Global Function
• Adding General Procedures In A Form Module
• Creating Event Procedures

Adding Security To An Application

• Security Overview
• Securing A Database By Using User-Level Security
• Documenting Database Security
• Securing A Database With A Database Password
• Distributing A Secured Application