ACCESS TRAINING COURSES UK
Microsoft Access
- 2 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Adding Records to a Table
- See Training Course Details...
Designing a Lookup Database
Navigation Pane Protection
Multi Table Queries
Sorting and Filtering
Action Queries
Setting Table Relationships
Macros on Forms
Creating Queries
Working With Records
Relational Database Design
Data Validation
Calculations in Queries
DIY Forms
Formatting Tables
An Introduction to VBA
Adding Transactional Records
Creating and Using Reports
Parameter Queries
Modifying Forms
Creating a Relational Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Uk
- Telephone on 01952 305730
- 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 ... Setting Break Expressions
- See Training Course Details...
Declaring and Creating Object Variables
Using the Immediate Window to Call Procedures
Understanding VBA's Error Trapping Options
Determining the Value of Expressions
Creating a Function Procedure
Understanding Classes and Objects
Using the CacheSize Property - Optional
Understanding Errors
Locking Records for Updating
Using Input Boxes
Understanding the Err Object
Working with Methods
Creating a Sub Procedure
Understanding Control-of-Flow Structures
Email us about this courses
Other Uk Enable Technology Training Courses
SSAS 2008 Uk Training Courses
Excel Power Pivot Uk Training Courses
Power Graphics - Uk Data Analytics Training Courses
JQuery Mobile - Uk JavaScript Training Courses
HTML Uk Training Courses
HTML Uk Training Courses