Enable Technology

ACCESS LLANRUMNEY TRAINING COURSES 

ACCESS TRAINING COURSES LLANRUMNEY




About Enable Technology Llanrumney Access Training Courses

Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to post training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can bring the equipment necessary to deliver Access courses at your site. We are also more than happy to organise a local course at a socially distanced training location in Llanrumney. We are happy to discuss customising the course content should you have particular Access 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.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Birmingham City University, Norfolk Police Constabulary, Canadian High Commission, Royal & Sun Alliance Group PLC, Carillion PLC, Nuclear Engineering Services, Cadbury PLC and Nationwide Building Society Limited.




Microsoft Access

  • 2 day course
  • Location: Llanrumney
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Navigation Pane Protection
    Creating a Lookup Database
    Data Validation
    Calculations in Queries
    Understanding VBA
    Creating and Using Macros
    An Introduction to VBA
    Database Security
    Creating and Using Reports
    Designing a Lookup Database
    Setting Table Relationships
    Adding Transactional Records
    Database Wellness
    Getting to Know Access 
    Querying Techniques
    Macros on Forms
    Sorting and Filtering
    Formatting Tables
    Parameter Queries
    Aggregation Queries
    Using a Navigation Form

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Llanrumney
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Using the For...Next Structure
    Using Expressions, Variables, and Intrinsic Functions
    Using the Object Browser
    Specifying a Recordset Cursor Location - Optional
    Using the If...End If Decision Structures
    Understanding Constants
    Handling Errors
    Understanding the Order of Events
    Creating a Standard Module
    Using the For Each...Next Structure
    Using the Select Case...End Select Structure
    Working with the Code Editor
    Understanding Objects
    Using Break Mode during Run Mode
    Using the Do...Loop Structure
    Working with Methods
    Controlling Program Execution
    Understanding Recordset Cursor Properties - Optional
    Understanding Classes and Objects

  • See Training Course Details...



Email us about this courses



Other Llanrumney Enable Technology Training Courses

Excel 365 Advanced Llanrumney Training Courses
SSIS Llanrumney Training Courses
SSAS Tabular Llanrumney Training Courses
TSQL Llanrumney Training Courses
Power Query Llanrumney Training Courses
Report Builder Llanrumney Training Courses