Skip to main content
by learnformula
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
  1. Courses
  2. /Office Productivity
  3. /Microsoft

Access 2016 Beginners

Advanced Training Course

Created bySimon Sez ITworkspace_premiumBest Instructor
BeginnerUpdated Jan 21, 2025
Access 2016 Beginners

What You'll Learn

  • check_circlePerfect for complete beginners Follow along exercises included 10 hours of detailed training in over 70 easy to follow videos Expert instructor Simon Sez IT has taught over 400k people essential software skills

About This Course

Microsoft Access 2016 for Beginners is the ultimate video instruction course for those who have no previous experience with this powerful software. Now you can get the full picture of how Microsoft Access works with clear, easy to understand instruction in this impressive 10-hour course spread across 70 professionally produced videos. Microsoft Access is the leading database application that has become a standard in businesses and organizations around the world. These days, having the ability to work with a database is key to running an efficient and capable operation. Bosses everywhere appreciate any employee who is well trained in MS Access. Now that person can be you! Increase your value in the workplace by mastering one of the most important but little understood options in MS Office. You'll see how it gives you major advantages with your personal and social projects. Also great for people who are already familiar with MS Access, our courses are designed to allow you to skip ahead to more advanced processes and explore all that's new in version 2016.

Course Content

1 activity • 71 videos • duration: 11h 26m

remove
Videos-Part171 videos • 11.4 hours
  • videocamIntroduction to Access 2016 Course
    Duration 6:19
  • videocamAcquiring Access 2016
    Duration 8:44
  • videocamStructure of the Course
    Duration 2:17
  • videocamWhat's New in Access 2016
    Duration 2:32
  • videocamUsing Access in a Touch Device
    Duration 7:05
  • videocamUsing Database Templates
    Duration 14:46
  • videocamCreating, Saving, and Opening Databases
    Duration 8:45
  • videocamThe Access Workspace and Backstage
    Duration 13:44
  • videocamOnline Help and Tell Me
    Duration 9:17
  • videocamThe Ribbon
    Duration 9:53
  • videocamThe Quick Access Toolbar
    Duration 5:31
  • videocamContextual Menus
    Duration 3:51
  • videocamThe Status Bar
    Duration 4:05
  • videocamKeyboard Shortcuts
    Duration 3:34
  • videocamKey Tips
    Duration 3:10
  • videocamGeneral, Current Databases, and Language Options
    Duration 12:03
  • videocamCreating a Table and Fields
    Duration 14:45
  • videocamIndexed Field
    Duration 11:37
  • videocamLookup Wizard
    Duration 14:31
  • videocamNumeric Fields
    Duration 10:43
  • videocamExercise 01
    Duration 4:22
  • videocamImporting Data from Excel
    Duration 14:59
  • videocamExcercise 02
    Duration 5:19
  • videocamBacking up your Database
    Duration 6:45
  • videocamCompact and Repair
    Duration 7:19
  • videocamDesign in the Datasheet View
    Duration 11:22
  • videocamSorting and Filtering in Datasheet View
    Duration 10:37
  • videocamEntering and Modifying Data in Datasheet View
    Duration 12:55
  • videocamCreating a Link Table
    Duration 12:20
  • videocamSetting up Relationships
    Duration 12:55
  • videocamExercise 03
    Duration 10:20
  • videocamCreating a Form
    Duration 14:57
  • videocamModifying a Form
    Duration 6:27
  • videocamExercise 04
    Duration 2:09
  • videocamForms in Layout View
    Duration 14:30
  • videocamForms in Design View
    Duration 14:00
  • videocamForm Design
    Duration 14:33
  • videocamExercise 05
    Duration 1:36
  • videocamSetting up Subforms - Part 1
    Duration 13:01
  • videocamSetting up Subforms - Part 2
    Duration 10:01
  • videocamSetting up Subform - Part 3
    Duration 13:55
  • videocamExercise 06
    Duration 4:52
  • videocamCreating a Query
    Duration 14:26
  • videocamJoins
    Duration 10:51
  • videocamQuery Wizard
    Duration 15:09
  • videocamExercise 07
    Duration 10:10
  • videocamSetting up Validations
    Duration 12:15
  • videocamCalculation using Expressions
    Duration 9:24
  • videocamBasic Report
    Duration 11:56
  • videocamReport Design
    Duration 13:01
  • videocamComplex Report
    Duration 16:42
  • videocamExercise 08
    Duration 2:52
  • videocamPrinting and Print Properties
    Duration 9:27
  • videocamYes/No, OLE Object, and Hyperlink Data Types
    Duration 12:22
  • videocamForm Controls
    Duration 11:24
  • videocamForm Themes
    Duration 14:05
  • videocamForm Navigation
    Duration 12:16
  • videocamIntroduction to Model Dialog and Macros
    Duration 14:19
  • videocamModel Dialog and Macros Continued
    Duration 13:29
  • videocamForm Validation
    Duration 14:59
  • videocamAdding a Command Button to a Form
    Duration 9:36
  • videocamExercise 09
    Duration 8:12
  • videocamCreating an Access Web App
    Duration 11:27
  • videocamImporting an Access Database to a Web App
    Duration 11:28
  • videocamExercise 10
    Duration 5:57
  • videocamExporting an Access Database
    Duration 4:54
  • videocamAdding Application Parts to a Database
    Duration 5:06
  • videocamAdditional Access 2016 Options
    Duration 7:12
  • videocamView and Edit Database Properties, and Encrypt with Password
    Duration 7:26
  • videocamTrust Center Settings
    Duration 8:15
  • videocamClosing
    Duration 1:11

Your Instructor

Simon Sez IT

Since 2008, we've taught 2 million learners in over 190 countries, with 200+ courses

menu_book151 courses
star9,307 reviews

Since its formation in 2008, Simon Sez IT has been educating learners with one goal in mind: to make business and technical software simple to learn. The company extensive library of over 10,000 videos across more than 200 courses delivers comprehensive training for the most popular software applications used by professionals worldwide. Courses include training in everyday IT applications, from Microsoft suite of office productivity tools to more niche applications such as QuickBooks, Power BI and many more. Aimed at every level of proficiency, Simon Sez IT courses are designed to give learners the ability to quickly evolve from beginner to advanced, or to drop in at their relevant level and acquire new skills to continue in their development path. Simon Sez IT subject matter experts bring knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply new knowledge and master learning goals. More than two million learners have relied on Simon Sez IT for its quality and engaging coursework. Student feedback is consistently ranked among the best in the industry, with particular emphasis on the quality, detail and delivery of the course materials. Many indicate that upon completion of a course, they are more confident and proficient in their area of study, and their skills have helped them progress in their careers.

Credit Information

Is this course eligible for my CPD requirements as a Canadian CPA?

Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.

Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.

What Students Are Saying

4.6 out of 5
Student's Choice
14 reviews
  • KB
    Krishna B.
    starstarstarstarstar

    Excellent course. Good pace. Clear instruction. The exercises really help to understand the material

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(556 reviews)
    2 CPD hrs
  • Finance: Budgeting & Financial Forecasting

    Critical Skills for CFOs & Controllers: Budgeting & Forecasting Strategies for Today’s World

    starRated5.0out of 5,(113 reviews)
    2.5 CPD hrs
  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(646 reviews)
    2.5 CPD hrs