Ultimate Microsoft Access 2016 Course - Beginner to Expert

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Get An Advanced Understanding of the Many Access 2016 Features That Will Enable You to Gather and Interpret Data Faster.

  • Sorting Information and Running Queries
  • Creating Tables and Relationships
  • Designing Forms (and Advanced Form Options)
  • Generating Reports
  • Splitting the Frontend and Backend of a database
  • Macros
  • Visual Basic for Applications (VBA)

Contents and Overview

Through 118 lectures, 18 hours of quality content, and quizzes, this 18-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources.

Budding Access 2016 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence.

Exercise files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application.

This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills.

Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately.

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. Online quizzes - to test what you've learned.
  4. A certificate of completion - to tell everyone you've aced the course.

Contents and Overview for the 10-Hour Access 2016 Beginner Course

Microsoft Access 2016 for Beginners: Master the Essentials starts at the very beginning, showing you where to get your copy of MS Access and how to install it on your computer. Before going further, you'll get a quick tour of all of the new features and improvements in 2016.

You will learn how to get started easily with database templates that make the entire process faster. Then you'll see how to create, save and open databases.

After a tour of the Access Workspace and Backstage, you'll get a complete explanation of the toolbars and ribbons. Next, you'll gain a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency.

You'll progress to creating your own working database with step-by-step video instruction that takes you through the entire process, helping you master details while understanding the big picture.

Later the course goes into importing data from Excel and creating and working with forms and sub-forms. As you become more advanced, you'll learn how to use queries and validations, create reports and print your projects.

This course contains comprehensive instructions through 70 professionally produced videos within ten chapters. You'll supercharge your database projects and learn valuable new skills for complex data projects at work. Get started with this course now and easily become an expert at MS Access 2016.

Contents and Overview for the 8-Hour Access 2016 Advanced Course

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.

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!

Who this course is for:

  • 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

Expected Outcomes

  1. Practice what you learned with included exercise files Sorting information and running queries Creating tables and relationships Navigating the Access 2016 interface Design forms and generate reports Learn valuable new skills for complex data projects at work Supercharge your database projects Discover how to into import data from Excel Learn Queries, use validations, how to create and print reports How to compact, repair and backup your database How to create a linked table Discover how to use the Query Wizard Learn to use Model Dialog and Macros 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. Show more Show less Requirements A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases. Microsoft Access 2016 Description Get An Advanced Understanding of the Many Access 2016 Features That Will Enable You to Gather and Interpret Data Faster . Sorting Information and Running Queries Creating Tables and Relationships Designing Forms (and Advanced Form Options) Generating Reports Splitting the Frontend and Backend of a database Macros Visual Basic for Applications (VBA) Contents and Overview Through 118 lectures, 18 hours of quality content, and quizzes, this 18-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Budding Access 2016 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence. Exercise files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application. This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills. Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately. Plus, when you sign up for this course, you’ll also get these extras: Exercise files – to help you become proficient with the material. Instructor demo files – use the same database files used by your instructor. Online quizzes - to test what you've learned. A certificate of completion - to tell everyone you've aced the course. Contents and Overview for the 10-Hour Access 2016 Beginner Course Microsoft Access 2016 for Beginners: Master the Essentials starts at the very beginning, showing you where to get your copy of MS Access and how to install it on your computer. Before going further, you'll get a quick tour of all of the new features and improvements in 2016. You will learn how to get started easily with database templates that make the entire process faster. Then you'll see how to create, save and open databases. After a tour of the Access Workspace and Backstage, you'll get a complete explanation of the toolbars and ribbons. Next, you'll gain a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency. You'll progress to creating your own working database with step-by-step video instruction that takes you through the entire process, helping you master details while understanding the big picture. Later the course goes into importing data from Excel and creating and working with forms and sub-forms. As you become more advanced, you'll learn how to use queries and validations, create reports and print your projects. This course contains comprehensive instructions through 70 professionally produced videos within ten chapters. You'll supercharge your database projects and learn valuable new skills for complex data projects at work. Get started with this course now and easily become an expert at MS Access 2016. Contents and Overview for the 8-Hour Access 2016 Advanced Course 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. 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! Who this course is for: 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 Show more Show less Featured review Paul Mitchell 22 courses 7 reviews Rating: 5.0 out of 5 2 years ago Toby! hope you don't mind me calling you Toby. Your Course was 1st Class, well put together and your explanations were easy to understand. The speed of your course for me was good, and I was able to understand you, me being an older person. Well done and Thank You. Show more Show less Course content 43 sections • 126 lectures • 20h 35m total length Expand all sections Introduction 7 lectures • 23min Introduction to Access 2016 Course Preview 06:19 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:22 Course Demo Files 00:23 Acquiring Access 2016 Preview 08:44 Structure of the Course Preview 02:17 What's New in Access 2016 Preview 02:32 Section 1 Quiz 1 question Using Touch 1 lecture • 7min Using Access in a Touch Device 07:05 Section 2 Quiz 1 question Getting Started 3 lectures • 37min Using Database Templates Preview 14:46 Creating, Saving, and Opening Databases Preview 08:45 The Access Workspace and Backstage Preview 13:44 Section 3 Quiz 1 question Help 1 lecture • 9min Online Help and Tell Me 09:17 Section 4 Quiz 1 question The Ribbon and Toolbars 4 lectures • 23min The Ribbon 09:53 The Quick Access Toolbar 05:31 Contextual Menus 03:51 The Status Bar 04:05 Section 5 Quiz 4 questions Keyboard Shortcuts and Key Tips 2 lectures • 7min Keyboard Shortcuts 03:34 Key Tips 03:10 Section 6 Quiz 1 question Access Options 1 lecture • 12min General, Current Databases, and Language Options 12:03 Section 7 Quiz 2 questions Tables 5 lectures • 56min Creating a Table and Fields Preview 14:45 Indexed Field 11:37 Lookup Wizard 14:31 Numeric Fields 10:43 Exercise 01 04:22 Section 8 Quiz 6 questions Importing Data 2 lectures • 20min Importing Data from Excel 14:59 Excercise 02 05:19 Section 9 Quiz 2 questions Backup, Restore, and Repair 2 lectures • 14min Backing up your Database 06:45 Compact and Repair 07:19 Section 10 Quiz 1 question 33 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 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 5,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 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678117123c850756',m:'54989872ad598946b00a52bbb42fecefc817b7c5-1627842129-1800-AeMNuWXRMnPoB70cZ/k2B7DXViE1IRWCSXmCyXvjWQpReBYxFinVD7kfuW6t6zPyQalh7YDP0foftenR8FFq9/bVhTSts8IsTsz0/pG6OzlnQUhzK3TJxYmoAxuT7SgX6X4R94eq+L1SAJXfLv4PRh8iPfo3KFVwpd6hFQ4AjJKa6H+q5HPZrg0eV0+dITKDUEmpzKPKFqezbzede74rIDI=',s:[0xe78f1fb326,0x636b4342ce],}})();
  2. Sorting information and running queries Creating tables and relationships Navigating the Access 2016 interface Design forms and generate reports Learn valuable new skills for complex data projects at work Supercharge your database projects Discover how to into import data from Excel Learn Queries, use validations, how to create and print reports How to compact, repair and backup your database How to create a linked table Discover how to use the Query Wizard Learn to use Model Dialog and Macros 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. Show more Show less Requirements A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases. Microsoft Access 2016 Description Get An Advanced Understanding of the Many Access 2016 Features That Will Enable You to Gather and Interpret Data Faster . Sorting Information and Running Queries Creating Tables and Relationships Designing Forms (and Advanced Form Options) Generating Reports Splitting the Frontend and Backend of a database Macros Visual Basic for Applications (VBA) Contents and Overview Through 118 lectures, 18 hours of quality content, and quizzes, this 18-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Budding Access 2016 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence. Exercise files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application. This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills. Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately. Plus, when you sign up for this course, you’ll also get these extras: Exercise files – to help you become proficient with the material. Instructor demo files – use the same database files used by your instructor. Online quizzes - to test what you've learned. A certificate of completion - to tell everyone you've aced the course. Contents and Overview for the 10-Hour Access 2016 Beginner Course Microsoft Access 2016 for Beginners: Master the Essentials starts at the very beginning, showing you where to get your copy of MS Access and how to install it on your computer. Before going further, you'll get a quick tour of all of the new features and improvements in 2016. You will learn how to get started easily with database templates that make the entire process faster. Then you'll see how to create, save and open databases. After a tour of the Access Workspace and Backstage, you'll get a complete explanation of the toolbars and ribbons. Next, you'll gain a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency. You'll progress to creating your own working database with step-by-step video instruction that takes you through the entire process, helping you master details while understanding the big picture. Later the course goes into importing data from Excel and creating and working with forms and sub-forms. As you become more advanced, you'll learn how to use queries and validations, create reports and print your projects. This course contains comprehensive instructions through 70 professionally produced videos within ten chapters. You'll supercharge your database projects and learn valuable new skills for complex data projects at work. Get started with this course now and easily become an expert at MS Access 2016. Contents and Overview for the 8-Hour Access 2016 Advanced Course 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. 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! Who this course is for: 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 Show more Show less Featured review Paul Mitchell 22 courses 7 reviews Rating: 5.0 out of 5 2 years ago Toby! hope you don't mind me calling you Toby. Your Course was 1st Class, well put together and your explanations were easy to understand. The speed of your course for me was good, and I was able to understand you, me being an older person. Well done and Thank You. Show more Show less Course content 43 sections • 126 lectures • 20h 35m total length Expand all sections Introduction 7 lectures • 23min Introduction to Access 2016 Course Preview 06:19 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:22 Course Demo Files 00:23 Acquiring Access 2016 Preview 08:44 Structure of the Course Preview 02:17 What's New in Access 2016 Preview 02:32 Section 1 Quiz 1 question Using Touch 1 lecture • 7min Using Access in a Touch Device 07:05 Section 2 Quiz 1 question Getting Started 3 lectures • 37min Using Database Templates Preview 14:46 Creating, Saving, and Opening Databases Preview 08:45 The Access Workspace and Backstage Preview 13:44 Section 3 Quiz 1 question Help 1 lecture • 9min Online Help and Tell Me 09:17 Section 4 Quiz 1 question The Ribbon and Toolbars 4 lectures • 23min The Ribbon 09:53 The Quick Access Toolbar 05:31 Contextual Menus 03:51 The Status Bar 04:05 Section 5 Quiz 4 questions Keyboard Shortcuts and Key Tips 2 lectures • 7min Keyboard Shortcuts 03:34 Key Tips 03:10 Section 6 Quiz 1 question Access Options 1 lecture • 12min General, Current Databases, and Language Options 12:03 Section 7 Quiz 2 questions Tables 5 lectures • 56min Creating a Table and Fields Preview 14:45 Indexed Field 11:37 Lookup Wizard 14:31 Numeric Fields 10:43 Exercise 01 04:22 Section 8 Quiz 6 questions Importing Data 2 lectures • 20min Importing Data from Excel 14:59 Excercise 02 05:19 Section 9 Quiz 2 questions Backup, Restore, and Repair 2 lectures • 14min Backing up your Database 06:45 Compact and Repair 07:19 Section 10 Quiz 1 question 33 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 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 5,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 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678117123c850756',m:'54989872ad598946b00a52bbb42fecefc817b7c5-1627842129-1800-AeMNuWXRMnPoB70cZ/k2B7DXViE1IRWCSXmCyXvjWQpReBYxFinVD7kfuW6t6zPyQalh7YDP0foftenR8FFq9/bVhTSts8IsTsz0/pG6OzlnQUhzK3TJxYmoAxuT7SgX6X4R94eq+L1SAJXfLv4PRh8iPfo3KFVwpd6hFQ4AjJKa6H+q5HPZrg0eV0+dITKDUEmpzKPKFqezbzede74rIDI=',s:[0xe78f1fb326,0x636b4342ce],}})();
  3. Creating tables and relationships Navigating the Access 2016 interface Design forms and generate reports Learn valuable new skills for complex data projects at work Supercharge your database projects Discover how to into import data from Excel Learn Queries, use validations, how to create and print reports How to compact, repair and backup your database How to create a linked table Discover how to use the Query Wizard Learn to use Model Dialog and Macros 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. Show more Show less Requirements A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases. Microsoft Access 2016 Description Get An Advanced Understanding of the Many Access 2016 Features That Will Enable You to Gather and Interpret Data Faster . Sorting Information and Running Queries Creating Tables and Relationships Designing Forms (and Advanced Form Options) Generating Reports Splitting the Frontend and Backend of a database Macros Visual Basic for Applications (VBA) Contents and Overview Through 118 lectures, 18 hours of quality content, and quizzes, this 18-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Budding Access 2016 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence. Exercise files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application. This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills. Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately. Plus, when you sign up for this course, you’ll also get these extras: Exercise files – to help you become proficient with the material. Instructor demo files – use the same database files used by your instructor. Online quizzes - to test what you've learned. A certificate of completion - to tell everyone you've aced the course. Contents and Overview for the 10-Hour Access 2016 Beginner Course Microsoft Access 2016 for Beginners: Master the Essentials starts at the very beginning, showing you where to get your copy of MS Access and how to install it on your computer. Before going further, you'll get a quick tour of all of the new features and improvements in 2016. You will learn how to get started easily with database templates that make the entire process faster. Then you'll see how to create, save and open databases. After a tour of the Access Workspace and Backstage, you'll get a complete explanation of the toolbars and ribbons. Next, you'll gain a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency. You'll progress to creating your own working database with step-by-step video instruction that takes you through the entire process, helping you master details while understanding the big picture. Later the course goes into importing data from Excel and creating and working with forms and sub-forms. As you become more advanced, you'll learn how to use queries and validations, create reports and print your projects. This course contains comprehensive instructions through 70 professionally produced videos within ten chapters. You'll supercharge your database projects and learn valuable new skills for complex data projects at work. Get started with this course now and easily become an expert at MS Access 2016. Contents and Overview for the 8-Hour Access 2016 Advanced Course 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. 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! Who this course is for: 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 Show more Show less Featured review Paul Mitchell 22 courses 7 reviews Rating: 5.0 out of 5 2 years ago Toby! hope you don't mind me calling you Toby. Your Course was 1st Class, well put together and your explanations were easy to understand. The speed of your course for me was good, and I was able to understand you, me being an older person. Well done and Thank You. Show more Show less Course content 43 sections • 126 lectures • 20h 35m total length Expand all sections Introduction 7 lectures • 23min Introduction to Access 2016 Course Preview 06:19 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:22 Course Demo Files 00:23 Acquiring Access 2016 Preview 08:44 Structure of the Course Preview 02:17 What's New in Access 2016 Preview 02:32 Section 1 Quiz 1 question Using Touch 1 lecture • 7min Using Access in a Touch Device 07:05 Section 2 Quiz 1 question Getting Started 3 lectures • 37min Using Database Templates Preview 14:46 Creating, Saving, and Opening Databases Preview 08:45 The Access Workspace and Backstage Preview 13:44 Section 3 Quiz 1 question Help 1 lecture • 9min Online Help and Tell Me 09:17 Section 4 Quiz 1 question The Ribbon and Toolbars 4 lectures • 23min The Ribbon 09:53 The Quick Access Toolbar 05:31 Contextual Menus 03:51 The Status Bar 04:05 Section 5 Quiz 4 questions Keyboard Shortcuts and Key Tips 2 lectures • 7min Keyboard Shortcuts 03:34 Key Tips 03:10 Section 6 Quiz 1 question Access Options 1 lecture • 12min General, Current Databases, and Language Options 12:03 Section 7 Quiz 2 questions Tables 5 lectures • 56min Creating a Table and Fields Preview 14:45 Indexed Field 11:37 Lookup Wizard 14:31 Numeric Fields 10:43 Exercise 01 04:22 Section 8 Quiz 6 questions Importing Data 2 lectures • 20min Importing Data from Excel 14:59 Excercise 02 05:19 Section 9 Quiz 2 questions Backup, Restore, and Repair 2 lectures • 14min Backing up your Database 06:45 Compact and Repair 07:19 Section 10 Quiz 1 question 33 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 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 5,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 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678117123c850756',m:'54989872ad598946b00a52bbb42fecefc817b7c5-1627842129-1800-AeMNuWXRMnPoB70cZ/k2B7DXViE1IRWCSXmCyXvjWQpReBYxFinVD7kfuW6t6zPyQalh7YDP0foftenR8FFq9/bVhTSts8IsTsz0/pG6OzlnQUhzK3TJxYmoAxuT7SgX6X4R94eq+L1SAJXfLv4PRh8iPfo3KFVwpd6hFQ4AjJKa6H+q5HPZrg0eV0+dITKDUEmpzKPKFqezbzede74rIDI=',s:[0xe78f1fb326,0x636b4342ce],}})();
  4. Navigating the Access 2016 interface Design forms and generate reports Learn valuable new skills for complex data projects at work Supercharge your database projects Discover how to into import data from Excel Learn Queries, use validations, how to create and print reports How to compact, repair and backup your database How to create a linked table Discover how to use the Query Wizard Learn to use Model Dialog and Macros 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. Show more Show less Requirements A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases. Microsoft Access 2016 Description Get An Advanced Understanding of the Many Access 2016 Features That Will Enable You to Gather and Interpret Data Faster . Sorting Information and Running Queries Creating Tables and Relationships Designing Forms (and Advanced Form Options) Generating Reports Splitting the Frontend and Backend of a database Macros Visual Basic for Applications (VBA) Contents and Overview Through 118 lectures, 18 hours of quality content, and quizzes, this 18-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Budding Access 2016 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence. Exercise files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application. This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills. Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately. Plus, when you sign up for this course, you’ll also get these extras: Exercise files – to help you become proficient with the material. Instructor demo files – use the same database files used by your instructor. Online quizzes - to test what you've learned. A certificate of completion - to tell everyone you've aced the course. Contents and Overview for the 10-Hour Access 2016 Beginner Course Microsoft Access 2016 for Beginners: Master the Essentials starts at the very beginning, showing you where to get your copy of MS Access and how to install it on your computer. Before going further, you'll get a quick tour of all of the new features and improvements in 2016. You will learn how to get started easily with database templates that make the entire process faster. Then you'll see how to create, save and open databases. After a tour of the Access Workspace and Backstage, you'll get a complete explanation of the toolbars and ribbons. Next, you'll gain a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency. You'll progress to creating your own working database with step-by-step video instruction that takes you through the entire process, helping you master details while understanding the big picture. Later the course goes into importing data from Excel and creating and working with forms and sub-forms. As you become more advanced, you'll learn how to use queries and validations, create reports and print your projects. This course contains comprehensive instructions through 70 professionally produced videos within ten chapters. You'll supercharge your database projects and learn valuable new skills for complex data projects at work. Get started with this course now and easily become an expert at MS Access 2016. Contents and Overview for the 8-Hour Access 2016 Advanced Course 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. 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! Who this course is for: 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 Show more Show less Featured review Paul Mitchell 22 courses 7 reviews Rating: 5.0 out of 5 2 years ago Toby! hope you don't mind me calling you Toby. Your Course was 1st Class, well put together and your explanations were easy to understand. The speed of your course for me was good, and I was able to understand you, me being an older person. Well done and Thank You. Show more Show less Course content 43 sections • 126 lectures • 20h 35m total length Expand all sections Introduction 7 lectures • 23min Introduction to Access 2016 Course Preview 06:19 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:22 Course Demo Files 00:23 Acquiring Access 2016 Preview 08:44 Structure of the Course Preview 02:17 What's New in Access 2016 Preview 02:32 Section 1 Quiz 1 question Using Touch 1 lecture • 7min Using Access in a Touch Device 07:05 Section 2 Quiz 1 question Getting Started 3 lectures • 37min Using Database Templates Preview 14:46 Creating, Saving, and Opening Databases Preview 08:45 The Access Workspace and Backstage Preview 13:44 Section 3 Quiz 1 question Help 1 lecture • 9min Online Help and Tell Me 09:17 Section 4 Quiz 1 question The Ribbon and Toolbars 4 lectures • 23min The Ribbon 09:53 The Quick Access Toolbar 05:31 Contextual Menus 03:51 The Status Bar 04:05 Section 5 Quiz 4 questions Keyboard Shortcuts and Key Tips 2 lectures • 7min Keyboard Shortcuts 03:34 Key Tips 03:10 Section 6 Quiz 1 question Access Options 1 lecture • 12min General, Current Databases, and Language Options 12:03 Section 7 Quiz 2 questions Tables 5 lectures • 56min Creating a Table and Fields Preview 14:45 Indexed Field 11:37 Lookup Wizard 14:31 Numeric Fields 10:43 Exercise 01 04:22 Section 8 Quiz 6 questions Importing Data 2 lectures • 20min Importing Data from Excel 14:59 Excercise 02 05:19 Section 9 Quiz 2 questions Backup, Restore, and Repair 2 lectures • 14min Backing up your Database 06:45 Compact and Repair 07:19 Section 10 Quiz 1 question 33 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 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 5,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 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678117123c850756',m:'54989872ad598946b00a52bbb42fecefc817b7c5-1627842129-1800-AeMNuWXRMnPoB70cZ/k2B7DXViE1IRWCSXmCyXvjWQpReBYxFinVD7kfuW6t6zPyQalh7YDP0foftenR8FFq9/bVhTSts8IsTsz0/pG6OzlnQUhzK3TJxYmoAxuT7SgX6X4R94eq+L1SAJXfLv4PRh8iPfo3KFVwpd6hFQ4AjJKa6H+q5HPZrg0eV0+dITKDUEmpzKPKFqezbzede74rIDI=',s:[0xe78f1fb326,0x636b4342ce],}})();
  5. Design forms and generate reports Learn valuable new skills for complex data projects at work Supercharge your database projects Discover how to into import data from Excel Learn Queries, use validations, how to create and print reports How to compact, repair and backup your database How to create a linked table Discover how to use the Query Wizard Learn to use Model Dialog and Macros 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. Show more Show less Requirements A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases. Microsoft Access 2016 Description Get An Advanced Understanding of the Many Access 2016 Features That Will Enable You to Gather and Interpret Data Faster . Sorting Information and Running Queries Creating Tables and Relationships Designing Forms (and Advanced Form Options) Generating Reports Splitting the Frontend and Backend of a database Macros Visual Basic for Applications (VBA) Contents and Overview Through 118 lectures, 18 hours of quality content, and quizzes, this 18-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Budding Access 2016 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence. Exercise files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application. This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills. Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately. Plus, when you sign up for this course, you’ll also get these extras: Exercise files – to help you become proficient with the material. Instructor demo files – use the same database files used by your instructor. Online quizzes - to test what you've learned. A certificate of completion - to tell everyone you've aced the course. Contents and Overview for the 10-Hour Access 2016 Beginner Course Microsoft Access 2016 for Beginners: Master the Essentials starts at the very beginning, showing you where to get your copy of MS Access and how to install it on your computer. Before going further, you'll get a quick tour of all of the new features and improvements in 2016. You will learn how to get started easily with database templates that make the entire process faster. Then you'll see how to create, save and open databases. After a tour of the Access Workspace and Backstage, you'll get a complete explanation of the toolbars and ribbons. Next, you'll gain a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency. You'll progress to creating your own working database with step-by-step video instruction that takes you through the entire process, helping you master details while understanding the big picture. Later the course goes into importing data from Excel and creating and working with forms and sub-forms. As you become more advanced, you'll learn how to use queries and validations, create reports and print your projects. This course contains comprehensive instructions through 70 professionally produced videos within ten chapters. You'll supercharge your database projects and learn valuable new skills for complex data projects at work. Get started with this course now and easily become an expert at MS Access 2016. Contents and Overview for the 8-Hour Access 2016 Advanced Course 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. 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! Who this course is for: 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 Show more Show less Featured review Paul Mitchell 22 courses 7 reviews Rating: 5.0 out of 5 2 years ago Toby! hope you don't mind me calling you Toby. Your Course was 1st Class, well put together and your explanations were easy to understand. The speed of your course for me was good, and I was able to understand you, me being an older person. Well done and Thank You. Show more Show less Course content 43 sections • 126 lectures • 20h 35m total length Expand all sections Introduction 7 lectures • 23min Introduction to Access 2016 Course Preview 06:19 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:22 Course Demo Files 00:23 Acquiring Access 2016 Preview 08:44 Structure of the Course Preview 02:17 What's New in Access 2016 Preview 02:32 Section 1 Quiz 1 question Using Touch 1 lecture • 7min Using Access in a Touch Device 07:05 Section 2 Quiz 1 question Getting Started 3 lectures • 37min Using Database Templates Preview 14:46 Creating, Saving, and Opening Databases Preview 08:45 The Access Workspace and Backstage Preview 13:44 Section 3 Quiz 1 question Help 1 lecture • 9min Online Help and Tell Me 09:17 Section 4 Quiz 1 question The Ribbon and Toolbars 4 lectures • 23min The Ribbon 09:53 The Quick Access Toolbar 05:31 Contextual Menus 03:51 The Status Bar 04:05 Section 5 Quiz 4 questions Keyboard Shortcuts and Key Tips 2 lectures • 7min Keyboard Shortcuts 03:34 Key Tips 03:10 Section 6 Quiz 1 question Access Options 1 lecture • 12min General, Current Databases, and Language Options 12:03 Section 7 Quiz 2 questions Tables 5 lectures • 56min Creating a Table and Fields Preview 14:45 Indexed Field 11:37 Lookup Wizard 14:31 Numeric Fields 10:43 Exercise 01 04:22 Section 8 Quiz 6 questions Importing Data 2 lectures • 20min Importing Data from Excel 14:59 Excercise 02 05:19 Section 9 Quiz 2 questions Backup, Restore, and Repair 2 lectures • 14min Backing up your Database 06:45 Compact and Repair 07:19 Section 10 Quiz 1 question 33 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 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 5,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 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678117123c850756',m:'54989872ad598946b00a52bbb42fecefc817b7c5-1627842129-1800-AeMNuWXRMnPoB70cZ/k2B7DXViE1IRWCSXmCyXvjWQpReBYxFinVD7kfuW6t6zPyQalh7YDP0foftenR8FFq9/bVhTSts8IsTsz0/pG6OzlnQUhzK3TJxYmoAxuT7SgX6X4R94eq+L1SAJXfLv4PRh8iPfo3KFVwpd6hFQ4AjJKa6H+q5HPZrg0eV0+dITKDUEmpzKPKFqezbzede74rIDI=',s:[0xe78f1fb326,0x636b4342ce],}})();
  6. Learn valuable new skills for complex data projects at work Supercharge your database projects Discover how to into import data from Excel Learn Queries, use validations, how to create and print reports How to compact, repair and backup your database How to create a linked table Discover how to use the Query Wizard Learn to use Model Dialog and Macros 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. Show more Show less Requirements A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases. Microsoft Access 2016 Description Get An Advanced Understanding of the Many Access 2016 Features That Will Enable You to Gather and Interpret Data Faster . Sorting Information and Running Queries Creating Tables and Relationships Designing Forms (and Advanced Form Options) Generating Reports Splitting the Frontend and Backend of a database Macros Visual Basic for Applications (VBA) Contents and Overview Through 118 lectures, 18 hours of quality content, and quizzes, this 18-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Budding Access 2016 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence. Exercise files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application. This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills. Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately. Plus, when you sign up for this course, you’ll also get these extras: Exercise files – to help you become proficient with the material. Instructor demo files – use the same database files used by your instructor. Online quizzes - to test what you've learned. A certificate of completion - to tell everyone you've aced the course. Contents and Overview for the 10-Hour Access 2016 Beginner Course Microsoft Access 2016 for Beginners: Master the Essentials starts at the very beginning, showing you where to get your copy of MS Access and how to install it on your computer. Before going further, you'll get a quick tour of all of the new features and improvements in 2016. You will learn how to get started easily with database templates that make the entire process faster. Then you'll see how to create, save and open databases. After a tour of the Access Workspace and Backstage, you'll get a complete explanation of the toolbars and ribbons. Next, you'll gain a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency. You'll progress to creating your own working database with step-by-step video instruction that takes you through the entire process, helping you master details while understanding the big picture. Later the course goes into importing data from Excel and creating and working with forms and sub-forms. As you become more advanced, you'll learn how to use queries and validations, create reports and print your projects. This course contains comprehensive instructions through 70 professionally produced videos within ten chapters. You'll supercharge your database projects and learn valuable new skills for complex data projects at work. Get started with this course now and easily become an expert at MS Access 2016. Contents and Overview for the 8-Hour Access 2016 Advanced Course 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. 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! Who this course is for: 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 Show more Show less Featured review Paul Mitchell 22 courses 7 reviews Rating: 5.0 out of 5 2 years ago Toby! hope you don't mind me calling you Toby. Your Course was 1st Class, well put together and your explanations were easy to understand. The speed of your course for me was good, and I was able to understand you, me being an older person. Well done and Thank You. Show more Show less Course content 43 sections • 126 lectures • 20h 35m total length Expand all sections Introduction 7 lectures • 23min Introduction to Access 2016 Course Preview 06:19 WATCH ME: Essential Information for a Successful Training Experience 02:11 Course Exercise Files 00:22 Course Demo Files 00:23 Acquiring Access 2016 Preview 08:44 Structure of the Course Preview 02:17 What's New in Access 2016 Preview 02:32 Section 1 Quiz 1 question Using Touch 1 lecture • 7min Using Access in a Touch Device 07:05 Section 2 Quiz 1 question Getting Started 3 lectures • 37min Using Database Templates Preview 14:46 Creating, Saving, and Opening Databases Preview 08:45 The Access Workspace and Backstage Preview 13:44 Section 3 Quiz 1 question Help 1 lecture • 9min Online Help and Tell Me 09:17 Section 4 Quiz 1 question The Ribbon and Toolbars 4 lectures • 23min The Ribbon 09:53 The Quick Access Toolbar 05:31 Contextual Menus 03:51 The Status Bar 04:05 Section 5 Quiz 4 questions Keyboard Shortcuts and Key Tips 2 lectures • 7min Keyboard Shortcuts 03:34 Key Tips 03:10 Section 6 Quiz 1 question Access Options 1 lecture • 12min General, Current Databases, and Language Options 12:03 Section 7 Quiz 2 questions Tables 5 lectures • 56min Creating a Table and Fields Preview 14:45 Indexed Field 11:37 Lookup Wizard 14:31 Numeric Fields 10:43 Exercise 01 04:22 Section 8 Quiz 6 questions Importing Data 2 lectures • 20min Importing Data from Excel 14:59 Excercise 02 05:19 Section 9 Quiz 2 questions Backup, Restore, and Repair 2 lectures • 14min Backing up your Database 06:45 Compact and Repair 07:19 Section 10 Quiz 1 question 33 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,732 Students 171 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 5,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 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678117123c850756',m:'54989872ad598946b00a52bbb42fecefc817b7c5-1627842129-1800-AeMNuWXRMnPoB70cZ/k2B7DXViE1IRWCSXmCyXvjWQpReBYxFinVD7kfuW6t6zPyQalh7YDP0foftenR8FFq9/bVhTSts8IsTsz0/pG6OzlnQUhzK3TJxYmoAxuT7SgX6X4R94eq+L1SAJXfLv4PRh8iPfo3KFVwpd6hFQ4AjJKa6H+q5HPZrg0eV0+dITKDUEmpzKPKFqezbzede74rIDI=',s:[0xe78f1fb326,0x636b4342ce],}})();
  7. Supercharge your database projects Discover how to into import data from Excel Learn Queries, use validations, how to create and print reports How to compact, repair and backup your database How to create a linked table Discover how to use the Query Wizard Learn to use Model Dialog and Macros 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. Show more Show less Requirements A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases. Microsoft Access 2016 Description Get An Advanced Understanding of the Many Access 2016 Features That Will Enable You to Gather and Interpret Data Faster . Sorting Information and Running Queries Creating Tables and Relationships Designing Forms (and Advanced Form Options) Generating Reports Splitting the Frontend and Backend of a database Macros Visual Basic for Applications (VBA) Contents and Overview Through 118 lectures, 18 hours of quality content, and quizzes, this 18-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Budding Access 2016 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence. Exercise files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application. This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills. Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately. Plus, when you sign up for this course, you’ll also get these extras: Exercise files – to help you become proficient with the material. Instructor demo files – use the same database files used by your instructor. Online quizzes - to test what you've learned. A certificate of completion - to tell everyone you've aced the course. Contents and Overview for the 10-Hour Access 2016 Beginner Course Microsoft Access 2016 for Beginners: Master the Essentials starts at the very beginning, showing you where to get your copy of MS Access and how to install it on your computer. Before going further, you'll get a quick tour of all of the new features and improvements in 2016. You will learn how to get started easily with database templates that make the entire process faster. Then you'll see how to create, save and open databases. After a tour of the Access Workspace and Backstage, you'll get a complete explanation of the toolbars and ribbons. Next, you'll gain a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency. You'll progress to creating your own working database with step-by-step video instruction that takes you through the entire process, helping you master details while understanding the big picture. Later the course goes into importing data from Excel and creating and working with forms and sub-forms. As you become more advanced, you'll learn how to use queries and validations, create reports and print your projects. This course contains comprehensive instructions through 70 professionally produced videos within ten chapters. You'll supercharge your database projects and learn valuable new skills for complex data projects at work. Get started with this course now and easily become an expert at MS Access 2016. Contents and Overview for the