Access 2016 Intermediate
This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you’ll master more advanced techniques for this powerful database program and build an entire database project from scratch.
From building reports to using conditional formatting, you’ll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications, including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you’ll build a navigation form to make it easy for your users to find their way around your database.
What Will I Learn?
- Design Tables for Better Data Entry
- Share Data with Other Applications
- Work with Action Queries
- Advanced Query Techniques
- Automate Processes with Macros
- Advanced Forms
- Advanced Report Techniques
Requirements
- Access 2016 Introduction or equivalent experience.
Who is the target audience?
- Students who want to take Access to the next level and improve their database design skills.
Course content
11 Sections 44 lectures 2 hours 7 mins in total
-
00:03:00
-
00:03:00
-
00:02:00
-
00:02:00
-
00:03:00
-
00:02:00
-
00:02:00
-
00:02:00
-
00:03:00
-
00:02:00
-
00:02:00
-
00:03:00
-
00:05:00
-
00:03:00
-
00:04:00
-
00:02:00
-
00:02:00
-
00:03:00
-
00:03:00
-
00:01:00
-
00:03:00
-
00:06:00
-
00:04:00
-
00:04:00
-
00:03:00
-
00:06:00
-
00:02:00
-
00:03:00
-
00:02:00
-
00:03:00
-
00:03:00
-
00:03:00
-
00:02:00
-
00:02:00
-
00:04:00
-
00:02:00



Reviews
14-Day
Money-Back Guarantee