Access Introduction  
 
  • Overview of relational databases
  • Planning a database
  • Creating & editing tables
  • Working with tables
  • Data types
  • Queries - finding the information you want
  • Forms - designing forms for the end user
  • Reports - producing reports for successful presentation of information
  • Relationships
 
    Duration:
    2 or 3 days
  Access Intermediate  
 
  • Creating more flexible databases
  • Advanced queries
  • Advanced work with forms
  • Advanced work with reports
  • Relationships
  • Creating macros
  • Making more efficient databases
  • Integrating the many elements in Access
  • Maintenance of your database
 
    Duration:
    2 days
  Access Programming  
 
  • Overview of Access Visual Basic
  • Visual Basic vs macros
  • Understanding essential programming concepts
  • Variables
  • Control Structures
  • Operators
  • Arrays
  • Handling errors
  • Recordsets
 
    Duration:
    2 or 3 days