Enable Technology

ACCESS MIDDLETON TRAINING COURSES 

ACCESS TRAINING COURSES MIDDLETON




About Enable Technology Middleton Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post 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.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a course at a local socially distanced venue in Middleton. The Access syllabus can be modified to accommodate your specific training needs.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Norfolk Police Constabulary, Nuclear Engineering Services, Carillion PLC, Shell UK Oil Products Ltd, Norwich Union PLC, Nationwide Building Society Limited, South Staffordshire Water PLC and Aston University.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Middleton
  • 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 ...
  • Using the Do...Loop Structure
    Understanding Expressions and Statements
    Setting Breakpoints
    Determining the Value of Expressions
    Using Visual Basic Help
    Using the Select Case...End Select Structure
    Understanding Errors
    Considering Variable Scope and Lifetime Together
    Declaring Variables
    Using Intrinsic Functions
    Using Expressions, Variables, and Intrinsic Functions
    Why Program in Access?
    Using Message Boxes
    Understanding Modules
    Understanding Constants
    Understanding VBA's Error Trapping Options
    Using the CacheSize Property - Optional
    Understanding the Form Object
    Using Input Boxes

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Middleton
  • 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 ...
  • Action Queries
    Creating a Lookup Database
    Getting to Know Access 
    DIY Forms
    Creating and Using Macros
    Macro Techniques
    Macros on Forms
    Database Security
    Modifying Forms
    Data Validation
    Modifying Table Structures
    Sorting and Filtering
    Creating and Using Forms
    Parameter Queries
    Calculations in Queries
    Designing a Lookup Database
    Creating and Using Reports
    Querying Techniques
    Multi Table Queries
    Navigation Pane Protection
    Understanding VBA

  • See Training Course Details...



Email us about this courses



Other Middleton Enable Technology Training Courses

Power Query Middleton Training Courses
Excel 365 Basic - Middleton Excel Training Courses
SSAS Tabular - Middleton SQL Server Analysis Services Training Courses
Excel Power Pivot - Middleton Excel Training Courses
VBA - Middleton Excel Training Courses
SSAS - Middleton SQL Server Analysis Services Training Courses