Enable Technology

ACCESS OLDHAM TRAINING COURSES 

ACCESS TRAINING COURSES OLDHAM




About Enable Technology Oldham Access Training Courses

Enable Technology provides practical Access skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a socially distanced training location in Oldham. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Boots UK Limited, Barclays Bank PLC, Birmingham City University, Canadian High Commission, Carillion PLC, Royal Air Force, Fujistu PLC and Homeserve PLC.




Microsoft Access

  • 2 day course
  • Location: Oldham
  • 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 ...
  • DIY Forms
    Aggregation Queries
    Parameter Queries
    Adding Transactional Records
    Calculations in Queries
    Creating Queries
    Multi Table Queries
    Macros on Forms
    Creating and Using Reports
    Understanding VBA
    Macro Techniques
    Importing and Exporting Records
    Designing a Lookup Database
    Modifying Table Structures
    Relational Database Design
    Working With Records
    Data Validation
    Creating a Lookup Database
    Creating and Using Macros
    Setting Table Relationships
    Creating a Relational Database

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Oldham
  • 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 the Development Environment
    Using the Immediate Window to Call Procedures
    Working with the Code Editor
    Working with Boolean Expressions
    Using Input Boxes
    Controlling Program Execution
    Creating a Function Procedure
    Working with Variable Scope
    Understanding Error Handling
    Understanding the Err Object
    Determining the Value of Expressions
    Creating a Standard Module
    Working with the ADODB Recordset Object
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Recordset Cursor Properties - Optional
    Working with Properties
    Using Intrinsic Functions
    Working with Events
    Working with Methods

  • See Training Course Details...



Email us about this courses



Other Oldham Enable Technology Training Courses

SSIS Oldham Training Courses
JQuery Mobile Oldham Training Courses
Report Builder Oldham Training Courses
Data Warehouse - Oldham SQL Training Courses
Excel 365 Intermediate - Oldham Excel Training Courses
SSAS Oldham Training Courses