Enable Technology

ACCESS NEWCASTLE UNDER LYME TRAINING COURSES 

ACCESS TRAINING COURSES NEWCASTLE UNDER LYME




About Enable Technology Newcastle Under Lyme Access Training Courses

We offer intensive two and three days Access courses. 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. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a training location in Newcastle Under Lyme. We are happy to discuss customising the course content should you have particular Access training requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Aston University, Countrywide Homes Limited, Royal & Sun Alliance Group PLC, Yell Group PLC, Dollond & Aitchison Limited, West Bromwich Building Society, Cadbury PLC and Capita Group PLC.




Microsoft Access

  • 2 day course
  • Location: Newcastle Under Lyme
  • 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 ...
  • Importing and Exporting Records
    Modifying Forms
    Creating and Using Reports
    Understanding VBA
    Creating a Lookup Database
    Setting Table Relationships
    Creating and Using Macros
    Using a Navigation Form
    Navigation Pane Protection
    Calculations in Queries
    Adding Transactional Records
    Creating Queries
    Querying Techniques
    Working With Records
    Designing a Lookup Database
    Action Queries
    Modifying Table Structures
    Database Wellness
    Parameter Queries
    Aggregation Queries
    DIY Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Newcastle Under Lyme
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Handling Errors
    Considering Variable Scope and Lifetime Together
    Creating a Standard Module
    Working with the Code Editor
    Understanding Error Handling
    Setting Breakpoints
    Understanding Objects
    Working with Inline Error Handling
    Understanding Data Types
    Understanding Classes and Objects
    Working with Events
    Specifying a Recordset Cursor Location - Optional
    Understanding Collections
    Using Visual Basic Help
    Locking Records for Updating
    Using the With Statement
    Creating a Function Procedure
    Using the Select Case...End Select Structure
    Creating a Sub Procedure
    Declaring Variables

  • See Training Course Details...



Email us about this courses



Other Newcastle Under Lyme Enable Technology Training Courses

SSRS - Newcastle Under Lyme SQL Server Reporting Services Training Courses
SSAS Newcastle Under Lyme Training Courses
Report Builder Newcastle Under Lyme Training Courses
SSAS Tabular - Newcastle Under Lyme SQL Server Analysis Services Training Courses
Excel Power Pivot Newcastle Under Lyme Training Courses
JQuery Newcastle Under Lyme Training Courses