Enable Technology

ACCESS LEICESTERSHIRE TRAINING COURSES 

ACCESS TRAINING COURSES LEICESTERSHIRE




About Enable Technology Leicestershire Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in Leicestershire. We will work with you prior to the course to tailor the Access syllabus to match your 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. Our clients include: Loughborough University, EDF Energy PLC, Unipart Group, Fujistu PLC, Keele University, Queen's Medical Centre Nottingham, Aston University and Capita Group PLC.




Microsoft Access

  • 2 day course
  • Location: Leicestershire
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Designing a Lookup Database
    Modifying Table Structures
    Understanding VBA
    Creating and Using Forms
    Adding Transactional Records
    Calculations in Queries
    Creating and Using Macros
    Querying Techniques
    Creating Queries
    Getting to Know Access 
    An Introduction to VBA
    Working With Records
    Adding Records to a Table
    Creating and Using Reports
    Database Wellness
    Importing and Exporting Records
    Macro Techniques
    Modifying Forms
    Sorting and Filtering
    Parameter Queries
    Relational Database Design

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Leicestershire
  • Telephone on 01952 938014
  • 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 Expressions, Variables, and Intrinsic Functions
    Using Debugging Tools
    Working with Recordsets
    Understanding Collections
    Using Intrinsic Constants
    Guidelines for use of Branching Structures
    Why Program in Access?
    Understanding Procedures
    Controlling Program Execution
    Naming Procedures
    Working with Variable Lifetime
    Using Visual Basic Help
    Using Break Mode during Run Mode
    Working with Methods
    Writing an Error-Handling Routine
    Handling Errors
    Understanding the Development Environment
    Working with the Code Editor
    Setting Breakpoints

  • See Training Course Details...



Email us about this courses



Other Leicestershire Enable Technology Training Courses

Power BI Leicestershire Training Courses
DAX - Leicestershire Excel Training Courses
SQL Leicestershire Training Courses
JavaScript - Leicestershire JavaScript Training Courses
Power Query Leicestershire Training Courses
SSRS Leicestershire Training Courses