Enable Technology

ACCESS WARWICK TRAINING COURSES 

ACCESS TRAINING COURSES WARWICK




About Enable Technology Warwick Access Training Courses

We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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 Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a socially distanced venue near you in Warwick. We are happy to modify the Access syllabus to match your teams training requirements.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Unipart Group, Barclays Bank PLC, DHL Express, Yell Group PLC, South Staffordshire Water PLC, Norfolk Police Constabulary, Homeserve PLC and Countrywide Homes Limited.




Microsoft Access

  • 2 day course
  • Location: Warwick
  • 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 ...
  • Working With Records
    Data Validation
    Creating a Relational Database
    Adding Transactional Records
    DIY Forms
    Macro Techniques
    Relational Database Design
    Adding Records to a Table
    Multi Table Queries
    Parameter Queries
    Modifying Table Structures
    Creating Queries
    Navigation Pane Protection
    Modifying Forms
    Understanding VBA
    Macros on Forms
    Using a Navigation Form
    Creating a Lookup Database
    Querying Techniques
    Getting to Know Access 
    An Introduction to VBA

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Warwick
  • Telephone on 01952 938014
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Guidelines for use of Branching Structures
    Setting Break Expressions
    Writing an Error-Handling Routine
    Using the Select Case...End Select Structure
    Understanding Errors
    Why Program in Access?
    Controlling Program Execution
    Working with Variable Scope
    Setting Breakpoints
    Working with Methods
    Understanding Classes and Objects
    Using the Do...Loop Structure
    Using Expressions, Variables, and Intrinsic Functions
    Using Intrinsic Functions
    Understanding Control-of-Flow Structures
    Understanding the DoCmd Object
    Declaring Variables
    Working with Procedures and Functions
    Calling Procedures
    Understanding the Form Object

  • See Training Course Details...



Email us about this courses



Other Warwick Enable Technology Training Courses

VBA Warwick Training Courses
Power Query - Warwick Excel Training Courses
SSAS Tabular - Warwick SQL Server Analysis Services Training Courses
Excel 365 Basic Warwick Training Courses
SSRS Warwick Training Courses
Data Warehouse - Warwick SQL Training Courses