Enable Technology

ACCESS BOOTLE TRAINING COURSES 

ACCESS TRAINING COURSES BOOTLE




About Enable Technology Bootle Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued Access training manuals they can refer to after the course. 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. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite training location in Bootle. We are happy to discuss customising the course content should you have particular Access training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time 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. Our clients include: Unipart Group, Homeserve PLC, Royal Air Force, West Bromwich Building Society, Shell UK Oil Products Ltd, Nuclear Engineering Services, Halfords Group PLC and Loughborough University.




Microsoft Access

  • 2 day course
  • Location: Bootle
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Setting Table Relationships
    Calculations in Queries
    Macro Techniques
    DIY Forms
    Modifying Forms
    Formatting Tables
    Creating and Using Forms
    Creating a Relational Database
    Sorting and Filtering
    Working With Records
    Creating a Lookup Database
    Database Wellness
    An Introduction to VBA
    Modifying Table Structures
    Parameter Queries
    Adding Records to a Table
    Getting to Know Access 
    Aggregation Queries
    Using a Navigation Form
    Adding Transactional Records
    Database Security

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bootle
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Understanding Expressions and Statements
    Understanding Control-of-Flow Structures
    Using the For Each...Next Structure
    Using the Immediate Window to Call Procedures
    Working with Boolean Expressions
    Writing an Error-Handling Routine
    Understanding the DoCmd Object
    Working with Methods
    Understanding the Form Object
    Controlling Program Execution
    Working with the ADODB Recordset Object
    Setting Breakpoints
    Working with Procedures and Functions
    Creating a Function Procedure
    Debugging Code
    Using Break Mode during Run Mode
    Working with the Application Object
    Using the If...End If Decision Structures
    Understanding Recordset Cursor Properties - Optional

  • See Training Course Details...



Email us about this courses



Other Bootle Enable Technology Training Courses

Excel 365 Advanced - Bootle Excel Training Courses
SSIS Bootle Training Courses
SSAS - Bootle SQL Server Analysis Services Training Courses
Power Query Bootle Training Courses
Power BI - Bootle Microsoft Power BI Training Courses
Excel 365 Intermediate Bootle Training Courses