Microsoft Office Access 2016 – Advanced

Microsoft Office 2016 Edition

/**/

Price: $99  $199

Format: On Demand

Duration: 2 Hours

Course Overview

This course will teach students how to design a relational database, join tables, use data validation, create advanced queries, organize a database for efficiency, and use advanced reporting techniques.

  • Course 01 – Implementing Advanced Form Design
  • Course 02 – Sharing Data Across Applications
  • Course 03 – Using Macros to Improve User Interface Design
  • Course 04 – Using VBA
  • Course 05 – Using Advanced Database Management
  • Course 06 – Distributing and Securing a Database
  • Course 07 – Managing Switchboards

Audience

  • Anyone new to Microsoft Access
  • Users new to Microsoft Access 2016 and those upgrading from previous software versions
  • Anyone new to the data management role
  • Anyone who wants to learn data management and Microsoft Access.

Career Path 

In high-growth industries, entry-level employees who hold a Microsoft Office Specialist (MOS) certification can earn up to $16,000 more, annually, than their peers. Five times as many high-growth/high-salary positions require experience with Office than all non- Microsoft software skills combined. Twenty-nine percent of tomorrow’s high-growth/high-wage positions require Office or Office- related skills.

Certification Details

Successful candidates for the Microsoft Office Specialist Access 2016 certification exam will have a fundamental understanding of the Access environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principle features of Access 2016. Candidates will learn how to implement advanced form design, share data across applications, use macros to improve user interface design, use VBA, use advanced database management, distribute and secure a database, and manage switchboards.

Certification Exam Details

Microsoft Office Specialist (MOS) 2016 certification exams are performance-based for improved testing of a candidate’s knowledge, skills, and abilities using the MOS 2016 programs. To maintain integrity, exam content is subject to change at any time without prior notice and at the sole discretion of Microsoft. This training will prepare you for the Microsoft Office Specialist Certification. Microsoft Office Specialist exams are administered by Certiport. To learn more, please go to Click here for certification details.

Available CEUs for Course Series Completion: 5
Students can earn up to 5 CEUs for fully completing this course series. This information will be displayed on the certificate of completion.

Additional Information about Continuing Education Units (CEUs)

Continuing Education Units (CEU's) are required by some certifying organizations to measure your current and continuing learning. Organizations may require you to meet a given number of education units in a specific period of time in order for your certification to be considered valid.
By completing a TechTrainingAcademy.com course series, you will be rewarded with a certificate of completion. This certificate will show how many CEU's that particular course series was worth. Students may provide this certificate to their certifying organization to provide proof of participation and completion of a Tech Training Academy.com training course series.

Please Note: The acceptance of CEU credits through completion of a Tech Training Academy training course series is solely the decision of the certifying organization. Please reach out to your certifying organization for further details and confirmation of acceptance of Tech Training Academy CEUs.

Our Online On Demand Training Courses give YOU the ability to train wherever, whenever you want! Our courses include the following training features:

    • Expert Lectures
      • Learn on-demand from top instructors who are industry subject matter experts. Our highly certified expert instructors possess a superior understanding of the subject matter in their fields and have the ability to convey this knowledge in an effective, engaging, and professional manner to a wide audience.
    • Certificates of Completion
      • Upon completion of a series of courses you can earn a certificate of completion. Certificates of Completion will display your full name, course completed, as well as the date of completion. Students have the ability to print this out or save it digitally to showcase your accomplishment.
    • Keynote Visuals
      • Many of the in-depth theories and processes discussed in our courses can be learned most efficiently through the detailed Keynote slides presented. These visuals are accompanied by an instructor voice-over to provide our students with a clear, efficient, and complete presentation of concepts.
    • Demonstrations
      • The immersive demonstrations in our training are a way for the instructor to present how to perform a task on-screen in front of the student. This feature gives the student the power to see tasks performed by a professional in the intended environment as many times as they would like, without purchasing expensive software.
    • Review Quizzes
      • Once a course is completed, test your knowledge by taking our course review quiz! Students have the ability to retake any review quizzes as many times as they wish to ensure they understand the material or to improve upon their scores.
    • Final Exams
      • Upon full completion of a training series, students can take a Series Final Exam, these exams are designed to test the students knowledge on all material trained within a series of courses. Students have the ability to retake any final exam as many times as they wish to ensure they understand the material or to improve upon their score.
    • Mobile Access
      • With our universal course player, you can learn from your computer, tablet as well as mobile devices. Keep up with your training on the go!
    • Workbooks
      • Each course comes with a printable workbook that makes it easy to take notes as you learn. They also include a review quiz answer key, complete with answer explanations.
These features are provided with all 1,500+ IT, Cyber Security, Project Management, Software Development, and Business Skills training courses in our on-demand course catalog.

Office Productivity Continuing Education Units (CEU)

Course NameCEU Credits
Microsoft Office 2019: New Features5
Microsoft Office 2016: Access 2016 Advanced5
Microsoft Office 2016: Access 2016 Intermediate5
Microsoft Office 2016: Access 2016 Basic5
Microsoft Office 2016: PowerPoint 2016 Basic7
Microsoft Office 2016: PowerPoint 2016 Advanced5
Microsoft Office 2016: New Features4
Microsoft Office 2016 Excel Basic8
Microsoft Office 2016 Excel Intermediate8
Microsoft Office 2016 Excel Advanced8
Microsoft Office 2016 Word Basic5
Microsoft Office 2016 Word Intermediate5
Microsoft Office 2016 Word Advanced4
Microsoft Office 2013 Access Basic6
Microsoft Office 2013 Access Intermediate5
Microsoft Office 2013 Access Advanced5
Microsoft Office 2013 Excel Basic8
Microsoft Office 2013 Excel Intermediate7
Microsoft Office 2013 Excel Advanced6
Microsoft Office 2013 Lync Essentials4
Microsoft Office 2013 Outlook Basic5
Microsoft Office 2013 Outlook Advanced5
Microsoft Office 2013 PowerPoint Basic7
Microsoft Office 2013 PowerPoint Advanced5
Microsoft 2013 Project Basic6
Microsoft 2013 Project Advanced6
Microsoft Office 2013 Word Basic6
Microsoft Office 2013 Word Intermediate6
Microsoft Office 2013 Word Advanced6
Microsoft Office Transition to Office 2013 from Office 2007/20105
Microsoft Office 2010 Access Basic6
Microsoft Office 2010 Access Intermediate6
Microsoft Office 2010 Access Advanced6
Microsoft Office 2010 Excel Basic7
Microsoft Office 2010 Excel Intermediate7
Microsoft Office 2010 Excel Advanced6
Microsoft Office 2010 New Features5
Microsoft Office 2010 Outlook Basic6
Microsoft Office 2010 Outlook Intermediate6
Microsoft Office 2010 Outlook Advanced5
Microsoft Office 2010 PowerPoint Basic6
Microsoft Office 2010 PowerPoint Advanced6
Microsoft 2010 Project Basic5
Microsoft 2010 Project Advanced5
Microsoft Office 2010 Word Basic6
Microsoft Office 2010 Word Intermediate6
Microsoft Office 2010 Word Advanced6
Microsoft Office 2007 Access Basic6
Microsoft Office 2007 Access Intermediate6
Microsoft Office 2007 Access Advanced5
Microsoft Office 2007 Excel Basic6
Microsoft Office 2007 Excel Intermediate7
Microsoft Office 2007 Excel Advanced6
Microsoft Office 2007 Outlook Basic6
Microsoft Office 2007 Outlook Intermediate5
Microsoft Office 2007 Outlook Advanced5
Microsoft Office 2007 PowerPoint Basic6
Microsoft Office 2007 PowerPoint Advanced5
Microsoft 2007 Project Basic5
Microsoft 2007 Project Advanced5
Microsoft Office 2007 Word Basic6
Microsoft Office 2007 Word Intermediate8
Microsoft Office 2007 Word Advanced6
Microsoft Office 365 - Administration Basics5
Microsoft Office 365 - For End Users5
Microsoft Office 365 - SharePoint for End Users4
Microsoft Office 365 - Web Apps5

Subscribe for promotions and discounts!

Interested in professional development and/or team development opportunities at your own pace? Sign up for discounts and promotions we have!

Subscribe Popup

<!-- -->