ACCESS TRAINING COURSES UK
Microsoft Access
- 2 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Action Queries
- See Training Course Details...
An Introduction to VBA
Macros on Forms
DIY Forms
Designing a Lookup Database
Creating a Relational Database
Creating and Using Macros
Data Validation
Sorting and Filtering
Adding Transactional Records
Creating and Using Forms
Formatting Tables
Importing and Exporting Records
Creating and Using Reports
Creating a Lookup Database
Modifying Forms
Macro Techniques
Creating Queries
Using a Navigation Form
Querying Techniques
Multi Table Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Stepping through Code
- See Training Course Details...
Using Expressions, Variables, and Intrinsic Functions
Using Break Mode during Run Mode
Understanding the Development Environment
Understanding Modules
Understanding Expressions and Statements
Using the If...End If Decision Structures
Using the CacheSize Property - Optional
Understanding Errors
Understanding Error Handling
Trapping Errors with the On Error Statement
Creating a Sub Procedure
Working with Procedures and Functions
Using Intrinsic Constants
Understanding Control-of-Flow Structures
Using Visual Basic Help
Using the For Each...Next Structure
Working with Properties
Introduction to Programming in Access
Creating a Function Procedure
Writing an Error-Handling Routine
Email us about this courses
Other Uk Enable Technology Training Courses
Power Graphics Uk Training Courses
Excel Advanced Uk Training Courses
Power BI Uk Training Courses
Oracle SQL Uk Training Courses
SSRS 2008 Uk Training Courses
Crystal 2013 Uk Training Courses