Enable Technology

ACCESS DUDLEY TRAINING COURSES 

ACCESS TRAINING COURSES DUDLEY




About Enable Technology Dudley Access Training Courses

We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Everyone attending a Access course receives learning resources which also serves as a reference source 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.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the Access course is at a local socially distanced training site. The Access syllabus can be adjusted and additional topics incorporated if helpful.

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

We have operated primarily in the West Midlands for twenty years. Our clients include: South Staffordshire Water PLC, Fujistu PLC, Total Telecommunications Limited, DHL Express, Yell Group PLC, Birmingham City University, Homeserve PLC and Birmingham Heartlands Hospital.




Microsoft Access

  • 2 day course
  • Location: Dudley
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • An Introduction to VBA
    Setting Table Relationships
    Querying Techniques
    Designing a Lookup Database
    Creating and Using Forms
    Macro Techniques
    Using a Navigation Form
    Getting to Know Access 
    Aggregation Queries
    Navigation Pane Protection
    Modifying Forms
    Macros on Forms
    Understanding VBA
    Database Wellness
    Importing and Exporting Records
    Creating and Using Macros
    Data Validation
    Formatting Tables
    DIY Forms
    Creating and Using Reports
    Adding Transactional Records

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Dudley
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Working with Properties
    Using the Immediate Window to Call Procedures
    Declaring Variables
    Stepping through Code
    Setting Break Expressions
    Determining the Value of Expressions
    Understanding Data Types
    Using Input Boxes
    Considering Variable Scope and Lifetime Together
    Understanding VBA's Error Trapping Options
    Using Intrinsic Constants
    Working with Boolean Expressions
    Understanding Collections
    Using the Do...Loop Structure
    Understanding Modules
    Creating a Function Procedure
    Using the CacheSize Property - Optional
    Using Intrinsic Functions
    Understanding Objects

  • See Training Course Details...



Email us about this courses



Other Dudley Enable Technology Training Courses

SSRS - Dudley SQL Server Reporting Services Training Courses
Power Query - Dudley Excel Training Courses
DAX - Dudley Excel Training Courses
Excel 365 Advanced - Dudley Excel Training Courses
TSQL - Dudley SQL Training Courses
Data Warehouse - Dudley SQL Training Courses