ACCESS TRAINING COURSES UK
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 ... Macros on Forms
- See Training Course Details...
Database Wellness
Multi Table Queries
Creating a Lookup Database
Adding Transactional Records
Database Security
Creating Queries
Formatting Tables
Creating a Relational Database
Creating and Using Macros
Adding Records to a Table
DIY Forms
Using a Navigation Form
Data Validation
Macro Techniques
Action Queries
Parameter Queries
Getting to Know Access
Importing and Exporting Records
Designing a Lookup Database
Modifying Table Structures
Microsoft Access Programming Using VBA
- 3 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Working with the Application Object
- See Training Course Details...
Using the Immediate Window to Call Procedures
Using Intrinsic Functions
Understanding the Err Object
Working with Events
Understanding Data Types
Understanding Expressions and Statements
Understanding Procedures
Using the For...Next Structure
Working with the Code Editor
Setting Break Expressions
Working with Boolean Expressions
Understanding the Form Object
Using Message Boxes
Determining the Value of Expressions
Specifying a Recordset Cursor Location - Optional
Handling Errors
Understanding Modules
Email us about this courses
Other Uk Enable Technology Training Courses
Power Graphics Uk Training Courses
Project 2016 Uk Training Courses
PHP - Uk PHP Training Courses
PowerPoint Advanced - Uk Office Training Courses
TSQL - Uk SQL Training Courses
SSRS 2008 - Uk SQL Server Reporting Services Training Courses