Enable Technology

ACCESS DENTON TRAINING COURSES 

ACCESS TRAINING COURSES DENTON




About Enable Technology Denton Access Training Courses

We offer intensive two and three days Access courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We also offer the option of scheduling of Access course at a socially distanced venue near you in Denton. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Canadian High Commission, Nuclear Engineering Services, Boots UK Limited, Wolverhampton City Council, Halfords Group PLC, Vodafone Group Services, Royal & Sun Alliance Group PLC and Total Telecommunications Limited.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Denton
  • 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 the Development Environment
    Understanding Expressions and Statements
    Naming Procedures
    Working with the ADODB Recordset Object
    Understanding Classes and Objects
    Determining the Value of Expressions
    Working with Procedures and Functions
    Using Message Boxes
    Working with Properties
    Locking Records for Updating
    Working with the Application Object
    Working with Variable Lifetime
    Understanding the Order of Events
    Understanding Objects
    Considering Variable Scope and Lifetime Together
    Understanding Data Types
    Creating a Standard Module
    Setting Break Expressions
    Using the Do...Loop Structure
    Specifying a Recordset Cursor Type

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Denton
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Formatting Tables
    Macro Techniques
    Database Security
    Creating and Using Macros
    Aggregation Queries
    Designing a Lookup Database
    Setting Table Relationships
    Creating a Relational Database
    Working With Records
    Importing and Exporting Records
    Modifying Table Structures
    An Introduction to VBA
    Data Validation
    Parameter Queries
    Multi Table Queries
    Creating a Lookup Database
    Relational Database Design
    Macros on Forms
    Database Wellness
    Adding Transactional Records
    Using a Navigation Form

  • See Training Course Details...



Email us about this courses



Other Denton Enable Technology Training Courses

Excel Power Pivot Denton Training Courses
JavaScript Denton Training Courses
SQL - Denton SQL Training Courses
VBA - Denton Excel Training Courses
Report Builder - Denton SQL Server Reporting Services Training Courses
Power BI Denton Training Courses