Home Page
82 Bankside
Bolton
BL5 2QH
Tel: 01204 36 37 38
Course Information
  • Word-processing
  • Spreadsheets
  • Presentations
  • Databases
  • Project
  • The Internet & E-mail
  • Course Details
    Access

  • Introduction
  • Intermediate
  • Advanced
  • Access Advanced

    Course Prerequisites:

    This course has been designed for experienced users of Microsoft Access.

    It is expected that users have attended the Access Introduction/Intermediate courses or are highly proficient with Access.

    Course content:

    Advanced Data connectivity
    Importing delimited data (tab or comma)
    Adjusting imported data
    Using imported data
    Splitting name fields into separate first & last name
    Indexing

    Enforcing Referential Integrity
    Linking fields
    Cascade updating fields
    Cascade delete records

    Functions in Access
    Choose, Switch

    Database Maintenance
    Database security
    Compacting a database
    Encrypting / Decrypting a database
    Setting Access Options
    Setting Permissions

    Creating and attaching custom menus

    Macros
    Using flow diagrams
    Grouping macros
    Creating re-usable objects
    Editing a macro

    Mail merge with Word

    Calculated fields in queries

    Calculations with dates
    Text handling in queries
    Left, Right & Mid functions
    Advanced forms
    Form with sub-form created manually
    Child & parent Fields
    Multiple page forms
    Combo box that looks up a value

    Advanced reports

    Manually adding sub-reports
    Charts on reports
    Unbound controls

    Macros

    Switchboards
    Start Up Options

    Security

    Group permissions
    Passwords

    Duration - 1 day

      Home | E-mail | Location Map | Booking Form
     
      Site maintained by chris@actraining.co.uk
      Last updated 1 January 2014, AcTraining