Enable Technology

ACCESS CHADDERTON TRAINING COURSES 

ACCESS TRAINING COURSES CHADDERTON




About Enable Technology Chadderton Access Training Courses

We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each course participant will be issued with training Access resources which they can continue to use after the training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Enable Technology training courses are delivered as instructor led courses. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to modify the Access syllabus to match your teams training 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 over twenty years continuous technical training experience. Our clients include: South Staffordshire Water PLC, University of Birmingham, Queen's Medical Centre Nottingham, Birmingham City Council, Countrywide Homes Limited, Boots UK Limited, EDF Energy PLC and Barclays Bank PLC.




Microsoft Access

  • 2 day course
  • Location: Chadderton
  • Telephone on 01952 938014
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Macros on Forms
    Database Wellness
    Creating and Using Reports
    Getting to Know Access 
    Aggregation Queries
    Setting Table Relationships
    Working With Records
    Adding Transactional Records
    Creating and Using Macros
    An Introduction to VBA
    Navigation Pane Protection
    Sorting and Filtering
    Creating a Relational Database
    Calculations in Queries
    Formatting Tables
    Action Queries
    Parameter Queries
    Designing a Lookup Database
    Importing and Exporting Records
    Adding Records to a Table
    Creating Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Chadderton
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Understanding Modules
    Using Debugging Tools
    Understanding Control-of-Flow Structures
    Considering Variable Scope and Lifetime Together
    Working with the ADODB Recordset Object
    Working with Boolean Expressions
    Setting Breakpoints
    Organizing Code and Procedures
    Working with Inline Error Handling
    Understanding Classes and Objects
    Understanding Objects
    Understanding Recordset Cursor Properties - Optional
    Creating a Standard Module
    Using Visual Basic Help
    Understanding the Order of Events
    Specifying a Recordset Cursor Type
    Declaring Variables
    Working with Methods

  • See Training Course Details...



Email us about this courses



Other Chadderton Enable Technology Training Courses

Excel Power Pivot Chadderton Training Courses
Oracle SQL - Chadderton SQL Training Courses
Data Warehouse - Chadderton SQL Training Courses
JQuery Mobile Chadderton Training Courses
Report Builder - Chadderton SQL Server Reporting Services Training Courses
JavaScript Chadderton Training Courses