Back to Courses
MS Access 2016 Advanced
Description MS Access 2016 Advanced is designed to teach the learners about the advanced features and functionalities of MS Access. …
MS Access 2016 Advanced is designed to teach the learners about the advanced features and functionalities of MS Access. You’ll learn how to create and manage a database more effectively by taking your existing knowledge to the next level.
Course Curriculum
Course Curriculum
| Introduction | |||
| Introduction | FREE | 00:01:00 | |
| Improving the Structure of a Database | |||
| Using the Table Analyzer Wizard | 00:05:00 | ||
| Append Querying to Normalize a Table | 00:08:00 | ||
| Creating a Junction Table | 00:06:00 | ||
| Maintaining a Database | |||
| Backing Up a Database | 00:02:00 | ||
| Using the Compact and Repair Database Tool | 00:03:00 | ||
| Using the Object Dependencies Tool | 00:02:00 | ||
| Using the Database Documenter Tool | 00:02:00 | ||
| Using the Performance Analyzer Tool | 00:02:00 | ||
| Working with Access Switchboards | |||
| Understanding the Access Switchboard | 00:03:00 | ||
| Using The Switchboard Manager | 00:09:00 | ||
| Modifying a Switchboard | 00:05:00 | ||
| Setting the Startup Options | 00:04:00 | ||
| Configuring Access for Multiple Users | |||
| Using the database Splitter | 00:04:00 | ||
| Configuring Trusted Locations | 00:02:00 | ||
| Password Protecting a Database | 00:03:00 | ||
| Password Protecting Modules | 00:01:00 | ||
| Converting a Database to an ACCDE file | 00:01:00 | ||
| Automating Processes with VBA | |||
| Understanding VBA Basics | 00:06:00 | ||
| Exploring Variables and Control Flow Statements | 00:10:00 | ||
| Exporting a Table or Query with VBA | 00:06:00 | ||
| Converting a Macro to VBA | 00:02:00 | ||
| Using Table Events | |||
| Understanding Table Events | 00:02:00 | ||
| Using the Before Change Event Command | 00:04:00 | ||
| Using the After Change Event Command | 00:04:00 | ||
| Conclusion | |||
| Course Recap | 00:04:00 | ||
| Resources | |||
| Resources – MS Access 2016 Advanced | 00:00:00 | ||
| Order Your Certificate | |||
| Order Your Certificate | 00:00:00 | ||
Don't just take our word for it
Amazing workshop.
Very informative for the freshers like me. Learned a lot of things about digital marketing. I'm really thankful.
Aarini Sinha 
It was a great experience. The course was jampacked with excellent information. And when I needed help, Skill-up helped me with technical problems instantly. Fast feedback.
Varsha Sivamohan 
I am currently signed on to several courses with skill up. I have just finished my second one. The courses are informative and good for all types of learners. I recommend them.
Judith Taylor 
The support team was FANTASTIC!!! Very quick to respond and even though I was nervous as I am not good at tests, they made me feel comfortable.
I am very grateful for the support
Charlie Anderson 
Completed the Level 3 Mental Health Support Worker course, very good and highly recommend it.
Very good course, enjoyed it thoroughly and important in my line of work as a Support worker.
Parmjit Dosanjh 
I am pleased to have completed my online course in Mental Health First Aid with SkillUp. All the modules were detailed & comprehensive with review questions, which really helped me to grasp the information & prepared me well for the mock test & final exam.
Shan 
I was a bit nervous about the course but I gave a try,it's perfect and I still can't believe I paid a peanut to acquire such a course,the sliding show and introduction was well understood.i will recommend skill up to anyone interested to persuade a meaningful career,and also to the support team keep doing the good work.💪
Sara Nana 
1 Year Access 
17 Students 
1 hour, 41 minutes