Microsoft Access Level 2 - Intermediate Access

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

Course Description

Go Beyond Access Basics

Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together.

Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks. Below are just a few of the topics that you will master:

  • How to set data entry defaults and using Validation Rules

  • Show a field’s history and create Lookup Fields

  • Hide duplicate values and records in a Query

  • How to use Action Queries: Update, Append, Delete and Make Table

  • Create Form drop-down lists to lookup values, or Combo Boxes

  • Add Form Option Groups that controls the list of choices available for a user

  • Add more space to your Forms without scrolling with Tabs

  • Jump around quickly to other Access Objects by creating Form Command Buttons

  • Add, Sort and Filter records in a Report, as well as keeping groups together

  • Add summary fields to your Reports and include SubReports

  • And much, much more!

Who this course is for:

  • This Microsoft Access Intermediate Level 2 course is for anyone who wants to advance beyond the basics of Access
  • Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified

Expected Outcomes

  1. Get more accurate data entry by controlling a user’s input with controls Find unique values and records, and using wildcards Create prompts and do mass record updates with Action Queries How to Filter and Sort records in Forms and Reports Bring more functionality to Form with Tabs, Combo Boxes and Command Buttons Quickly summarize the details of your records in Forms with Subforms Quickly summarize the details of your records in Forms with Subforms Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements This course was created with Access 2016; however, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 You will need Microsoft Access installed on your computer to follow along and complete the exercise files Description Go Beyond Access Basics Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together. Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks. Below are just a few of the topics that you will master: How to set data entry defaults and using Validation Rules Show a field’s history and create Lookup Fields Hide duplicate values and records in a Query How to use Action Queries: Update, Append, Delete and Make Table Create Form drop-down lists to lookup values, or Combo Boxes Add Form Option Groups that controls the list of choices available for a user Add more space to your Forms without scrolling with Tabs Jump around quickly to other Access Objects by creating Form Command Buttons Add, Sort and Filter records in a Report, as well as keeping groups together Add summary fields to your Reports and include SubReports And much, much more! Who this course is for: This Microsoft Access Intermediate Level 2 course is for anyone who wants to advance beyond the basics of Access Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified Show more Show less Course content 8 sections • 41 lectures • 5h 13m total length Expand all sections Data Defaults & Validation Rule 1 lecture • 15min Data Defaults & Validation Rule Preview 14:39 Access Level 2 - Intermediate 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Advanced Tables 3 lectures • 26min Show Column History 04:46 Input Masks 09:07 Lookup Fields 11:58 Advanced Tables Quiz 4 questions Advanced Queries 11 lectures • 1hr 10min Inner & Outer Data Joins 11:16 Join Unrelated Tables 02:16 Self Join 06:03 Top Values Query 04:40 Unique Values & Records 05:38 Wildcard Query 03:46 Parameter Query 08:06 Update Query 09:09 Append Query 06:57 Delete Query 07:13 Make Table Query 05:23 Advanced Queries Quiz 10 questions Advanced Forms 9 lectures • 1hr 22min Layout View & Table Formats 12:37 Anchor Controls 03:52 Filter & Sort Records 03:28 Enhance Appearance 16:44 Combo Box 11:47 Option Controls Group 05:31 Form Tab Pages 12:02 Command Button 03:22 Subform 12:18 Advanced Forms Quiz 8 questions Advanced Reports 8 lectures • 1hr 14min Organizing Records 11:05 Adding, Sorting & Filtering Groups 08:18 Advanced Formatting 22:14 Keep Groups Together 04:15 Force New Page 03:12 Adding Summary Field 13:35 Add Subreports 05:54 Create Mailing Labels 05:14 Advanced Reports Quiz 8 questions Import and Export Data 7 lectures • 41min Import Excel 09:20 Import Text & CSV Files 08:33 Export to Word 02:48 Export to CSV File 05:44 Export to Excel for Charts & PivotTables 02:40 Export to Text File 03:39 Mail Merge with Microsoft Word 08:23 Import and Export Data Quiz 4 questions Course Wrap Up 1 lecture • 1min BONUS! - Special Offer! Discount on ANY of my Courses! 00:12 Instructor Kirt Kershaw Microsoft Certified Trainer - Training Microsoft Since 2000! 4.5 Instructor Rating 3,966 Reviews 18,432 Students 15 Courses Kirt Kershaw is President of Dream Force LLC and provides certified and professional training videos on Microsoft Office applications including: Access, Excel, Outlook, PowerPoint, Word, Project and Windows since 2000. His certifications include: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016. Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP), Certified Microsoft Project XP (2002), 2010 and 2013 and CompTIA's A+. Whew! With all my certifications and experience you're probably looking at the biography of the only Microsoft trainer on the web who has the most Microsoft teaching experience and holds the most Microsoft certifications. So, I do have a lot to share in my arsenal of Microsoft Office training. What Makes My Training Unique? If you've read my reviews , seen my certifications (above) and my training videos , you probably already know the answer to this; I focus on step-by-step basics to more advanced training including: unique tips, tricks, shortcuts and other Microsoft Office time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass Microsoft Access, Excel, Outlook, Project, PowerPoint and Word Exams and become certified! 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:'678197ad09284078',m:'0a8d8ea7a1722d0159f9b91a0461bdbc88a07d52-1627847396-1800-AWMjmqyTq/yJmPwYvf64gFVrEslWLjuMGijw4o7knZGd0jFehKj5wCBzpguoopdjgpV/j4q+Ky3UR6D36elktinZqmrvookt7jSfGU7tzRBaRuV7msoEtxMfyHemDo2NEi8KkONizfrkMwHw88apdb+K+pm567uNg9moPjTxX3jYrKQhgV7JOMQMEgL9RI6GfA==',s:[0xea273e5d4d,0x744754d1a4],}})();
  2. Find unique values and records, and using wildcards Create prompts and do mass record updates with Action Queries How to Filter and Sort records in Forms and Reports Bring more functionality to Form with Tabs, Combo Boxes and Command Buttons Quickly summarize the details of your records in Forms with Subforms Quickly summarize the details of your records in Forms with Subforms Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements This course was created with Access 2016; however, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 You will need Microsoft Access installed on your computer to follow along and complete the exercise files Description Go Beyond Access Basics Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together. Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks. Below are just a few of the topics that you will master: How to set data entry defaults and using Validation Rules Show a field’s history and create Lookup Fields Hide duplicate values and records in a Query How to use Action Queries: Update, Append, Delete and Make Table Create Form drop-down lists to lookup values, or Combo Boxes Add Form Option Groups that controls the list of choices available for a user Add more space to your Forms without scrolling with Tabs Jump around quickly to other Access Objects by creating Form Command Buttons Add, Sort and Filter records in a Report, as well as keeping groups together Add summary fields to your Reports and include SubReports And much, much more! Who this course is for: This Microsoft Access Intermediate Level 2 course is for anyone who wants to advance beyond the basics of Access Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified Show more Show less Course content 8 sections • 41 lectures • 5h 13m total length Expand all sections Data Defaults & Validation Rule 1 lecture • 15min Data Defaults & Validation Rule Preview 14:39 Access Level 2 - Intermediate 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Advanced Tables 3 lectures • 26min Show Column History 04:46 Input Masks 09:07 Lookup Fields 11:58 Advanced Tables Quiz 4 questions Advanced Queries 11 lectures • 1hr 10min Inner & Outer Data Joins 11:16 Join Unrelated Tables 02:16 Self Join 06:03 Top Values Query 04:40 Unique Values & Records 05:38 Wildcard Query 03:46 Parameter Query 08:06 Update Query 09:09 Append Query 06:57 Delete Query 07:13 Make Table Query 05:23 Advanced Queries Quiz 10 questions Advanced Forms 9 lectures • 1hr 22min Layout View & Table Formats 12:37 Anchor Controls 03:52 Filter & Sort Records 03:28 Enhance Appearance 16:44 Combo Box 11:47 Option Controls Group 05:31 Form Tab Pages 12:02 Command Button 03:22 Subform 12:18 Advanced Forms Quiz 8 questions Advanced Reports 8 lectures • 1hr 14min Organizing Records 11:05 Adding, Sorting & Filtering Groups 08:18 Advanced Formatting 22:14 Keep Groups Together 04:15 Force New Page 03:12 Adding Summary Field 13:35 Add Subreports 05:54 Create Mailing Labels 05:14 Advanced Reports Quiz 8 questions Import and Export Data 7 lectures • 41min Import Excel 09:20 Import Text & CSV Files 08:33 Export to Word 02:48 Export to CSV File 05:44 Export to Excel for Charts & PivotTables 02:40 Export to Text File 03:39 Mail Merge with Microsoft Word 08:23 Import and Export Data Quiz 4 questions Course Wrap Up 1 lecture • 1min BONUS! - Special Offer! Discount on ANY of my Courses! 00:12 Instructor Kirt Kershaw Microsoft Certified Trainer - Training Microsoft Since 2000! 4.5 Instructor Rating 3,966 Reviews 18,432 Students 15 Courses Kirt Kershaw is President of Dream Force LLC and provides certified and professional training videos on Microsoft Office applications including: Access, Excel, Outlook, PowerPoint, Word, Project and Windows since 2000. His certifications include: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016. Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP), Certified Microsoft Project XP (2002), 2010 and 2013 and CompTIA's A+. Whew! With all my certifications and experience you're probably looking at the biography of the only Microsoft trainer on the web who has the most Microsoft teaching experience and holds the most Microsoft certifications. So, I do have a lot to share in my arsenal of Microsoft Office training. What Makes My Training Unique? If you've read my reviews , seen my certifications (above) and my training videos , you probably already know the answer to this; I focus on step-by-step basics to more advanced training including: unique tips, tricks, shortcuts and other Microsoft Office time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass Microsoft Access, Excel, Outlook, Project, PowerPoint and Word Exams and become certified! 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:'678197ad09284078',m:'0a8d8ea7a1722d0159f9b91a0461bdbc88a07d52-1627847396-1800-AWMjmqyTq/yJmPwYvf64gFVrEslWLjuMGijw4o7knZGd0jFehKj5wCBzpguoopdjgpV/j4q+Ky3UR6D36elktinZqmrvookt7jSfGU7tzRBaRuV7msoEtxMfyHemDo2NEi8KkONizfrkMwHw88apdb+K+pm567uNg9moPjTxX3jYrKQhgV7JOMQMEgL9RI6GfA==',s:[0xea273e5d4d,0x744754d1a4],}})();
  3. Create prompts and do mass record updates with Action Queries How to Filter and Sort records in Forms and Reports Bring more functionality to Form with Tabs, Combo Boxes and Command Buttons Quickly summarize the details of your records in Forms with Subforms Quickly summarize the details of your records in Forms with Subforms Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements This course was created with Access 2016; however, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 You will need Microsoft Access installed on your computer to follow along and complete the exercise files Description Go Beyond Access Basics Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together. Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks. Below are just a few of the topics that you will master: How to set data entry defaults and using Validation Rules Show a field’s history and create Lookup Fields Hide duplicate values and records in a Query How to use Action Queries: Update, Append, Delete and Make Table Create Form drop-down lists to lookup values, or Combo Boxes Add Form Option Groups that controls the list of choices available for a user Add more space to your Forms without scrolling with Tabs Jump around quickly to other Access Objects by creating Form Command Buttons Add, Sort and Filter records in a Report, as well as keeping groups together Add summary fields to your Reports and include SubReports And much, much more! Who this course is for: This Microsoft Access Intermediate Level 2 course is for anyone who wants to advance beyond the basics of Access Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified Show more Show less Course content 8 sections • 41 lectures • 5h 13m total length Expand all sections Data Defaults & Validation Rule 1 lecture • 15min Data Defaults & Validation Rule Preview 14:39 Access Level 2 - Intermediate 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Advanced Tables 3 lectures • 26min Show Column History 04:46 Input Masks 09:07 Lookup Fields 11:58 Advanced Tables Quiz 4 questions Advanced Queries 11 lectures • 1hr 10min Inner & Outer Data Joins 11:16 Join Unrelated Tables 02:16 Self Join 06:03 Top Values Query 04:40 Unique Values & Records 05:38 Wildcard Query 03:46 Parameter Query 08:06 Update Query 09:09 Append Query 06:57 Delete Query 07:13 Make Table Query 05:23 Advanced Queries Quiz 10 questions Advanced Forms 9 lectures • 1hr 22min Layout View & Table Formats 12:37 Anchor Controls 03:52 Filter & Sort Records 03:28 Enhance Appearance 16:44 Combo Box 11:47 Option Controls Group 05:31 Form Tab Pages 12:02 Command Button 03:22 Subform 12:18 Advanced Forms Quiz 8 questions Advanced Reports 8 lectures • 1hr 14min Organizing Records 11:05 Adding, Sorting & Filtering Groups 08:18 Advanced Formatting 22:14 Keep Groups Together 04:15 Force New Page 03:12 Adding Summary Field 13:35 Add Subreports 05:54 Create Mailing Labels 05:14 Advanced Reports Quiz 8 questions Import and Export Data 7 lectures • 41min Import Excel 09:20 Import Text & CSV Files 08:33 Export to Word 02:48 Export to CSV File 05:44 Export to Excel for Charts & PivotTables 02:40 Export to Text File 03:39 Mail Merge with Microsoft Word 08:23 Import and Export Data Quiz 4 questions Course Wrap Up 1 lecture • 1min BONUS! - Special Offer! Discount on ANY of my Courses! 00:12 Instructor Kirt Kershaw Microsoft Certified Trainer - Training Microsoft Since 2000! 4.5 Instructor Rating 3,966 Reviews 18,432 Students 15 Courses Kirt Kershaw is President of Dream Force LLC and provides certified and professional training videos on Microsoft Office applications including: Access, Excel, Outlook, PowerPoint, Word, Project and Windows since 2000. His certifications include: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016. Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP), Certified Microsoft Project XP (2002), 2010 and 2013 and CompTIA's A+. Whew! With all my certifications and experience you're probably looking at the biography of the only Microsoft trainer on the web who has the most Microsoft teaching experience and holds the most Microsoft certifications. So, I do have a lot to share in my arsenal of Microsoft Office training. What Makes My Training Unique? If you've read my reviews , seen my certifications (above) and my training videos , you probably already know the answer to this; I focus on step-by-step basics to more advanced training including: unique tips, tricks, shortcuts and other Microsoft Office time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass Microsoft Access, Excel, Outlook, Project, PowerPoint and Word Exams and become certified! 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:'678197ad09284078',m:'0a8d8ea7a1722d0159f9b91a0461bdbc88a07d52-1627847396-1800-AWMjmqyTq/yJmPwYvf64gFVrEslWLjuMGijw4o7knZGd0jFehKj5wCBzpguoopdjgpV/j4q+Ky3UR6D36elktinZqmrvookt7jSfGU7tzRBaRuV7msoEtxMfyHemDo2NEi8KkONizfrkMwHw88apdb+K+pm567uNg9moPjTxX3jYrKQhgV7JOMQMEgL9RI6GfA==',s:[0xea273e5d4d,0x744754d1a4],}})();
  4. How to Filter and Sort records in Forms and Reports Bring more functionality to Form with Tabs, Combo Boxes and Command Buttons Quickly summarize the details of your records in Forms with Subforms Quickly summarize the details of your records in Forms with Subforms Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements This course was created with Access 2016; however, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 You will need Microsoft Access installed on your computer to follow along and complete the exercise files Description Go Beyond Access Basics Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together. Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks. Below are just a few of the topics that you will master: How to set data entry defaults and using Validation Rules Show a field’s history and create Lookup Fields Hide duplicate values and records in a Query How to use Action Queries: Update, Append, Delete and Make Table Create Form drop-down lists to lookup values, or Combo Boxes Add Form Option Groups that controls the list of choices available for a user Add more space to your Forms without scrolling with Tabs Jump around quickly to other Access Objects by creating Form Command Buttons Add, Sort and Filter records in a Report, as well as keeping groups together Add summary fields to your Reports and include SubReports And much, much more! Who this course is for: This Microsoft Access Intermediate Level 2 course is for anyone who wants to advance beyond the basics of Access Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified Show more Show less Course content 8 sections • 41 lectures • 5h 13m total length Expand all sections Data Defaults & Validation Rule 1 lecture • 15min Data Defaults & Validation Rule Preview 14:39 Access Level 2 - Intermediate 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Advanced Tables 3 lectures • 26min Show Column History 04:46 Input Masks 09:07 Lookup Fields 11:58 Advanced Tables Quiz 4 questions Advanced Queries 11 lectures • 1hr 10min Inner & Outer Data Joins 11:16 Join Unrelated Tables 02:16 Self Join 06:03 Top Values Query 04:40 Unique Values & Records 05:38 Wildcard Query 03:46 Parameter Query 08:06 Update Query 09:09 Append Query 06:57 Delete Query 07:13 Make Table Query 05:23 Advanced Queries Quiz 10 questions Advanced Forms 9 lectures • 1hr 22min Layout View & Table Formats 12:37 Anchor Controls 03:52 Filter & Sort Records 03:28 Enhance Appearance 16:44 Combo Box 11:47 Option Controls Group 05:31 Form Tab Pages 12:02 Command Button 03:22 Subform 12:18 Advanced Forms Quiz 8 questions Advanced Reports 8 lectures • 1hr 14min Organizing Records 11:05 Adding, Sorting & Filtering Groups 08:18 Advanced Formatting 22:14 Keep Groups Together 04:15 Force New Page 03:12 Adding Summary Field 13:35 Add Subreports 05:54 Create Mailing Labels 05:14 Advanced Reports Quiz 8 questions Import and Export Data 7 lectures • 41min Import Excel 09:20 Import Text & CSV Files 08:33 Export to Word 02:48 Export to CSV File 05:44 Export to Excel for Charts & PivotTables 02:40 Export to Text File 03:39 Mail Merge with Microsoft Word 08:23 Import and Export Data Quiz 4 questions Course Wrap Up 1 lecture • 1min BONUS! - Special Offer! Discount on ANY of my Courses! 00:12 Instructor Kirt Kershaw Microsoft Certified Trainer - Training Microsoft Since 2000! 4.5 Instructor Rating 3,966 Reviews 18,432 Students 15 Courses Kirt Kershaw is President of Dream Force LLC and provides certified and professional training videos on Microsoft Office applications including: Access, Excel, Outlook, PowerPoint, Word, Project and Windows since 2000. His certifications include: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016. Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP), Certified Microsoft Project XP (2002), 2010 and 2013 and CompTIA's A+. Whew! With all my certifications and experience you're probably looking at the biography of the only Microsoft trainer on the web who has the most Microsoft teaching experience and holds the most Microsoft certifications. So, I do have a lot to share in my arsenal of Microsoft Office training. What Makes My Training Unique? If you've read my reviews , seen my certifications (above) and my training videos , you probably already know the answer to this; I focus on step-by-step basics to more advanced training including: unique tips, tricks, shortcuts and other Microsoft Office time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass Microsoft Access, Excel, Outlook, Project, PowerPoint and Word Exams and become certified! 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:'678197ad09284078',m:'0a8d8ea7a1722d0159f9b91a0461bdbc88a07d52-1627847396-1800-AWMjmqyTq/yJmPwYvf64gFVrEslWLjuMGijw4o7knZGd0jFehKj5wCBzpguoopdjgpV/j4q+Ky3UR6D36elktinZqmrvookt7jSfGU7tzRBaRuV7msoEtxMfyHemDo2NEi8KkONizfrkMwHw88apdb+K+pm567uNg9moPjTxX3jYrKQhgV7JOMQMEgL9RI6GfA==',s:[0xea273e5d4d,0x744754d1a4],}})();
  5. Bring more functionality to Form with Tabs, Combo Boxes and Command Buttons Quickly summarize the details of your records in Forms with Subforms Quickly summarize the details of your records in Forms with Subforms Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements This course was created with Access 2016; however, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 You will need Microsoft Access installed on your computer to follow along and complete the exercise files Description Go Beyond Access Basics Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together. Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks. Below are just a few of the topics that you will master: How to set data entry defaults and using Validation Rules Show a field’s history and create Lookup Fields Hide duplicate values and records in a Query How to use Action Queries: Update, Append, Delete and Make Table Create Form drop-down lists to lookup values, or Combo Boxes Add Form Option Groups that controls the list of choices available for a user Add more space to your Forms without scrolling with Tabs Jump around quickly to other Access Objects by creating Form Command Buttons Add, Sort and Filter records in a Report, as well as keeping groups together Add summary fields to your Reports and include SubReports And much, much more! Who this course is for: This Microsoft Access Intermediate Level 2 course is for anyone who wants to advance beyond the basics of Access Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified Show more Show less Course content 8 sections • 41 lectures • 5h 13m total length Expand all sections Data Defaults & Validation Rule 1 lecture • 15min Data Defaults & Validation Rule Preview 14:39 Access Level 2 - Intermediate 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Advanced Tables 3 lectures • 26min Show Column History 04:46 Input Masks 09:07 Lookup Fields 11:58 Advanced Tables Quiz 4 questions Advanced Queries 11 lectures • 1hr 10min Inner & Outer Data Joins 11:16 Join Unrelated Tables 02:16 Self Join 06:03 Top Values Query 04:40 Unique Values & Records 05:38 Wildcard Query 03:46 Parameter Query 08:06 Update Query 09:09 Append Query 06:57 Delete Query 07:13 Make Table Query 05:23 Advanced Queries Quiz 10 questions Advanced Forms 9 lectures • 1hr 22min Layout View & Table Formats 12:37 Anchor Controls 03:52 Filter & Sort Records 03:28 Enhance Appearance 16:44 Combo Box 11:47 Option Controls Group 05:31 Form Tab Pages 12:02 Command Button 03:22 Subform 12:18 Advanced Forms Quiz 8 questions Advanced Reports 8 lectures • 1hr 14min Organizing Records 11:05 Adding, Sorting & Filtering Groups 08:18 Advanced Formatting 22:14 Keep Groups Together 04:15 Force New Page 03:12 Adding Summary Field 13:35 Add Subreports 05:54 Create Mailing Labels 05:14 Advanced Reports Quiz 8 questions Import and Export Data 7 lectures • 41min Import Excel 09:20 Import Text & CSV Files 08:33 Export to Word 02:48 Export to CSV File 05:44 Export to Excel for Charts & PivotTables 02:40 Export to Text File 03:39 Mail Merge with Microsoft Word 08:23 Import and Export Data Quiz 4 questions Course Wrap Up 1 lecture • 1min BONUS! - Special Offer! Discount on ANY of my Courses! 00:12 Instructor Kirt Kershaw Microsoft Certified Trainer - Training Microsoft Since 2000! 4.5 Instructor Rating 3,966 Reviews 18,432 Students 15 Courses Kirt Kershaw is President of Dream Force LLC and provides certified and professional training videos on Microsoft Office applications including: Access, Excel, Outlook, PowerPoint, Word, Project and Windows since 2000. His certifications include: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016. Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP), Certified Microsoft Project XP (2002), 2010 and 2013 and CompTIA's A+. Whew! With all my certifications and experience you're probably looking at the biography of the only Microsoft trainer on the web who has the most Microsoft teaching experience and holds the most Microsoft certifications. So, I do have a lot to share in my arsenal of Microsoft Office training. What Makes My Training Unique? If you've read my reviews , seen my certifications (above) and my training videos , you probably already know the answer to this; I focus on step-by-step basics to more advanced training including: unique tips, tricks, shortcuts and other Microsoft Office time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass Microsoft Access, Excel, Outlook, Project, PowerPoint and Word Exams and become certified! 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:'678197ad09284078',m:'0a8d8ea7a1722d0159f9b91a0461bdbc88a07d52-1627847396-1800-AWMjmqyTq/yJmPwYvf64gFVrEslWLjuMGijw4o7knZGd0jFehKj5wCBzpguoopdjgpV/j4q+Ky3UR6D36elktinZqmrvookt7jSfGU7tzRBaRuV7msoEtxMfyHemDo2NEi8KkONizfrkMwHw88apdb+K+pm567uNg9moPjTxX3jYrKQhgV7JOMQMEgL9RI6GfA==',s:[0xea273e5d4d,0x744754d1a4],}})();
  6. Quickly summarize the details of your records in Forms with Subforms Quickly summarize the details of your records in Forms with Subforms Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements This course was created with Access 2016; however, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 You will need Microsoft Access installed on your computer to follow along and complete the exercise files Description Go Beyond Access Basics Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together. Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks. Below are just a few of the topics that you will master: How to set data entry defaults and using Validation Rules Show a field’s history and create Lookup Fields Hide duplicate values and records in a Query How to use Action Queries: Update, Append, Delete and Make Table Create Form drop-down lists to lookup values, or Combo Boxes Add Form Option Groups that controls the list of choices available for a user Add more space to your Forms without scrolling with Tabs Jump around quickly to other Access Objects by creating Form Command Buttons Add, Sort and Filter records in a Report, as well as keeping groups together Add summary fields to your Reports and include SubReports And much, much more! Who this course is for: This Microsoft Access Intermediate Level 2 course is for anyone who wants to advance beyond the basics of Access Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified Show more Show less Course content 8 sections • 41 lectures • 5h 13m total length Expand all sections Data Defaults & Validation Rule 1 lecture • 15min Data Defaults & Validation Rule Preview 14:39 Access Level 2 - Intermediate 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Advanced Tables 3 lectures • 26min Show Column History 04:46 Input Masks 09:07 Lookup Fields 11:58 Advanced Tables Quiz 4 questions Advanced Queries 11 lectures • 1hr 10min Inner & Outer Data Joins 11:16 Join Unrelated Tables 02:16 Self Join 06:03 Top Values Query 04:40 Unique Values & Records 05:38 Wildcard Query 03:46 Parameter Query 08:06 Update Query 09:09 Append Query 06:57 Delete Query 07:13 Make Table Query 05:23 Advanced Queries Quiz 10 questions Advanced Forms 9 lectures • 1hr 22min Layout View & Table Formats 12:37 Anchor Controls 03:52 Filter & Sort Records 03:28 Enhance Appearance 16:44 Combo Box 11:47 Option Controls Group 05:31 Form Tab Pages 12:02 Command Button 03:22 Subform 12:18 Advanced Forms Quiz 8 questions Advanced Reports 8 lectures • 1hr 14min Organizing Records 11:05 Adding, Sorting & Filtering Groups 08:18 Advanced Formatting 22:14 Keep Groups Together 04:15 Force New Page 03:12 Adding Summary Field 13:35 Add Subreports 05:54 Create Mailing Labels 05:14 Advanced Reports Quiz 8 questions Import and Export Data 7 lectures • 41min Import Excel 09:20 Import Text & CSV Files 08:33 Export to Word 02:48 Export to CSV File 05:44 Export to Excel for Charts & PivotTables 02:40 Export to Text File 03:39 Mail Merge with Microsoft Word 08:23 Import and Export Data Quiz 4 questions Course Wrap Up 1 lecture • 1min BONUS! - Special Offer! Discount on ANY of my Courses! 00:12 Instructor Kirt Kershaw Microsoft Certified Trainer - Training Microsoft Since 2000! 4.5 Instructor Rating 3,966 Reviews 18,432 Students 15 Courses Kirt Kershaw is President of Dream Force LLC and provides certified and professional training videos on Microsoft Office applications including: Access, Excel, Outlook, PowerPoint, Word, Project and Windows since 2000. His certifications include: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016. Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP), Certified Microsoft Project XP (2002), 2010 and 2013 and CompTIA's A+. Whew! With all my certifications and experience you're probably looking at the biography of the only Microsoft trainer on the web who has the most Microsoft teaching experience and holds the most Microsoft certifications. So, I do have a lot to share in my arsenal of Microsoft Office training. What Makes My Training Unique? If you've read my reviews , seen my certifications (above) and my training videos , you probably already know the answer to this; I focus on step-by-step basics to more advanced training including: unique tips, tricks, shortcuts and other Microsoft Office time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass Microsoft Access, Excel, Outlook, Project, PowerPoint and Word Exams and become certified! 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:'678197ad09284078',m:'0a8d8ea7a1722d0159f9b91a0461bdbc88a07d52-1627847396-1800-AWMjmqyTq/yJmPwYvf64gFVrEslWLjuMGijw4o7knZGd0jFehKj5wCBzpguoopdjgpV/j4q+Ky3UR6D36elktinZqmrvookt7jSfGU7tzRBaRuV7msoEtxMfyHemDo2NEi8KkONizfrkMwHw88apdb+K+pm567uNg9moPjTxX3jYrKQhgV7JOMQMEgL9RI6GfA==',s:[0xea273e5d4d,0x744754d1a4],}})();
  7. Quickly summarize the details of your records in Forms with Subforms Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements This course was created with Access 2016; however, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 You will need Microsoft Access installed on your computer to follow along and complete the exercise files Description Go Beyond Access Basics Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together. Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks. Below are just a few of the topics that you will master: How to set data entry defaults and using Validation Rules Show a field’s history and create Lookup Fields Hide duplicate values and records in a Query How to use Action Queries: Update, Append, Delete and Make Table Create Form drop-down lists to lookup values, or Combo Boxes Add Form Option Groups that controls the list of choices available for a user Add more space to your Forms without scrolling with Tabs Jump around quickly to other Access Objects by creating Form Command Buttons Add, Sort and Filter records in a Report, as well as keeping groups together Add summary fields to your Reports and include SubReports And much, much more! Who this course is for: This Microsoft Access Intermediate Level 2 course is for anyone who wants to advance beyond the basics of Access Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified Show more Show less Course content 8 sections • 41 lectures • 5h 13m total length Expand all sections Data Defaults & Validation Rule 1 lecture • 15min Data Defaults & Validation Rule Preview 14:39 Access Level 2 - Intermediate 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Advanced Tables 3 lectures • 26min Show Column History 04:46 Input Masks 09:07 Lookup Fields 11:58 Advanced Tables Quiz 4 questions Advanced Queries 11 lectures • 1hr 10min Inner & Outer Data Joins 11:16 Join Unrelated Tables 02:16 Self Join 06:03 Top Values Query 04:40 Unique Values & Records 05:38 Wildcard Query 03:46 Parameter Query 08:06 Update Query 09:09 Append Query 06:57 Delete Query 07:13 Make Table Query 05:23 Advanced Queries Quiz 10 questions Advanced Forms 9 lectures • 1hr 22min Layout View & Table Formats 12:37 Anchor Controls 03:52 Filter & Sort Records 03:28 Enhance Appearance 16:44 Combo Box 11:47 Option Controls Group 05:31 Form Tab Pages 12:02 Command Button 03:22 Subform 12:18 Advanced Forms Quiz 8 questions Advanced Reports 8 lectures • 1hr 14min Organizing Records 11:05 Adding, Sorting & Filtering Groups 08:18 Advanced Formatting 22:14 Keep Groups Together 04:15 Force New Page 03:12 Adding Summary Field 13:35 Add Subreports 05:54 Create Mailing Labels 05:14 Advanced Reports Quiz 8 questions Import and Export Data 7 lectures • 41min Import Excel 09:20 Import Text & CSV Files 08:33 Export to Word 02:48 Export to CSV File 05:44 Export to Excel for Charts & PivotTables 02:40 Export to Text File 03:39 Mail Merge with Microsoft Word 08:23 Import and Export Data Quiz 4 questions Course Wrap Up 1 lecture • 1min BONUS! - Special Offer! Discount on ANY of my Courses! 00:12 Instructor Kirt Kershaw Microsoft Certified Trainer - Training Microsoft Since 2000! 4.5 Instructor Rating 3,966 Reviews 18,432 Students 15 Courses Kirt Kershaw is President of Dream Force LLC and provides certified and professional training videos on Microsoft Office applications including: Access, Excel, Outlook, PowerPoint, Word, Project and Windows since 2000. His certifications include: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016. Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP), Certified Microsoft Project XP (2002), 2010 and 2013 and CompTIA's A+. Whew! With all my certifications and experience you're probably looking at the biography of the only Microsoft trainer on the web who has the most Microsoft teaching experience and holds the most Microsoft certifications. So, I do have a lot to share in my arsenal of Microsoft Office training. What Makes My Training Unique? If you've read my reviews , seen my certifications (above) and my training videos , you probably already know the answer to this; I focus on step-by-step basics to more advanced training including: unique tips, tricks, shortcuts and other Microsoft Office time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass Microsoft Access, Excel, Outlook, Project, PowerPoint and Word Exams and become certified! 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:'678197ad09284078',m:'0a8d8ea7a1722d0159f9b91a0461bdbc88a07d52-1627847396-1800-AWMjmqyTq/yJmPwYvf64gFVrEslWLjuMGijw4o7knZGd0jFehKj5wCBzpguoopdjgpV/j4q+Ky3UR6D36elktinZqmrvookt7jSfGU7tzRBaRuV7msoEtxMfyHemDo2NEi8KkONizfrkMwHw88apdb+K+pm567uNg9moPjTxX3jYrKQhgV7JOMQMEgL9RI6GfA==',s:[0xea273e5d4d,0x744754d1a4],}})();
  8. Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements This course was created with Access 2016; however, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 You will need Microsoft Access installed on your computer to follow along and complete the exercise files Description Go Beyond Access Basics Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together. Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks. Below are just a few of the topics that you will master: How to set data entry defaults and using Validation Rules Show a field’s history and create Lookup Fields Hide duplicate values and records in a Query How to use Action Queries: Update, Append, Delete and Make Table Create Form drop-down lists to lookup values, or Combo Boxes Add Form Option Groups that controls the list of choices available for a user Add more space to your Forms without scrolling with Tabs Jump around quickly to other Access Objects by creating Form Command Buttons Add, Sort and Filter records in a Report, as well as keeping groups together Add summary fields to your Reports and include SubReports And much, much more! Who this course is for: This Microsoft Access Intermediate Level 2 course is for anyone who wants to advance beyond the basics of Access Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified Show more Show less Course content 8 sections • 41 lectures • 5h 13m total length Expand all sections Data Defaults & Validation Rule 1 lecture • 15min Data Defaults & Validation Rule Preview 14:39 Access Level 2 - Intermediate 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Advanced Tables 3 lectures • 26min Show Column History 04:46 Input Masks 09:07 Lookup Fields 11:58 Advanced Tables Quiz 4 questions Advanced Queries 11 lectures • 1hr 10min Inner & Outer Data Joins 11:16 Join Unrelated Tables 02:16 Self Join 06:03 Top Values Query 04:40 Unique Values & Records 05:38 Wildcard Query 03:46 Parameter Query 08:06 Update Query 09:09 Append Query 06:57 Delete Query 07:13 Make Table Query 05:23 Advanced Queries Quiz 10 questions Advanced Forms 9 lectures • 1hr 22min Layout View & Table Formats 12:37 Anchor Controls 03:52 Filter & Sort Records 03:28 Enhance Appearance 16:44 Combo Box 11:47 Option Controls Group 05:31 Form Tab Pages 12:02 Command Button 03:22 Subform 12:18 Advanced Forms Quiz 8 questions Advanced Reports 8 lectures • 1hr 14min Organizing Records 11:05 Adding, Sorting & Filtering Groups 08:18 Advanced Formatting 22:14 Keep Groups Together 04:15 Force New Page 03:12 Adding Summary Field 13:35 Add Subreports 05:54 Create Mailing Labels 05:14 Advanced Reports Quiz 8 questions Import and Export Data 7 lectures • 41min Import Excel 09:20 Import Text & CSV Files 08:33 Export to Word 02:48 Export to CSV File 05:44 Export to Excel for Charts & PivotTables 02:40 Export to Text File 03:39 Mail Merge with Microsoft Word 08:23 Import and Export Data Quiz 4 questions Course Wrap Up 1 lecture • 1min BONUS! - Special Offer! Discount on ANY of my Courses! 00:12 Instructor Kirt Kershaw Microsoft Certified Trainer - Training Microsoft Since 2000! 4.5 Instructor Rating 3,966 Reviews 18,432 Students 15 Courses Kirt Kershaw is President of Dream Force LLC and provides certified and professional training videos on Microsoft Office applications including: Access, Excel, Outlook, PowerPoint, Word, Project and Windows since 2000. His certifications include: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016. Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP), Certified Microsoft Project XP (2002), 2010 and 2013 and CompTIA's A+. Whew! With all my certifications and experience you're probably looking at the biography of the only Microsoft trainer on the web who has the most Microsoft teaching experience and holds the most Microsoft certifications. So, I do have a lot to share in my arsenal of Microsoft Office training. What Makes My Training Unique? If you've read my reviews , seen my certifications (above) and my training videos , you probably already know the answer to this; I focus on step-by-step basics to more advanced training including: unique tips, tricks, shortcuts and other Microsoft Office time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass Microsoft Access, Excel, Outlook, Project, PowerPoint and Word Exams and become certified! 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:'678197ad09284078',m:'0a8d8ea7a1722d0159f9b91a0461bdbc88a07d52-1627847396-1800-AWMjmqyTq/yJmPwYvf64gFVrEslWLjuMGijw4o7knZGd0jFehKj5wCBzpguoopdjgpV/j4q+Ky3UR6D36elktinZqmrvookt7jSfGU7tzRBaRuV7msoEtxMfyHemDo2NEi8KkONizfrkMwHw88apdb+K+pm567uNg9moPjTxX3jYrKQhgV7JOMQMEgL9RI6GfA==',s:[0xea273e5d4d,0x744754d1a4],}})();