Enable Technology

ACCESS YOEVIL TRAINING COURSES 

ACCESS TRAINING COURSES YOEVIL




About Enable Technology Yoevil Access Training Courses

We are a company that provides short intensive Access training courses. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.

Enable Technology training courses are delivered as instructor led courses. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another option is we can organise a local training site in Yoevil. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions 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. Some of our clients are Royal & Sun Alliance Group PLC, Unipart Group, EDF Energy PLC, Barclays Bank PLC, Loughborough University, West Bromwich Building Society, University of Birmingham and Boots UK Limited.




Microsoft Access

  • 2 day course
  • Location: Yoevil
  • 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 ...
  • Calculations in Queries
    Database Security
    Using a Navigation Form
    Getting to Know Access 
    Querying Techniques
    Navigation Pane Protection
    Creating a Lookup Database
    Creating Queries
    Macros on Forms
    Macro Techniques
    Adding Transactional Records
    Relational Database Design
    Parameter Queries
    Formatting Tables
    Importing and Exporting Records
    Sorting and Filtering
    DIY Forms
    Creating and Using Forms
    Setting Table Relationships
    Creating and Using Reports
    An Introduction to VBA

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Yoevil
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Setting Break Expressions
    Understanding the Order of Events
    Declaring Variables
    Working with Recordsets
    Stepping through Code
    Creating a Standard Module
    Understanding Errors
    Understanding Constants
    Understanding Procedures
    Setting Breakpoints
    Working with the ADODB Recordset Object
    Understanding Data Types
    Understanding the DoCmd Object
    Using Visual Basic Help
    Using Break Mode during Run Mode
    Writing an Error-Handling Routine
    Understanding Collections
    Using Expressions, Variables, and Intrinsic Functions
    Working with Properties

  • See Training Course Details...



Email us about this courses



Other Yoevil Enable Technology Training Courses

JavaScript - Yoevil JavaScript Training Courses
Power Query - Yoevil Excel Training Courses
JQuery Mobile - Yoevil JavaScript Training Courses
Power BI - Yoevil Microsoft Power BI Training Courses
Excel Power Pivot Yoevil Training Courses
SSIS Yoevil Training Courses