Enable Technology

ACCESS RISCA TRAINING COURSES 

ACCESS TRAINING COURSES RISCA




About Enable Technology Risca Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Enable Technology training courses are delivered as instructor led courses. 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 training site. Every Access course can be modified to meet your bespoke 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.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Total Telecommunications Limited, Countrywide Homes Limited, Royal Air Force, Dollond & Aitchison Limited, Keele University, Aston University, Lloyds TSB Bank PLC and TalkTalk Direct Limited.




Microsoft Access

  • 2 day course
  • Location: Risca
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Creating a Lookup Database
    Database Wellness
    DIY Forms
    Modifying Table Structures
    Data Validation
    Getting to Know Access 
    Database Security
    An Introduction to VBA
    Working With Records
    Multi Table Queries
    Formatting Tables
    Aggregation Queries
    Importing and Exporting Records
    Parameter Queries
    Creating and Using Macros
    Calculations in Queries
    Creating and Using Reports
    Relational Database Design
    Using a Navigation Form
    Macros on Forms
    Querying Techniques

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Risca
  • 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
    Declaring Variables
    Working with Methods
    Understanding Collections
    Working with Recordsets
    Controlling Program Execution
    Understanding the Order of Events
    Understanding Errors
    Specifying a Recordset Cursor Type
    Why Program in Access?
    Setting Break Expressions
    Using the For Each...Next Structure
    Using Debugging Tools
    Using Visual Basic Help
    Understanding the Err Object
    Using Message Boxes
    Understanding Control-of-Flow Structures
    Setting Breakpoints
    Specifying a Recordset Cursor Location - Optional
    Working with the ADODB Recordset Object

  • See Training Course Details...



Email us about this courses



Other Risca Enable Technology Training Courses

Excel Power Pivot Risca Training Courses
Data Warehouse - Risca SQL Training Courses
JQuery - Risca JavaScript Training Courses
Excel 365 Intermediate - Risca Excel Training Courses
VBA Risca Training Courses
JQuery Mobile - Risca JavaScript Training Courses