Enable Technology

ACCESS WREXHAM TRAINING COURSES 

ACCESS TRAINING COURSES WREXHAM




About Enable Technology Wrexham Access Training Courses

We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. All course participants are issued Access training manuals they can refer to after the course. 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.

Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. The Access course could also be scheduled at a socially distanced site near you in Wrexham. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Vodafone Group Services, Birmingham City Council, University of Birmingham, Shell UK Oil Products Ltd, Royal & Sun Alliance Group PLC, GKN PLC, Countrywide Homes Limited and Yell Group PLC.




Microsoft Access

  • 2 day course
  • Location: Wrexham
  • 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 ...
  • Understanding VBA
    Sorting and Filtering
    Creating and Using Forms
    Setting Table Relationships
    Macros on Forms
    Modifying Table Structures
    Modifying Forms
    Aggregation Queries
    Importing and Exporting Records
    Macro Techniques
    Adding Records to a Table
    Relational Database Design
    Creating a Relational Database
    An Introduction to VBA
    Parameter Queries
    Navigation Pane Protection
    Designing a Lookup Database
    Creating and Using Macros
    Querying Techniques
    Database Wellness
    Creating and Using Reports

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Wrexham
  • 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 ...
  • Understanding Control-of-Flow Structures
    Trapping Errors with the On Error Statement
    Why Program in Access?
    Creating a Sub Procedure
    Using the CacheSize Property - Optional
    Understanding Procedures
    Stepping through Code
    Using Visual Basic Help
    Using Expressions, Variables, and Intrinsic Functions
    Debugging Code
    Using Break Mode during Run Mode
    Considering Variable Scope and Lifetime Together
    Declaring and Creating Object Variables
    Understanding Data Types
    Setting Break Expressions
    Handling Errors
    Controlling Program Execution
    Understanding the DoCmd Object
    Specifying a Recordset Cursor Location - Optional

  • See Training Course Details...



Email us about this courses



Other Wrexham Enable Technology Training Courses

SSAS Tabular Wrexham Training Courses
Power Query - Wrexham Excel Training Courses
Power BI Wrexham Training Courses
Excel 365 Advanced - Wrexham Excel Training Courses
VBA Wrexham Training Courses
PL/SQL - Wrexham SQL Training Courses