Enable Technology

ACCESS HARROGATE TRAINING COURSES 

ACCESS TRAINING COURSES HARROGATE




About Enable Technology Harrogate Access Training Courses

We have a twenty year history of providing skills based Access industry training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We will issue each Access training participant with learning resources which they can refer to post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology offers instructor led training taught by technology specialists. We are set up to deliver Access training courses onsite at your premises. We are also more than happy to organise a local course at a socially distanced training location in Harrogate. We are happy to discuss customising the course content should you have particular Access training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Halfords Group PLC, Royal Air Force, Yell Group PLC, Wolverhampton City Council, Boots UK Limited, Fujistu PLC, Shell UK Oil Products Ltd and Royal & Sun Alliance Group PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Harrogate
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Controlling Program Execution
    Using Message Boxes
    Debugging Code
    Introduction to Programming in Access
    Understanding Collections
    Working with Methods
    Working with Events
    Using Intrinsic Functions
    Using Debugging Tools
    Understanding Constants
    Stepping through Code
    Using the Immediate Window to Call Procedures
    Working with Inline Error Handling
    Working with the Code Editor
    Working with the Application Object
    Writing an Error-Handling Routine
    Using the For Each...Next Structure
    Organizing Code and Procedures
    Locking Records for Updating
    Specifying a Recordset Cursor Type
    Using the Do...Loop Structure

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Harrogate
  • Telephone on 01952 938014
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Database Wellness
    Aggregation Queries
    Adding Records to a Table
    Multi Table Queries
    Modifying Forms
    DIY Forms
    An Introduction to VBA
    Creating and Using Forms
    Parameter Queries
    Database Security
    Designing a Lookup Database
    Data Validation
    Understanding VBA
    Sorting and Filtering
    Creating a Lookup Database
    Working With Records
    Macro Techniques
    Importing and Exporting Records
    Setting Table Relationships
    Modifying Table Structures
    Creating and Using Reports

  • See Training Course Details...



Email us about this courses



Other Harrogate Enable Technology Training Courses

Power Query Harrogate Training Courses
VBA Harrogate Training Courses
Excel Power Pivot - Harrogate Excel Training Courses
SSIS - Harrogate SQL Server Integration Services Training Courses
TSQL - Harrogate SQL Training Courses
SQL Harrogate Training Courses