Enable Technology

ACCESS WEST BROMWICH TRAINING COURSES 

ACCESS TRAINING COURSES WEST BROMWICH




About Enable Technology West Bromwich Access Training Courses

We offer intensive two and three days Access courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a course at a local socially distanced venue in West Bromwich. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

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 been providing IT training primarily in the Midlands for two decades. Some of our clients are EDF Energy PLC, Nationwide Building Society Limited, Birmingham City University, Capita Group PLC, Halfords Group PLC, Royal & Sun Alliance Group PLC, Keele University and DHL Express.




Microsoft Access

  • 2 day course
  • Location: West Bromwich
  • 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 Relational Database
    Database Wellness
    Creating and Using Forms
    Creating and Using Reports
    Multi Table Queries
    Action Queries
    Modifying Table Structures
    Formatting Tables
    Querying Techniques
    Working With Records
    Importing and Exporting Records
    Understanding VBA
    DIY Forms
    Adding Records to a Table
    Parameter Queries
    Getting to Know Access 
    An Introduction to VBA
    Calculations in Queries
    Navigation Pane Protection
    Adding Transactional Records
    Creating Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: West Bromwich
  • 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 Collections
    Understanding Recordset Cursor Properties - Optional
    Navigating the Access Object Hierarchy
    Controlling Program Execution
    Working with the Application Object
    Using the With Statement
    Creating a Sub Procedure
    Using Input Boxes
    Working with Variable Scope
    Working with Procedures and Functions
    Considering Variable Scope and Lifetime Together
    Using Intrinsic Constants
    Using the Object Browser
    Understanding Constants
    Naming Procedures
    Working with Variable Lifetime
    Working with Boolean Expressions
    Debugging Code
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Expressions and Statements

  • See Training Course Details...



Email us about this courses



Other West Bromwich Enable Technology Training Courses

JQuery Mobile - West Bromwich JavaScript Training Courses
PL/SQL West Bromwich Training Courses
SSRS - West Bromwich SQL Server Reporting Services Training Courses
SSAS Tabular West Bromwich Training Courses
Oracle SQL - West Bromwich SQL Training Courses
VBA West Bromwich Training Courses