Microsoft Office Access 2016 Intermediate
- 3 hours on-demand video
- 6 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Design a relational database
- Create a table
- Create query joins
- Relate data within a table
- Work with sub-datasheets
- Use field, form and record validation
- Create parameter queries and sub-queries
- Create unmatched and duplicate queries
- Normalize and de-normalize data
- Include control formatting in a report
- Add a calculated field to a report
- The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or Microsoft Office 2010 especially Microsoft Office Access 2016.
- In addition to that, a good knowledge of getting around with Microsoft Windows 10 is required as well.
- The course is part of the three course series on Microsoft Office Access 2016.
- It is recommended that the students complete the previous level before opting for this course.
The Microsoft Office Access 2016: Intermediate course builds upon basic Microsoft Access skills acquired in Access Basic course to help students become power users. In this Microsoft Access course, students will delve deeper into the program by studying topics such as how to manage data and data entry, create forms and dialog boxes, split databases, and much more. The course focuses on the Access 2016 topics such as designing a relational database, joining tables, using data validation, creating advanced queries, organizing a database for efficiency and using advanced reporting techniques.
Microsoft Office is critical to the day to day operations of any organization. This three leveled set of courses is specifically focused on the Microsoft Office Access 2016 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2016.
- Individuals looking to update their skill-set to Microsoft Office Access 2016
- Data entry operators
- Writers and publishers
- Candidates seeking to move to the latest version of Microsoft Office Access