Enable Technology

ACCESS ABERTILLERY TRAINING COURSES 

ACCESS TRAINING COURSES ABERTILLERY




About Enable Technology Abertillery Access Training Courses

We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All course participants are issued Access training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Enable Technology training courses are delivered as instructor led courses. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a Access course at an alternative training site in Abertillery. We will work with you prior to the course to tailor the Access syllabus to match your 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 team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are TalkTalk Direct Limited, Canadian High Commission, Birmingham City Council, Lloyds TSB Bank PLC, Birmingham City University, Yell Group PLC, Unipart Group and Queen's Medical Centre Nottingham.




Microsoft Access

  • 2 day course
  • Location: Abertillery
  • 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 ...
  • Aggregation Queries
    Working With Records
    Understanding VBA
    Database Wellness
    Getting to Know Access 
    Database Security
    Adding Records to a Table
    Importing and Exporting Records
    Creating a Lookup Database
    Navigation Pane Protection
    Creating a Relational Database
    DIY Forms
    Macros on Forms
    Creating and Using Macros
    Sorting and Filtering
    Creating and Using Forms
    Parameter Queries
    Macro Techniques
    Using a Navigation Form
    Action Queries
    Creating Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Abertillery
  • 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 Debugging Tools
    Using the Do...Loop Structure
    Using the Object Browser
    Calling Procedures
    Guidelines for use of Branching Structures
    Understanding the Form Object
    Using Expressions, Variables, and Intrinsic Functions
    Specifying a Recordset Cursor Location - Optional
    Controlling Program Execution
    Understanding Procedures
    Working with Variable Lifetime
    Working with the Application Object
    Using Message Boxes
    Understanding Data Types
    Considering Variable Scope and Lifetime Together
    Locking Records for Updating
    Understanding Recordset Cursor Properties - Optional
    Why Program in Access?
    Working with Events
    Debugging Code
    Setting Breakpoints

  • See Training Course Details...



Email us about this courses



Other Abertillery Enable Technology Training Courses

Data Warehouse - Abertillery SQL Training Courses
JQuery Mobile Abertillery Training Courses
Oracle SQL Abertillery Training Courses
SSRS Abertillery Training Courses
VBA Abertillery Training Courses
PL/SQL - Abertillery SQL Training Courses