Course content

Building search forms

• Creating an unbound form
• Using text boxes and combos
• Adding a command button
• Creating a form to display search results
• Changing form properties

Interactive text boxes and combos

• Changing control types
• Editing combo properties
• Creating inter-dependent controls
• Understanding control and form events
• Applying macro and Visual Basic commands to an event
• Hiding and showing a control

Using the Dlookup function

• Dlookup data from a table
• Dlookup data from a query

Forms within forms

• Using the form wizard
• Creating a subform using “drag and drop”
• Changing form and subform properties
• Creating a linked form

Simplifying form layouts

• Using a tab control
• Changing properties
• Inserting and deleting pages
• Page order

Database security

• User-level security overview
• Implementing user-level security
• Opening a secure database
• Creating a group
• Creating a user
• Setting permissions

Building front end navigation

• Using the switchboard manager
• Adding commands to a switchboard page
• Switchboard properties
• Customising the switchboard

Customising a database application

• Displaying the logged on user
• Displaying the switchboard page name
• Creating a custom menu and toolbar
• Startup settings
• Creating a splash screen