Enable Technology

ACCESS CHORLEY TRAINING COURSES 

ACCESS TRAINING COURSES CHORLEY




About Enable Technology Chorley Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a course at a local socially distanced venue in Chorley. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are DHL Express, Yell Group PLC, West Bromwich Building Society, Wolverhampton City Council, Queen's Medical Centre Nottingham, Nationwide Building Society Limited, Barclays Bank PLC and Nuclear Engineering Services.




Microsoft Access

  • 2 day course
  • Location: Chorley
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Macros on Forms
    Using a Navigation Form
    Creating and Using Macros
    Creating Queries
    Creating a Relational Database
    Getting to Know Access 
    Designing a Lookup Database
    Setting Table Relationships
    Relational Database Design
    Multi Table Queries
    Sorting and Filtering
    Data Validation
    Aggregation Queries
    Navigation Pane Protection
    Querying Techniques
    Action Queries
    Macro Techniques
    Calculations in Queries
    Creating and Using Forms
    Creating a Lookup Database
    DIY Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Chorley
  • 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
    Using Input Boxes
    Calling Procedures
    Understanding Control-of-Flow Structures
    Using Intrinsic Constants
    Understanding the Err Object
    Working with Variable Lifetime
    Writing an Error-Handling Routine
    Using the For...Next Structure
    Creating a Standard Module
    Trapping Errors with the On Error Statement
    Introduction to Programming in Access
    Understanding the Order of Events
    Specifying a Recordset Cursor Location - Optional
    Creating a Sub Procedure
    Working with Methods
    Handling Errors
    Declaring and Creating Object Variables

  • See Training Course Details...



Email us about this courses



Other Chorley Enable Technology Training Courses

Power BI - Chorley Microsoft Power BI Training Courses
TSQL - Chorley SQL Training Courses
PL/SQL - Chorley SQL Training Courses
SSIS Chorley Training Courses
Data Warehouse Chorley Training Courses
Report Builder - Chorley SQL Server Reporting Services Training Courses