Enable Technology



About Enable Technology Aberystwyth Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every person attending a Access course will be provided with training materials and practice files to retain 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.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. If you prefer we can offer an offsite socially distanced training location in Aberystwyth. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Royal & Sun Alliance Group PLC, South Staffordshire Water PLC, Unipart Group, Keele University, National Power PLC, EDF Energy PLC, Fujistu PLC and Wolverhampton City Council.

Microsoft Access

  • 2 day course
  • Location: Aberystwyth
  • 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 ...
  • Importing and Exporting Records
    Adding Transactional Records
    Modifying Forms
    Creating a Relational Database
    An Introduction to VBA
    Creating Queries
    Database Security
    Macros on Forms
    Creating and Using Reports
    Calculations in Queries
    Modifying Table Structures
    Formatting Tables
    Setting Table Relationships
    Parameter Queries
    Designing a Lookup Database
    DIY Forms
    Aggregation Queries
    Sorting and Filtering
    Database Wellness
    Working With Records
    Creating and Using Forms

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Aberystwyth
  • 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 the Immediate Window to Call Procedures
    Working with Recordsets
    Trapping Errors with the On Error Statement
    Understanding Modules
    Working with Boolean Expressions
    Setting Break Expressions
    Considering Variable Scope and Lifetime Together
    Understanding Error Handling
    Controlling Program Execution
    Understanding the DoCmd Object
    Setting Breakpoints
    Understanding Expressions and Statements
    Understanding the Order of Events
    Using Intrinsic Functions
    Understanding Recordset Cursor Properties - Optional
    Using the Select Case...End Select Structure
    Using Expressions, Variables, and Intrinsic Functions
    Working with the ADODB Recordset Object
    Creating a Sub Procedure
    Working with Events

  • See Training Course Details...

Email us about this courses

Other Aberystwyth Enable Technology Training Courses

Power BI - Aberystwyth Microsoft Power BI Training Courses
DAX - Aberystwyth Excel Training Courses
SSIS Aberystwyth Training Courses
JQuery - Aberystwyth JavaScript Training Courses
Report Builder - Aberystwyth SQL Server Reporting Services Training Courses
VBA Aberystwyth Training Courses