Access Training
Microsoft Access Developers Training Course
£795 + VAT for most venues (£895 + VAT for London)
3 days
The first (and most important) part of any Access database is getting the design right, which is where this 3-day course begins. You'll learn about primary keys and relationships, and find out how to create an Access database consisting of multiple linked tables.
The course then goes on to show how to create queries (to display data from one or more tables) and a front-end to your system, using forms, reports and the VBA coding language.
If you've been given the job of creating an Access database - and you're not sure where to start - this is the course for you!
We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking (or consider an onsite Access training course).
Course Contents
Designing a database
Identifying the tables- What are relationships?
- Setting a primary key
- Using multivalue fields
Creating tables
- Defining fields
- The types of field
- Entering data
Different field types
- Creating attachments
- Rich text format fields
- Date fields (using calendars)
- Calculated fields
Importing data
- Importing from Excel
- Making tables from Excel
If time
Table rules
- Record-level validation
- Basic triggers
Drawing relationships
- Creating relationships
- Referential integrity
Creating queries
- The query design grid
- Sorting
- Setting criteria
- Combining criteria
Advanced queries
- Grouping and totalling
- Creating expressions
- Parameter queries
Joins
- Creating ad hoc joins
- Types of join
If time
Crosstab queries
- Columns, rows and values
- Overriding column headings
If time
Action queries
- Making tables
- Updating records
- Appending records
- Deleting records
Creating forms
- Layout and design view
- Using the form wizard
- Split forms
- Creating controls
If time
Advanced controls
- Multitabs
- Webbrowser controls
- Navigation bars
Creating reports
- Using the report wizard
- The group, sort and total pane
- Report design
Creating subforms
- Multiple item forms
- Creating subforms
- Tidying up subforms
Basic VBA coding
- Creating modules
- Using Project Explorer
- Writing comments
- Indenting code
Uses of VBA
- Form validation
- Criteria forms
- A simple menu system
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 492 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Jamie Everitt (Anglian Community Enterprise (NHS PCSE))
There are lots more where these came from (or just refresh this page to change the quotes shown).
You do not need to have used Access before to attend this course, although you should be a confident computer user.
Related Courses
Other Microsoft Access training resources
Access exercises
To give you a chance to see whether this 3-day Access course is for you, we've published all of our Microsoft Access exercises online.
View Access VBA or Access 2010 exercises
Access skills assessment
You may find it useful to do one of our Access skills assessment tests, to help you know what you don't know (to misquote Donald Rumsfeld …).
View Test your Access skills skills assessment tests
Access blogs
In addtion to other Access training resources, you may find some of our Access blogs useful.
View Access or VBA macros blogs