Enable Technology

ACCESS WIDNES TRAINING COURSES 

ACCESS TRAINING COURSES WIDNES




About Enable Technology Widnes Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source 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 specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We can also deliver the Access course at a socially distanced local training venue in Widnes. Every Access course can be modified to meet your bespoke requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Royal Air Force, Vodafone Group Services, West Bromwich Building Society, Fujistu PLC, Norfolk Police Constabulary, Barclays Bank PLC, Capita Group PLC and Carillion PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Widnes
  • 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 ...
  • Working with Variable Lifetime
    Understanding Recordset Cursor Properties - Optional
    Using Input Boxes
    Why Program in Access?
    Understanding the DoCmd Object
    Writing an Error-Handling Routine
    Using the For Each...Next Structure
    Working with the ADODB Recordset Object
    Understanding the Form Object
    Using Intrinsic Functions
    Using the CacheSize Property - Optional
    Navigating the Access Object Hierarchy
    Specifying a Recordset Cursor Location - Optional
    Using Break Mode during Run Mode
    Understanding Modules
    Considering Variable Scope and Lifetime Together
    Using the Immediate Window to Call Procedures
    Debugging Code
    Determining the Value of Expressions

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Widnes
  • Telephone on 01952 938014
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • DIY Forms
    Creating a Lookup Database
    Adding Records to a Table
    Querying Techniques
    Importing and Exporting Records
    Designing a Lookup Database
    An Introduction to VBA
    Calculations in Queries
    Creating and Using Forms
    Creating and Using Macros
    Modifying Forms
    Working With Records
    Database Security
    Parameter Queries
    Creating and Using Reports
    Setting Table Relationships
    Macros on Forms
    Getting to Know Access 
    Data Validation
    Aggregation Queries
    Relational Database Design

  • See Training Course Details...



Email us about this courses



Other Widnes Enable Technology Training Courses

Excel 365 Advanced Widnes Training Courses
JQuery - Widnes JavaScript Training Courses
SSIS Widnes Training Courses
DAX - Widnes Excel Training Courses
SSAS Widnes Training Courses
TSQL Widnes Training Courses