ACCESS TRAINING COURSES SALISBURY
About Enable Technology Salisbury Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). 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.
Access courses are taught by a Microsoft Certified Solutions Expert. We can set up a training lab at your premises and deliver Access courses onsite at your site. If you prefer we can offer an offsite training location in Salisbury. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Canadian High Commission, South Staffordshire Water PLC, Countrywide Homes Limited, Norfolk Police Constabulary, Unipart Group, Fujistu PLC, Lloyds TSB Bank PLC and Total Telecommunications Limited.
Microsoft Access
- 2 day course
- Location: Salisbury
- 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 ... Data Validation
- See Training Course Details...
Sorting and Filtering
Macros on Forms
Designing a Lookup Database
Macro Techniques
Adding Transactional Records
Creating and Using Macros
Understanding VBA
Aggregation Queries
Calculations in Queries
Working With Records
Action Queries
Creating and Using Forms
Database Security
Modifying Forms
Multi Table Queries
Creating a Lookup Database
Importing and Exporting Records
Formatting Tables
Parameter Queries
An Introduction to VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Salisbury
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Working with Recordsets
- See Training Course Details...
Working with the ADODB Recordset Object
Determining the Value of Expressions
Debugging Code
Declaring Variables
Understanding Control-of-Flow Structures
Understanding the DoCmd Object
Understanding Recordset Cursor Properties - Optional
Navigating the Access Object Hierarchy
Considering Variable Scope and Lifetime Together
Introduction to Programming in Access
Setting Breakpoints
Using Message Boxes
Using the With Statement
Using Visual Basic Help
Stepping through Code
Understanding Collections
Why Program in Access?
Setting Break Expressions
Email us about this courses
Other Salisbury Enable Technology Training Courses
Oracle SQL Salisbury Training Courses
SQL Salisbury Training Courses
Excel 365 Basic - Salisbury Excel Training Courses
DAX Salisbury Training Courses
SSIS Salisbury Training Courses
Excel 365 Intermediate - Salisbury Excel Training Courses