ACCESS TRAINING COURSES UK
Microsoft Access
- 2 day course
- Location: Uk
- Telephone on 01952 938014
- 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 ... Formatting Tables
- See Training Course Details...
Modifying Table Structures
Importing and Exporting Records
Action Queries
Creating and Using Reports
Getting to Know Access
Designing a Lookup Database
Aggregation Queries
Adding Transactional Records
Macros on Forms
Creating Queries
Multi Table Queries
Parameter Queries
Querying Techniques
Using a Navigation Form
Sorting and Filtering
Understanding VBA
Creating and Using Macros
Calculations in Queries
Modifying Forms
Relational Database Design
Microsoft Access Programming Using VBA
- 3 day course
- Location: Uk
- 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 ... Naming Procedures
- See Training Course Details...
Working with the Code Editor
Using the Select Case...End Select Structure
Using Expressions, Variables, and Intrinsic Functions
Declaring Variables
Organizing Code and Procedures
Using Intrinsic Functions
Considering Variable Scope and Lifetime Together
Using the CacheSize Property - Optional
Navigating the Access Object Hierarchy
Understanding Procedures
Using the With Statement
Specifying a Recordset Cursor Location - Optional
Working with Variable Scope
Understanding Control-of-Flow Structures
Understanding Collections
Working with Procedures and Functions
Understanding Recordset Cursor Properties - Optional
Handling Errors
Email us about this courses
Other Uk Enable Technology Training Courses
Data Warehouse - Uk SQL Training Courses
JavaScript - Uk JavaScript Training Courses
JQuery Mobile Uk Training Courses
SQL - Uk SQL Training Courses
SSIS - Uk SQL Server Integration Services Training Courses
Report Builder - Uk SQL Server Reporting Services Training Courses