Enable Technology

ACCESS TORQUAY TRAINING COURSES 

ACCESS TRAINING COURSES TORQUAY




About Enable Technology Torquay Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. The Access course could also be scheduled at a socially distanced site near you in Torquay. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

Our teaching team have over twenty years continuous technical training experience. Some of our clients are EDF Energy PLC, Yell Group PLC, Birmingham City Council, Norwich Union PLC, Nationwide Building Society Limited, Countrywide Homes Limited, DHL Express and Norfolk Police Constabulary.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Torquay
  • Telephone on 01952 938014
  • 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 ...
  • Using the Do...Loop Structure
    Working with Boolean Expressions
    Handling Errors
    Locking Records for Updating
    Understanding Recordset Cursor Properties - Optional
    Declaring Variables
    Using Break Mode during Run Mode
    Working with Variable Lifetime
    Using Expressions, Variables, and Intrinsic Functions
    Working with Methods
    Using the With Statement
    Setting Break Expressions
    Understanding Constants
    Working with the Application Object
    Understanding the Development Environment
    Using the Immediate Window to Call Procedures
    Using the Object Browser
    Using Visual Basic Help

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Torquay
  • Telephone on 01952 938014
  • 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 ...
  • Action Queries
    DIY Forms
    Creating a Lookup Database
    Data Validation
    Designing a Lookup Database
    Macros on Forms
    Aggregation Queries
    Importing and Exporting Records
    Creating and Using Forms
    Creating and Using Macros
    Multi Table Queries
    Database Wellness
    Creating Queries
    Creating and Using Reports
    Modifying Forms
    Navigation Pane Protection
    Setting Table Relationships
    Understanding VBA
    Database Security
    Getting to Know Access 
    Querying Techniques

  • See Training Course Details...



Email us about this courses



Other Torquay Enable Technology Training Courses

Power Query - Torquay Excel Training Courses
Power BI Torquay Training Courses
VBA Torquay Training Courses
SSAS Torquay Training Courses
PL/SQL Torquay Training Courses
JavaScript - Torquay JavaScript Training Courses