Enable Technology

ACCESS MERSEYSIDE TRAINING COURSES 

ACCESS TRAINING COURSES MERSEYSIDE




About Enable Technology Merseyside Access Training Courses

Enable Technology specialise in succinct skills based Access training. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of Access course at a socially distanced venue near you in Merseyside. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are GKN PLC, Barclays Bank PLC, Halfords Group PLC, Royal & Sun Alliance Group PLC, West Bromwich Building Society, Birmingham City Council, Canadian High Commission and Norwich Union PLC.




Microsoft Access

  • 2 day course
  • Location: Merseyside
  • 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 ...
  • Navigation Pane Protection
    Creating a Relational Database
    An Introduction to VBA
    Macro Techniques
    Formatting Tables
    Adding Transactional Records
    Adding Records to a Table
    Designing a Lookup Database
    Macros on Forms
    Getting to Know Access 
    Creating Queries
    Calculations in Queries
    DIY Forms
    Modifying Table Structures
    Querying Techniques
    Parameter Queries
    Aggregation Queries
    Using a Navigation Form
    Creating and Using Macros
    Database Security
    Creating a Lookup Database

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Merseyside
  • Telephone on 01952 938014
  • 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 Data Types
    Calling Procedures
    Understanding Collections
    Naming Procedures
    Introduction to Programming in Access
    Guidelines for use of Branching Structures
    Using the For Each...Next Structure
    Working with Procedures and Functions
    Using Expressions, Variables, and Intrinsic Functions
    Using the Immediate Window to Call Procedures
    Using the Select Case...End Select Structure
    Working with Boolean Expressions
    Understanding Errors
    Understanding Classes and Objects
    Understanding Expressions and Statements
    Working with the ADODB Recordset Object
    Using the CacheSize Property - Optional
    Writing an Error-Handling Routine
    Considering Variable Scope and Lifetime Together

  • See Training Course Details...



Email us about this courses



Other Merseyside Enable Technology Training Courses

SSIS Merseyside Training Courses
Data Warehouse Merseyside Training Courses
JavaScript - Merseyside JavaScript Training Courses
Excel 365 Advanced Merseyside Training Courses
SSRS Merseyside Training Courses
Excel Power Pivot Merseyside Training Courses