Enable Technology

ACCESS CWMBRAN TRAINING COURSES 

ACCESS TRAINING COURSES CWMBRAN




About Enable Technology Cwmbran Access Training Courses

Enable Technology offer short intensive skills based Access training courses. All Enable Technology tutors are Microsoft certified experts. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Courses are instructor led and groups sizes small. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a Access course at an alternative training site in Cwmbran. The Access syllabus can be modified to accommodate your specific training needs.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Wolverhampton City Council, Unipart Group, West Bromwich Building Society, TalkTalk Direct Limited, Carillion PLC, Fujistu PLC, Keele University and Boots UK Limited.




Microsoft Access

  • 2 day course
  • Location: Cwmbran
  • 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 ...
  • Navigation Pane Protection
    Calculations in Queries
    Creating and Using Reports
    Relational Database Design
    Querying Techniques
    Aggregation Queries
    Macro Techniques
    Formatting Tables
    Multi Table Queries
    Sorting and Filtering
    An Introduction to VBA
    Modifying Table Structures
    Modifying Forms
    Creating a Relational Database
    Parameter Queries
    Setting Table Relationships
    Creating and Using Forms
    Adding Transactional Records
    Action Queries
    Creating Queries
    Importing and Exporting Records

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Cwmbran
  • 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 ...
  • Understanding Classes and Objects
    Working with Recordsets
    Working with the ADODB Recordset Object
    Using the Do...Loop Structure
    Working with Methods
    Using the With Statement
    Setting Breakpoints
    Working with the Code Editor
    Understanding Procedures
    Working with Procedures and Functions
    Using Visual Basic Help
    Using Debugging Tools
    Understanding the Order of Events
    Setting Break Expressions
    Understanding Constants
    Working with Properties
    Working with Inline Error Handling
    Using Break Mode during Run Mode
    Locking Records for Updating

  • See Training Course Details...



Email us about this courses



Other Cwmbran Enable Technology Training Courses

SQL - Cwmbran SQL Training Courses
SSAS Tabular - Cwmbran SQL Server Analysis Services Training Courses
VBA Cwmbran Training Courses
SSAS Cwmbran Training Courses
TSQL Cwmbran Training Courses
Power Query Cwmbran Training Courses