Enable Technology

ACCESS DENTON TRAINING COURSES 

ACCESS TRAINING COURSES DENTON




About Enable Technology Denton Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a course at a local socially distanced venue in Denton. The Access syllabus can be adjusted and additional topics incorporated if helpful.

We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Total Telecommunications Limited, Carillion PLC, Cadbury PLC, Dollond & Aitchison Limited, EDF Energy PLC, Royal & Sun Alliance Group PLC, Birmingham City University and Countrywide Homes Limited.




Microsoft Access

  • 2 day course
  • Location: Denton
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Setting Table Relationships
    Parameter Queries
    Adding Transactional Records
    Database Wellness
    Modifying Table Structures
    Aggregation Queries
    Getting to Know Access 
    Creating a Relational Database
    Creating Queries
    Macros on Forms
    Relational Database Design
    Using a Navigation Form
    Adding Records to a Table
    An Introduction to VBA
    Working With Records
    Data Validation
    Sorting and Filtering
    Understanding VBA
    Macro Techniques
    Action Queries
    Creating and Using Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Denton
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Specifying a Recordset Cursor Type
    Understanding the Order of Events
    Determining the Value of Expressions
    Declaring and Creating Object Variables
    Using the Select Case...End Select Structure
    Guidelines for use of Branching Structures
    Working with Inline Error Handling
    Creating a Standard Module
    Working with Variable Lifetime
    Working with Methods
    Understanding Error Handling
    Working with Properties
    Understanding Errors
    Debugging Code
    Understanding Expressions and Statements
    Declaring Variables
    Organizing Code and Procedures
    Using the Do...Loop Structure

  • See Training Course Details...



Email us about this courses



Other Denton Enable Technology Training Courses

Oracle SQL - Denton SQL Training Courses
Excel 365 Basic - Denton Excel Training Courses
SSAS Tabular - Denton SQL Server Analysis Services Training Courses
DAX Denton Training Courses
SQL - Denton SQL Training Courses
Power Query - Denton Excel Training Courses