Enable Technology

ACCESS WIGAN TRAINING COURSES 

ACCESS TRAINING COURSES WIGAN




About Enable Technology Wigan Access Training Courses

Enable Technology specialise in succinct skills based Access training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

We provide instructor led training coupled with hands on training. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. If you prefer we can offer an offsite socially distanced training location in Wigan. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Carillion PLC, Norfolk Police Constabulary, Birmingham Heartlands Hospital, Fujistu PLC, Royal & Sun Alliance Group PLC, Capita Group PLC, Unipart Group and Lloyds TSB Bank PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Wigan
  • 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 ...
  • Navigating the Access Object Hierarchy
    Understanding Data Types
    Working with Inline Error Handling
    Understanding Classes and Objects
    Using Intrinsic Functions
    Using the Immediate Window to Call Procedures
    Organizing Code and Procedures
    Understanding Control-of-Flow Structures
    Using the Select Case...End Select Structure
    Understanding the DoCmd Object
    Debugging Code
    Using the If...End If Decision Structures
    Understanding Collections
    Using the For Each...Next Structure
    Understanding Expressions and Statements
    Setting Breakpoints
    Using Message Boxes
    Using Input Boxes
    Working with Variable Scope

  • See Training Course Details...


Microsoft Access

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

  • See Training Course Details...



Email us about this courses



Other Wigan Enable Technology Training Courses

DAX Wigan Training Courses
Excel Power Pivot Wigan Training Courses
Power Query - Wigan Excel Training Courses
Data Warehouse - Wigan SQL Training Courses
SSRS Wigan Training Courses
Excel 365 Advanced - Wigan Excel Training Courses