 |
 |
 |
|||
|
Info, Blogs, Contact & Login ▼
|
Courses ▼
|
Tests ▼
|
|||
|
|
|
|
|||
|
Info, Blogs, Contact & Login ▼
|
Courses ▼
|
Tests ▼
|
|||
Options for your Shopping Cart
Microsoft Access 365 (2019) Advanced
Interactive course with workbook
SPRING SALE pricing (RRP $ 49.00)
Click on your choice [ it can be removed or edited in the cart ]
Order Qty |
Total cost | Unit cost |
|
1 |
$ 14.61 | $ 14.61 |
|
5 |
$ 69.35 | $ 13.87 |
|
10 |
$ 134.40 | $ 13.44 |
|
50 |
$ 657.00 | $ 13.14 |
|
100 |
$ 1,241.00 | $ 12.41 |
Options for your Shopping Cart
Microsoft Access 365 (2019) Advanced
+
Microsoft Access 365 (2019) Beginners
SPRING SALE pricing
Click on your choice [ it can be removed or edited in the cart ]
Order Qty |
Total cost | Unit cost |
|
1 |
$ 33.61 | $ 33.61 |
|
5 |
$ 164.35 | $ 32.87 |
|
10 |
$ 314.40 | $ 31.44 |
|
50 |
$ 1,557.00 | $ 31.14 |
|
100 |
$ 2,941.00 | $ 29.41 |
Options for your Shopping Cart
Interactive course with workbook
SPRING SALE pricing (RRP $ 0.00)
Click on your choice [ it can be removed or edited in the cart ]
Order Qty |
Total cost | Unit cost |
|
1 |
$ 14.61 | $ 14.61 |
|
5 |
$ 69.35 | $ 13.87 |
|
10 |
$ 134.40 | $ 13.44 |
|
50 |
$ 657.00 | $ 13.14 |
|
100 |
$ 1,241.00 | $ 12.41 |
Introduction
Primary Keys and Indexes
Using Datasheet View
Linking to Other Access Databases
Using ODBC and SQL Server
Splitting an Access Database
Macros
The Ribbon
Visual Basic for Applications (VBA)
Access Events Model
Forms
Advanced Use of Queries
Packaging Your Application
Course Close Some of the lessons are quite technical and you must have a good working knowledge and understanding of the concepts covered in the Introduction course.
This course has been designed for users with a good understanding of Microsoft Access who want to expand their skills further into more advanced and technical areas in a short space of time.
In our Microsoft Access advanced course, we take up from where the beginner's course finishes, and move straight into the more advanced features and tools available.
This course is ideal if you have a good working knowledge of Access but need to use its more advanced features.
In this course, we look at using ODBC and SQL Server, and look deeper into using Macros and VBA in Access. We show you how to split databases and create advanced forms.
When you're done, you'll know a whole host of advanced tools and concepts in Access that will increase your understanding, and your productivity.
This Microsoft Access skills training course, like all our courses, has been developed over many years of classroom and online delivery. Content has been thoroughly researched and is constantly updated so it's always leading edge. It's completely interactive and is full of practical knowledge and solutions.
Still wondering whether to do the course?
Just think about this: how much would you benefit if you had better Microsoft access skills?
Once you're using Access to create databases, you'll want to improve your skills.
This course assumes you know the basics of Access: how to set up your database, how tables work, how to create forms and run simple queries.
We start by covering Primary Keys and Indexes in Access, and we show you how to customize and filter in the Datasheet View.
We then show you how to link to other databases, how to use ODBC and SQL Server, and how to split an Access database into front and back-end.
Next, you'll move into using Macros in Access, including AutoExec, before learning about basic VBA in Access including code and error handling.
The course finishes with advanced techniques for creating forms in Access, and advanced queries including "multiple where" criteria.
After this course, you'll be a true Microsoft Access power user!
Watch the modules, revisit them time and again ... and have fun with improving your skills!
Microsoft Access