Enable Technology

ACCESS CHORLEY TRAINING COURSES 

ACCESS TRAINING COURSES CHORLEY




About Enable Technology Chorley Access Training Courses

Enable Technology provides practical Access skills based technology training. All of our tutors are Microsoft Certified Professionals. 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.

We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Access courses at your site. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to modify the Access syllabus to match your teams training 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.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Carillion PLC, Capita Group PLC, Fujistu PLC, West Bromwich Building Society, Halfords Group PLC, Cadbury PLC, Total Telecommunications Limited and Queen's Medical Centre Nottingham.




Microsoft Access

  • 2 day course
  • Location: Chorley
  • 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 ...
  • Sorting and Filtering
    Relational Database Design
    Database Wellness
    Querying Techniques
    Using a Navigation Form
    Action Queries
    Adding Records to a Table
    Calculations in Queries
    Working With Records
    Modifying Forms
    Macros on Forms
    Modifying Table Structures
    Macro Techniques
    Data Validation
    DIY Forms
    Database Security
    Setting Table Relationships
    Designing a Lookup Database
    Creating Queries
    An Introduction to VBA
    Multi Table Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Chorley
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Using Break Mode during Run Mode
    Using the With Statement
    Introduction to Programming in Access
    Understanding Control-of-Flow Structures
    Handling Errors
    Controlling Program Execution
    Creating a Function Procedure
    Setting Break Expressions
    Understanding Classes and Objects
    Understanding Constants
    Working with the Code Editor
    Using Debugging Tools
    Specifying a Recordset Cursor Type
    Using Visual Basic Help
    Declaring and Creating Object Variables
    Using the CacheSize Property - Optional
    Guidelines for use of Branching Structures
    Using Input Boxes
    Debugging Code

  • See Training Course Details...



Email us about this courses



Other Chorley Enable Technology Training Courses

DAX - Chorley Excel Training Courses
PL/SQL - Chorley SQL Training Courses
Excel 365 Advanced Chorley Training Courses
JQuery Mobile Chorley Training Courses
SSAS - Chorley SQL Server Analysis Services Training Courses
Power Query Chorley Training Courses