Access 2003 Level 4

DESCRIPTION
This course looks at setting databases up for other people to use. You will learn how to automate the flow of your database using a start up screen (or Switchboard), and learn how to use macros in Access. Please note that macros are not VBA.

PREREQUISITES
Must be a fairly confident Access user. You've created databases a few times and know about relating tables. You are familiar with the concepts of Levels 1-3 and would like to start automating your databases.


Multi User Databases

• Splitting the database into a front and back end
  
• Creating a security file so users have to log-in to the database
  

Working with macros (Not VBA)

• Understanding and Exploring Macros
  
• Using the Macro window Toolbar
  
• Creating New Macros
  
  • Open a form read only
    
  • Open a form for data entry only
    
  • Export a table to Excel
    
  • Send a report via Email
    
  • Copy table to another database
    
  • Print a Report
    
• Running a macro
  
• Stepping through a macro
  
• Modifying a macro
  
• Adding Conditions to Macros
  
• Using the Expression builder to create Conditions
  
• Running macros with conditions
  
• Attaching Macros to a Form
  
• Attaching Macros to a Report
  
• Filtering Records
  
• Commenting Macros
  
• Macro Names
  
• Printing Macro Definitions
  
• Viewing Macro Definitions
  

Working with Switchboards

• Creating a Start-up Screen (Switchboard) using the wizard
  
• Editing a Switchboard Item
  
• Setting the properties of the form so it stays on top
  
• Deleting a Switchboard
  

Pivottables & pivotcharts

• Creating
  
• Creating PivotTable Forms
  
• Creating PivotChart Forms