Enable Technology

ACCESS SOLIHULL TRAINING COURSES 

ACCESS TRAINING COURSES SOLIHULL




About Enable Technology Solihull Access Training Courses

We have a twenty year history of providing skills based Access industry training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a Access course will be provided with training materials and practice files to retain 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.

Courses are instructor led and groups sizes small. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. We are also more than happy to organise a local course at a training location in Solihull. We are happy to discuss customising the course content should you have particular Access training requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

We have operated primarily in the West Midlands for twenty years. Some of our clients are Shell UK Oil Products Ltd, Lloyds TSB Bank PLC, EDF Energy PLC, Dollond & Aitchison Limited, Birmingham City University, TalkTalk Direct Limited, Unipart Group and Carillion PLC.




Microsoft Access

  • 2 day course
  • Location: Solihull
  • 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 ...
  • Importing and Exporting Records
    Formatting Tables
    Sorting and Filtering
    Adding Records to a Table
    Creating a Lookup Database
    Setting Table Relationships
    Aggregation Queries
    Getting to Know Access 
    Querying Techniques
    Understanding VBA
    Macros on Forms
    Parameter Queries
    Creating and Using Forms
    Navigation Pane Protection
    Creating and Using Macros
    Data Validation
    Using a Navigation Form
    Action Queries
    Creating Queries
    An Introduction to VBA
    Modifying Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Solihull
  • 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 ...
  • Using the With Statement
    Setting Break Expressions
    Using Visual Basic Help
    Working with Boolean Expressions
    Using Intrinsic Functions
    Understanding the DoCmd Object
    Using Break Mode during Run Mode
    Using the For Each...Next Structure
    Working with Inline Error Handling
    Understanding Error Handling
    Understanding Control-of-Flow Structures
    Specifying a Recordset Cursor Location - Optional
    Understanding Expressions and Statements
    Using Message Boxes
    Declaring and Creating Object Variables
    Working with Variable Lifetime
    Debugging Code
    Understanding Constants
    Calling Procedures
    Understanding the Order of Events
    Using the Object Browser

  • See Training Course Details...



Email us about this courses



Other Solihull Enable Technology Training Courses

Excel 365 Basic Solihull Training Courses
SQL - Solihull SQL Training Courses
Oracle SQL - Solihull SQL Training Courses
Power Query Solihull Training Courses
Excel 365 Intermediate - Solihull Excel Training Courses
TSQL - Solihull SQL Training Courses