Enable Technology

ACCESS BANGOR TRAINING COURSES 

ACCESS TRAINING COURSES BANGOR




About Enable Technology Bangor 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). We provide every candidate with Access training materials which they keep after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to discuss customising the course content should you have particular Access training 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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Vodafone Group Services, Capita Group PLC, Birmingham Heartlands Hospital, Carillion PLC, Dollond & Aitchison Limited, Keele University, Wolverhampton City Council and Shell UK Oil Products Ltd.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bangor
  • Telephone on 01952 938014
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Working with Boolean Expressions
    Considering Variable Scope and Lifetime Together
    Using the For...Next Structure
    Working with the ADODB Recordset Object
    Using Intrinsic Functions
    Using the Do...Loop Structure
    Understanding the Order of Events
    Determining the Value of Expressions
    Using the With Statement
    Debugging Code
    Using the If...End If Decision Structures
    Using the Immediate Window to Call Procedures
    Understanding VBA's Error Trapping Options
    Understanding Data Types
    Working with Variable Scope
    Writing an Error-Handling Routine
    Using the CacheSize Property - Optional
    Calling Procedures
    Working with Recordsets

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Bangor
  • 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 ...
  • Formatting Tables
    Action Queries
    Designing a Lookup Database
    Macros on Forms
    Macro Techniques
    Working With Records
    Database Wellness
    Creating Queries
    Adding Records to a Table
    Adding Transactional Records
    Creating a Relational Database
    Parameter Queries
    Using a Navigation Form
    Sorting and Filtering
    Getting to Know Access 
    An Introduction to VBA
    Modifying Forms
    Importing and Exporting Records
    Database Security
    Calculations in Queries
    Creating and Using Reports

  • See Training Course Details...



Email us about this courses



Other Bangor Enable Technology Training Courses

SSAS - Bangor SQL Server Analysis Services Training Courses
TSQL - Bangor SQL Training Courses
Excel 365 Advanced Bangor Training Courses
Report Builder - Bangor SQL Server Reporting Services Training Courses
Power BI - Bangor Microsoft Power BI Training Courses
Oracle SQL Bangor Training Courses