Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Access 2016 Advanced
Learn to manage and customize databases in this advanced coursePreview the first lesson free — get full access to all 51 lessons.
Advanced Provider : Stephanie Hutslar 9 chapters · 51 Lessons · 3h 43m in Arabic, English, Spanish
Course Description
Access 2016 represents the latest incarnation of Microsoft's powerful database management software. This powerful data tool allows users to store, manipulate, and report data in a variety of different ways. This Access 2016 online employee training course details advanced techniques for managing the objects we are familiar with. Additionally, this course also covers how to use the Macro object. Managing your own database sits within reach, all that's left to do is take the course and discover it all.
What You'll Learn
- Create and modify forms in Design View, including layouts, controls, design elements, and command buttons
- Control tab order, build tab pages, and apply conditional formatting to forms
- Set field properties, create input masks, and build look-up lists
- Design reports in Design View, set report properties, organize reports, add charts, and print reports
- Create macros and use events to restrict records, validate data, and automate data entry
- Convert macros to VBA and build action queries
Key Takeaways
- Access 2016 is Microsoft's database management software for storing, manipulating, and reporting data in a variety of ways.
- The course covers advanced techniques for managing the database objects users are already familiar with.
- It includes working with the Macro object to automate database tasks.
- Topics span advanced form design, field properties, report design, macros, and action queries.
Frequently Asked Questions
What does this Access 2016 Advanced course cover?
It details advanced techniques for managing familiar database objects and also covers how to use the Macro object, with lessons on form design, setting field properties, report design, macros, and action queries.
What skills will I gain from this course?
The course builds skills in Access Query Languages, Data Access, Database Management, Microsoft Access, Microsoft Data Access Components, and Microsoft Office Specialist (MOS) - Access.
Does the course cover macros and VBA?
Yes. It covers creating macros, using events, restricting records, validating data, automating data entry, and converting macros to VBA.
What can I do with forms and reports after this course?
You can create and modify forms in Design View, add controls, design elements and command buttons, control tab order, apply conditional formatting, and create reports in Design View with report properties, charts, and printing.
Who is this course for?
It is an online employee training course for Access users who are already familiar with the database objects and want to learn advanced management techniques and the Macro object.
