Enable Technology

ACCESS WEST BROMWICH TRAINING COURSES 

ACCESS TRAINING COURSES WEST BROMWICH




About Enable Technology West Bromwich Access Training Courses

We offer intensive two and three days Access courses. The tutor delivering the course will be a Microsoft certified expert. 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.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We also offer the option of scheduling of Access course at a venue near you in West Bromwich. We are happy to discuss customising the course content should you have particular Access training requirements.

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

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Norwich Union PLC, Loughborough University, Royal Air Force, Homeserve PLC, Cadbury PLC, Yell Group PLC, Wolverhampton City Council and West Bromwich Building Society.




Microsoft Access

  • 2 day course
  • Location: West Bromwich
  • Telephone on 01952 938014
  • 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 ...
  • Action Queries
    Creating and Using Macros
    Database Wellness
    Formatting Tables
    Importing and Exporting Records
    Understanding VBA
    Querying Techniques
    Getting to Know Access 
    Parameter Queries
    Database Security
    Using a Navigation Form
    Setting Table Relationships
    Designing a Lookup Database
    Adding Records to a Table
    Macros on Forms
    Modifying Forms
    Creating a Lookup Database
    Navigation Pane Protection
    Data Validation
    Working With Records
    Multi Table Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: West Bromwich
  • 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 ...
  • Working with the Application Object
    Using Break Mode during Run Mode
    Specifying a Recordset Cursor Type
    Writing an Error-Handling Routine
    Understanding Modules
    Using Debugging Tools
    Controlling Program Execution
    Understanding Error Handling
    Why Program in Access?
    Understanding Procedures
    Understanding Collections
    Working with Boolean Expressions
    Debugging Code
    Using the Select Case...End Select Structure
    Determining the Value of Expressions
    Creating a Standard Module
    Locking Records for Updating
    Using Input Boxes
    Understanding Expressions and Statements

  • See Training Course Details...



Email us about this courses



Other West Bromwich Enable Technology Training Courses

DAX West Bromwich Training Courses
Power BI - West Bromwich Microsoft Power BI Training Courses
Excel 365 Intermediate - West Bromwich Excel Training Courses
Oracle SQL West Bromwich Training Courses
JQuery Mobile - West Bromwich JavaScript Training Courses
JQuery West Bromwich Training Courses