Enable Technology

ACCESS PUDSEY TRAINING COURSES 

ACCESS TRAINING COURSES PUDSEY




About Enable Technology Pudsey Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a course at a local venue in Pudsey. We are happy to modify the Access syllabus to match your teams training requirements.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Birmingham Heartlands Hospital, Dollond & Aitchison Limited, Lloyds TSB Bank PLC, Yell Group PLC, Royal & Sun Alliance Group PLC, National Power PLC, Queen's Medical Centre Nottingham and Vodafone Group Services.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Pudsey
  • 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 ...
  • Creating a Standard Module
    Understanding Data Types
    Understanding Collections
    Working with the ADODB Recordset Object
    Specifying a Recordset Cursor Location - Optional
    Using the Immediate Window to Call Procedures
    Declaring Variables
    Using Message Boxes
    Working with Variable Scope
    Using the Object Browser
    Understanding Error Handling
    Using the With Statement
    Naming Procedures
    Using Expressions, Variables, and Intrinsic Functions
    Understanding the Err Object
    Working with Events
    Working with Boolean Expressions
    Using Input Boxes

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Pudsey
  • 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 ...
  • Parameter Queries
    Importing and Exporting Records
    Database Security
    Understanding VBA
    Calculations in Queries
    Aggregation Queries
    Getting to Know Access 
    Creating a Lookup Database
    Modifying Forms
    Querying Techniques
    Sorting and Filtering
    Setting Table Relationships
    Database Wellness
    Working With Records
    Adding Transactional Records
    Creating and Using Reports
    Data Validation
    Adding Records to a Table
    Action Queries
    Macros on Forms
    An Introduction to VBA

  • See Training Course Details...



Email us about this courses



Other Pudsey Enable Technology Training Courses

Power Query Pudsey Training Courses
Power BI Pudsey Training Courses
JavaScript - Pudsey JavaScript Training Courses
Excel 365 Intermediate Pudsey Training Courses
Excel 365 Advanced - Pudsey Excel Training Courses
Excel Power Pivot Pudsey Training Courses