Enable Technology

ACCESS BARRY TRAINING COURSES 

ACCESS TRAINING COURSES BARRY




About Enable Technology Barry Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Professionals. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

We provide instructor led training coupled with hands on training. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a training location in Barry. We are happy to modify the Access syllabus to match your teams training requirements.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are National Power PLC, Total Telecommunications Limited, Lloyds TSB Bank PLC, Halfords Group PLC, University of Birmingham, Norfolk Police Constabulary, Norwich Union PLC and Royal & Sun Alliance Group PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Barry
  • 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 ...
  • Setting Break Expressions
    Debugging Code
    Understanding Collections
    Working with the Code Editor
    Setting Breakpoints
    Using the With Statement
    Using the For Each...Next Structure
    Understanding Error Handling
    Why Program in Access?
    Using Input Boxes
    Working with Methods
    Handling Errors
    Working with Boolean Expressions
    Using the Object Browser
    Using the CacheSize Property - Optional
    Declaring and Creating Object Variables
    Using Intrinsic Functions
    Working with Properties
    Understanding Procedures

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Barry
  • 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 ...
  • DIY Forms
    Navigation Pane Protection
    Calculations in Queries
    Creating a Relational Database
    Modifying Forms
    Action Queries
    Setting Table Relationships
    Multi Table Queries
    Creating a Lookup Database
    An Introduction to VBA
    Database Wellness
    Relational Database Design
    Sorting and Filtering
    Getting to Know Access 
    Database Security
    Creating and Using Forms
    Parameter Queries
    Using a Navigation Form
    Importing and Exporting Records
    Working With Records
    Macro Techniques

  • See Training Course Details...



Email us about this courses



Other Barry Enable Technology Training Courses

Excel 365 Advanced Barry Training Courses
SSAS Tabular - Barry SQL Server Analysis Services Training Courses
Power BI - Barry Microsoft Power BI Training Courses
Data Warehouse Barry Training Courses
PL/SQL - Barry SQL Training Courses
Power Query Barry Training Courses