Enable Technology

ACCESS HUYTON TRAINING COURSES 

ACCESS TRAINING COURSES HUYTON




About Enable Technology Huyton Access Training Courses

Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a training location in Huyton. All Access courses can be customised to meet your particular 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.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Capita Group PLC, Royal Air Force, Aston University, TalkTalk Direct Limited, Birmingham City University, Fujistu PLC, Cadbury PLC and Queen's Medical Centre Nottingham.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Huyton
  • 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 ...
  • Understanding the DoCmd Object
    Using the Select Case...End Select Structure
    Using Input Boxes
    Using the If...End If Decision Structures
    Working with Boolean Expressions
    Using Visual Basic Help
    Working with Variable Scope
    Using the For...Next Structure
    Declaring and Creating Object Variables
    Understanding Procedures
    Navigating the Access Object Hierarchy
    Organizing Code and Procedures
    Working with Inline Error Handling
    Setting Break Expressions
    Understanding VBA's Error Trapping Options
    Using Debugging Tools
    Understanding Data Types
    Guidelines for use of Branching Structures

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Huyton
  • 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 ...
  • Modifying Forms
    Aggregation Queries
    Navigation Pane Protection
    Designing a Lookup Database
    Multi Table Queries
    Parameter Queries
    Macros on Forms
    Creating a Relational Database
    Calculations in Queries
    Modifying Table Structures
    Creating and Using Macros
    Creating a Lookup Database
    Sorting and Filtering
    Database Wellness
    Getting to Know Access 
    Data Validation
    Querying Techniques
    DIY Forms
    Creating and Using Reports
    Working With Records
    Using a Navigation Form

  • See Training Course Details...



Email us about this courses



Other Huyton Enable Technology Training Courses

Power Query Huyton Training Courses
TSQL Huyton Training Courses
SSAS Huyton Training Courses
SSRS - Huyton SQL Server Reporting Services Training Courses
Oracle SQL - Huyton SQL Training Courses
Excel 365 Intermediate - Huyton Excel Training Courses