Enable Technology

ACCESS BRISTOL TRAINING COURSES 

ACCESS TRAINING COURSES BRISTOL




About Enable Technology Bristol Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Another way we could deliver the Access course is at a local socially distanced training site. Every Access course can be modified to meet your bespoke requirements.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: National Power PLC, Birmingham City University, Wolverhampton City Council, Birmingham Heartlands Hospital, South Staffordshire Water PLC, Nationwide Building Society Limited, Dollond & Aitchison Limited and Countrywide Homes Limited.




Microsoft Access

  • 2 day course
  • Location: Bristol
  • Telephone on 01952 938014
  • 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 ...
  • An Introduction to VBA
    Importing and Exporting Records
    Database Security
    Action Queries
    Setting Table Relationships
    Multi Table Queries
    Calculations in Queries
    Getting to Know Access 
    Creating and Using Macros
    Creating a Relational Database
    Sorting and Filtering
    Modifying Forms
    Modifying Table Structures
    Navigation Pane Protection
    Data Validation
    DIY Forms
    Using a Navigation Form
    Aggregation Queries
    Creating and Using Reports
    Relational Database Design
    Macros on Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bristol
  • Telephone on 01952 938014
  • 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 Data Types
    Using the CacheSize Property - Optional
    Understanding the Form Object
    Considering Variable Scope and Lifetime Together
    Working with Procedures and Functions
    Working with Variable Scope
    Working with Variable Lifetime
    Understanding Constants
    Using the Immediate Window to Call Procedures
    Writing an Error-Handling Routine
    Setting Break Expressions
    Stepping through Code
    Guidelines for use of Branching Structures
    Declaring Variables
    Using Visual Basic Help
    Understanding Error Handling
    Using Intrinsic Functions
    Using the Object Browser
    Navigating the Access Object Hierarchy
    Naming Procedures
    Working with the Code Editor

  • See Training Course Details...



Email us about this courses



Other Bristol Enable Technology Training Courses

SSAS Tabular Bristol Training Courses
JavaScript Bristol Training Courses
Power Query Bristol Training Courses
Excel 365 Intermediate Bristol Training Courses
Oracle SQL Bristol Training Courses
Data Warehouse - Bristol SQL Training Courses