Enable Technology

ACCESS UK TRAINING COURSES 

ACCESS TRAINING COURSES UK




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • 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 ...
  • Creating a Function Procedure
    Understanding Error Handling
    Using the Object Browser
    Understanding the DoCmd Object
    Understanding the Order of Events
    Working with Methods
    Calling Procedures
    Understanding Objects
    Working with Variable Lifetime
    Creating a Sub Procedure
    Understanding Data Types
    Working with the Code Editor
    Declaring and Creating Object Variables
    Specifying a Recordset Cursor Location - Optional
    Debugging Code
    Considering Variable Scope and Lifetime Together
    Setting Break Expressions

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • 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 ...
  • Setting Table Relationships
    Macro Techniques
    Creating a Lookup Database
    Relational Database Design
    Modifying Table Structures
    Getting to Know Access 
    Navigation Pane Protection
    Creating and Using Forms
    Database Wellness
    Aggregation Queries
    Database Security
    Using a Navigation Form
    Importing and Exporting Records
    Formatting Tables
    Modifying Forms
    Creating Queries
    An Introduction to VBA
    Creating and Using Reports
    Calculations in Queries
    Sorting and Filtering
    DIY Forms

  • See Training Course Details...



Email us about this courses



Other Uk Enable Technology Training Courses

SSAS 2014 - Uk SQL Server Analysis Services Training Courses
Crystal 2013 - Uk Crystal Reports Training Courses
HTML - Uk Web Development Training Courses
Microsoft Project Level 2 - Uk Microsoft Project Training Courses
SSIS 2005 Uk Training Courses
Microsoft Project Level 3 - Uk Microsoft Project Training Courses