Enable Technology



Microsoft Access

  • 2 day course
  • Location: Hereford
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Creating and Using Macros
    Understanding VBA
    Relational Database Design
    Adding Records to a Table
    Sorting and Filtering
    Multi Table Queries
    Calculations in Queries
    Data Validation
    Setting Table Relationships
    Aggregation Queries
    Formatting Tables
    Parameter Queries
    Importing and Exporting Records
    Creating and Using Forms
    Adding Transactional Records
    Creating and Using Reports
    An Introduction to VBA
    Action Queries
    Using a Navigation Form
    DIY Forms
    Navigation Pane Protection

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Hereford
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Understanding Modules
    Using the Do...Loop Structure
    Using the For Each...Next Structure
    Using Break Mode during Run Mode
    Using the Select Case...End Select Structure
    Understanding Classes and Objects
    Working with Procedures and Functions
    Understanding the Form Object
    Considering Variable Scope and Lifetime Together
    Using the CacheSize Property - Optional
    Understanding the Order of Events
    Declaring Variables
    Using Message Boxes
    Understanding Error Handling
    Understanding Data Types
    Understanding Objects
    Using Intrinsic Functions
    Specifying a Recordset Cursor Type
    Stepping through Code

  • See Training Course Details...

Contact Us By Email         Telephone on 01952 305730

Other Hereford Enable Technology Training Courses

Mobile - Hereford Web Development Training Courses
SSRS 2008 - Hereford SQL Server Reporting Services Training Courses
SQL - Hereford SQL Training Courses
Microsoft Project Level 3 Hereford Training Courses
Excel Advanced Hereford Training Courses
Visio 2013 Hereford Training Courses

All Enable Technology Access Training Locations

Manchester Access Training
Stourbridge Access Courses
Rugby Access Courses
Derby Access Courses
Nottingham Access Training
Shropshire Access Training
Nuneaton Access Training
Birmingham Access Training
Wolverhampton Access Training
Sandwell Access Courses
Oxford Access Training
Lichfield Access Courses
Northhampton Access Training
Walsall Access Training
Leek Access Training
Crewe Access Courses
Staffordshire Access Courses
Chester Access Courses
Shrewsbury Access Courses
Bromsgrove Access Courses
Leicester Access Training
Liverpool Access Training
East Midlands Access Courses
Tamworth Access Courses
Cheltenham Access Courses
Worcester Access Courses
Solihull Access Courses
West Midlands Access Training
Stafford Access Training
Bridgnorth Access Courses
Burton on Trent Access Training
Cannock Access Training
Kidderminster Access Courses
Telford Access Training
Milton Keynes Access Training
Redditch Access Training
Hereford Access Courses
Dudley Access Training
Newcastle under Lyme Access Courses
West Bromwich Access Courses
Coventry Access Training
Stoke On Trent Access Courses
Leicestershire Access Training
Black Country Access Courses

Manchester, Stourbridge, Rugby, Derby, Nottingham, Shropshire, Nuneaton, Birmingham, Wolverhampton, Sandwell, Oxford, Lichfield, Northhampton, Walsall, Leek, Crewe, Staffordshire, Chester, Shrewsbury, Bromsgrove, Leicester, Liverpool, East Midlands, Tamworth, Cheltenham, Worcester, Solihull, West Midlands, Stafford, Bridgnorth, Burton On Trent, Cannock, Kidderminster, Telford, Milton Keynes, Redditch, Hereford, Dudley, Newcastle Under Lyme, West Bromwich, Coventry, Stoke On Trent, Leicestershire, Black Country