Queries

• Null vs blank fields
• Changing the join type
• Advanced calculations
• Using date functions in a query
• Creating a Crosstab query manually and using the wizard
• Applying criteria to Crosstab queries

Sub-forms and sub-reports

• Sub-forms in datasheet view
• Totalling data in a subform
• The Locked and Enabled property

Advanced Form Design

• The Tab Page control
• Inserting extra tabbed pages
• Formatting tab controls
• Changing the page index
• Adding pictures to a page tab
• Changing Tab Control properties
• ActiveX Controls
• Using the ActiveX Calendar control
• Creating navigation buttons
• Creating a 'Find' button
• Finding data using a combo box

Advanced Report Design

• Using parameter queries in reports
• Changing the Record Source
• Grouping data on text fields
• Grouping data on date/time fields
• Grouping data on multiple sections
• Adding graphics to a report

Custom Toolbars

• Creating a custom toolbar
• Creating a custom menu item
• Adding a command to a menu
• Docking a floating toolbar
• Linking a toolbar to a report
• Creating a shortcut menu
• Linking a custom shortcut menu to a form
• Add, remove and re-arrange buttons on a custom toolbar
• Changing a button image

Switchboards

• Creating a switchboard manually
• Adding buttons to a switchboard
• Setting the Start-Up Options
• The Switchboard Manager

Integrating with other applications

• Mail merging with Word
• Analysing data with Excel
• Creating Charts
• Using the Chart Wizard
• Resizing and moving a chart
• Exploring the components of a chart
• Applying a fill colour, pattern or texture
• Legends
• Changing the chart type
• Adding a chart to a report

Multi-user applications

• Exploring issues regarding multiple users
• Sharing data
• Splitting a database
• Locking files
• Editing shared data

Database Maintenance

• Compacting and repairing a database
• Database administration
• Adding a password to a database
• User level security
• Creating and joining a workgroup file
• Groups, users and permissions
• Logon procedures
• Adding users to a workgroup
• Creating additional workgroups
• Database object ownership
• Using the Security Wizard to add users and groups

Replication

• Why replicate a database?
• Creating a database replica
• Synchronisation
• Resolving conflicts between replica set users