Companies Home Search Profile

Microsoft Access 2016 Intermediate/Advanced Course

Focused View

Simon Sez IT

9:05:52

146 View
  • 1 - Course Overview and Content.mp4
    09:05
  • 2 - WATCH ME Essential Information for a Successful Training Experience.mp4
    02:11
  • 3 - Access-2016-Advanced-Exercise-Files.zip
  • 3 - DOWNLOAD ME Course Exercise Files.html
  • 4 - Access-2016-Advanced-Course-Files.zip
  • 4 - DOWNLOAD ME Course Demo Files.html
  • 5 - Primary Keys and Indexing Rules and Guidelines.mp4
    12:15
  • 6 - More About Indexes.mp4
    09:07
  • 7 - Settingup Northwind Database.mp4
    04:44
  • 8 - Working in a Datasheet View.mp4
    13:06
  • 9 - Customizing Datasheet View and Advanced Sorting and Filtering.mp4
    16:10
  • 10 - Subdatasheets.mp4
    11:04
  • 11 - Exercise 01.mp4
    01:06
  • 12 - Linking Two Tables to Other Access Databases.mp4
    15:38
  • 13 - Acquiring and Installing SQL Server Express.mp4
    14:31
  • 14 - Setting up SQL Server Database.mp4
    14:57
  • 15 - Exercise 2.mp4
    01:16
  • 16 - Splitting an Access Database into Frontend and Backend Databases.mp4
    12:04
  • 17 - Converting Shared Table into Local Table Moving Backend Database.mp4
    13:55
  • 18 - Exercise 3.mp4
    01:58
  • 19 - Addressing Multiusers Issues When Sharing Data.mp4
    16:04
  • 20 - Basics of Macros.mp4
    13:36
  • 21 - Macros on Events AutoExec.mp4
    14:34
  • 22 - More About AutoExec Bypassing AutoExec.mp4
    16:20
  • 23 - Macro Security Settings.mp4
    08:36
  • 24 - Exercise 4.mp4
    05:43
  • 25 - Customizing the Ribbon and Quick Access Tool.mp4
    13:56
  • 26 - Convert Macros to VBA VBA Editor and Property Windows.mp4
    14:26
  • 27 - VBA Modules Running Code and Error Handling.mp4
    16:32
  • 28 - Creating Modules Subs Functions Intellisense and Variables.mp4
    14:47
  • 29 - Scope Variable Naming and Strings.mp4
    15:17
  • 30 - Standard Functions Logical Case and Loop Statements.mp4
    15:41
  • 31 - Adding Events to Assets Database.mp4
    14:34
  • 32 - Exercise 05.mp4
    02:20
  • 33 - Common Events Form and Report Events.mp4
    15:45
  • 34 - Switchboard and Navigation Form Error Handling.mp4
    16:28
  • 35 - Exercise 06.mp4
    10:15
  • 36 - Formatting Bound and Control Form.mp4
    14:45
  • 37 - Split Forms Macro Error Handling.mp4
    14:43
  • 38 - Creating Form with Tab.mp4
    12:49
  • 39 - Go To Combo Box and Its Properties.mp4
    13:19
  • 40 - Exercise 07.mp4
    07:42
  • 41 - Basic of Queries Review.mp4
    13:25
  • 42 - Syntax of SQL Statements.mp4
    14:10
  • 43 - Use of Multiple Where Criteria Select Statements Function.mp4
    10:50
  • 44 - Joins and Its Types.mp4
    13:19
  • 45 - Exercise 08.mp4
    00:39
  • 46 - Action Queries Part 1.mp4
    15:21
  • 47 - Action Queries Part 2.mp4
    11:01
  • 48 - Subqueries.mp4
    04:16
  • 49 - Steps in Packaging Access Application.mp4
    15:17
  • 50 - Exercise 09.mp4
    01:20
  • 51 - Online Support and Conclusion.mp4
    04:55
  • 52 - Access-Shortcuts.pdf
  • 52 - EXTRA RESOURCE The Most Frequently Used Access Shortcuts Infographic.html
  • Description


    The ultimate next step for anyone interested in supercharging their Microsoft Access and data analysis skills

    What You'll Learn?


    • Discover how to effectively link to other data sources.
    • Learn how to split a database by splitting the frontend and backend.
    • Explore the use of Visual Basic for Applications (VBA).
    • Discover advanced options for the use of forms.
    • Dive into options for packaging your application for distribution.
    • Practice with included Access 2016 exercises files.
    • Follow along with the instructor with included instructor demostration files.
    • Discover advanced options and tips for building and using queries.
    • Follow along as you learn to create and maintain macros.
    • Complete database projects at the advanced level.
    • Get helpful techniques that allow you to link, report, and package your data quickly.

    Who is this for?


  • Experienced database managers or those who are familiar with Access 2016 or 2013
  • More details


    Description

    Become a Microsoft Access database expert with this easy-to-follow course featuring 8 hours of professionally produced videos. Exercise and demo files included.  

    • Practice what you learn      with included exercise files.

    • A full 8 hours of      professional video instruction.

    • 48 easy-to-follow how-to      videos.

    • Everything explained      step-by-step for quick comprehension.

    • Complete database      projects at the advanced level.

    • The next step after      completing Microsoft Access 2016 for Beginners.

    • Enables you to complete      projects on time and within budget.

    • Increase your value at      work.

    • Starts with basic      advanced features.

    • Discover how to      effectively link to other data sources.

    • Learn how to split a      database by splitting the frontend and backend.

    • Follow along as you learn      to create and maintain macros.

    • Explore the use of Visual      Basic for Applications (VBA).

    • Discover advanced options      for the use of forms and queries.

    • Dive into options for      packaging your application for distribution.

    • Practice with bonus      Access 2016 exercises.

    In today’s data-driven world, effective data management is crucial, with no room for error. If you’ve already taken our beginner Microsoft Access 2016 course, or have a beginner knowledge of Microsoft Access 2016, you’re ready for our Microsoft Access 2016 Advanced course. Get ready to become a data management expert as this 8-hour class takes your skills to the next level.  

    You’ll boost your knowledge significantly as you get acquainted with Microsoft Access 2016’s most sophisticated features.  

    Contents and Overview  

    Your Microsoft certified professional trainer will show you how to use macros, advanced forms and queries, and other tools to create a professional, working database. Follow along as you learn to create and maintain macros, then see how to effectively link to other data sources.  

    Get helpful techniques that allow you to link, report, and package your data quickly, and discover how to split a database by splitting the frontend and backend.  

    With this informative course, you’ll learn the skills you need to make an impact with sleek, high-performing databases that help you do your job efficiently and competently.  

    Plus, when you sign up for this course, you’ll also get these extras:  

    1. Exercise files – to      help you become proficient with the material.

    2. Instructor demo files – use      the same database files used by your instructor.

    3. An optional online quiz      (45 questions) - to test what you've learned.

    4. A certificate of      completion - to tell everyone you've aced the course.

    If you’re ready to master Microsoft Access 2016 and sign up for the course, go ahead and hit that Enroll button, or try some of the free videos by using the Free Preview feature. We look forward to seeing you in the course!      


    Here’s what our students are saying…

    “Instructor is really knowledgeable. The course is indeed advanced access and covers a lot of topics. By definition none of them in depth, but it's all about giving us the bearing points to pursue our own learning with the 3 key p's: practice, practice and practice! Totally recommended.”
    – Moises Redondo

    “Very descriptive/informative and easy to follow steps. Love the accent.” 
    – Brenda Bachtold

    “Well prepared and clearly presented by arguably the best instructor on Udemy.”
    – Bill Dam



    Did you know?

    Simon Sez IT teaches all sorts of software, including:

    - Microsoft Excel

    - Microsoft PowerPoint

    - Microsoft Word

    - Microsoft Project

    - Microsoft Outlook

    - QuickBooks

    - Photoshop Elements

    - Web Development Languages

    - And so much more!

    Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.  

    Who this course is for:

    • Experienced database managers or those who are familiar with Access 2016 or 2013

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category
    Simon Sez IT
    Simon Sez IT
    Instructor's Courses
    Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 8,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 630,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 49
    • duration 9:05:52
    • English subtitles has
    • Release Date 2023/03/02

    Courses related to Microsoft Access