Enable Technology

ACCESS SMETHWICK TRAINING COURSES 

ACCESS TRAINING COURSES SMETHWICK




About Enable Technology Smethwick Access Training Courses

Enable Technology offer short intensive skills based Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued Access training manuals they can refer to after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Access courses are taught by a Microsoft Certified Solutions Expert. We can bring the equipment necessary to deliver Access courses at your site. Another way we could deliver the Access course is at a local socially distanced training site. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

We have operated primarily in the West Midlands for twenty years. Our clients include: Unipart Group, Birmingham City University, Boots UK Limited, Total Telecommunications Limited, Norwich Union PLC, Queen's Medical Centre Nottingham, Capita Group PLC and DHL Express.




Microsoft Access

  • 2 day course
  • Location: Smethwick
  • 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 ...
  • Creating a Lookup Database
    Creating and Using Reports
    Database Security
    Getting to Know Access 
    Working With Records
    DIY Forms
    Aggregation Queries
    Macros on Forms
    Calculations in Queries
    Data Validation
    Navigation Pane Protection
    Importing and Exporting Records
    Adding Records to a Table
    Creating and Using Macros
    Setting Table Relationships
    Action Queries
    Querying Techniques
    Creating and Using Forms
    An Introduction to VBA
    Creating Queries
    Multi Table Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Smethwick
  • 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 ...
  • Determining the Value of Expressions
    Understanding Error Handling
    Working with Procedures and Functions
    Specifying a Recordset Cursor Type
    Controlling Program Execution
    Locking Records for Updating
    Using the Immediate Window to Call Procedures
    Working with Events
    Writing an Error-Handling Routine
    Guidelines for use of Branching Structures
    Working with the ADODB Recordset Object
    Setting Break Expressions
    Working with Recordsets
    Using the CacheSize Property - Optional
    Working with Properties
    Working with Inline Error Handling
    Creating a Sub Procedure
    Using Expressions, Variables, and Intrinsic Functions
    Creating a Function Procedure

  • See Training Course Details...



Email us about this courses



Other Smethwick Enable Technology Training Courses

SSIS - Smethwick SQL Server Integration Services Training Courses
SSAS Smethwick Training Courses
Excel 365 Basic Smethwick Training Courses
SSRS - Smethwick SQL Server Reporting Services Training Courses
PL/SQL Smethwick Training Courses
Power BI - Smethwick Microsoft Power BI Training Courses