Enable Technology

ACCESS ROCHDALE TRAINING COURSES 

ACCESS TRAINING COURSES ROCHDALE




About Enable Technology Rochdale Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Courses are instructor led and groups sizes small. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a course at a local socially distanced venue in Rochdale. We are happy to discuss customising the course content should you have particular Access training requirements.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Queen's Medical Centre Nottingham, Canadian High Commission, University of Birmingham, Shell UK Oil Products Ltd, Carillion PLC, Barclays Bank PLC, Capita Group PLC and Birmingham City Council.




Microsoft Access

  • 2 day course
  • Location: Rochdale
  • 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 and Using Reports
    Designing a Lookup Database
    Parameter Queries
    Sorting and Filtering
    Creating and Using Forms
    DIY Forms
    Creating a Relational Database
    Understanding VBA
    Calculations in Queries
    Creating Queries
    Macro Techniques
    Using a Navigation Form
    Adding Records to a Table
    Navigation Pane Protection
    Formatting Tables
    Importing and Exporting Records
    Multi Table Queries
    Database Wellness
    Setting Table Relationships
    Working With Records
    Modifying Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Rochdale
  • 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 ...
  • Guidelines for use of Branching Structures
    Creating a Function Procedure
    Understanding the DoCmd Object
    Declaring and Creating Object Variables
    Using Visual Basic Help
    Understanding Control-of-Flow Structures
    Setting Breakpoints
    Calling Procedures
    Working with Inline Error Handling
    Working with Procedures and Functions
    Using Intrinsic Functions
    Using Debugging Tools
    Working with the ADODB Recordset Object
    Using the CacheSize Property - Optional
    Using Expressions, Variables, and Intrinsic Functions
    Understanding the Err Object
    Determining the Value of Expressions
    Working with Recordsets
    Organizing Code and Procedures
    Working with the Application Object

  • See Training Course Details...



Email us about this courses



Other Rochdale Enable Technology Training Courses

SSAS Tabular Rochdale Training Courses
JavaScript - Rochdale JavaScript Training Courses
Excel 365 Intermediate Rochdale Training Courses
JQuery Mobile Rochdale Training Courses
Excel 365 Basic Rochdale Training Courses
Report Builder - Rochdale SQL Server Reporting Services Training Courses