Microsoft Access Level 3 - Advanced Access

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

Course Description

Drive Your Microsoft Access Skills to an Advanced Level

Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options.

Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert. Below are just a few of the topics that you will master:

  • Table normalization and restructuring of poorly designed databases

  • More targeted Query results by using Subqueries

  • Perform summary calculations of intersecting values of row and column headings using Crosstab Queries

  • Automate data entry, based upon certain data entered into other fields, with Automated Macros

  • Alphabetically sort, label, and group records in your Reports

  • How to attach any file including documents and images to a record.

  • How to hide empty Record Labels from displaying and taking up unnecessary space in your Reports

  • and much, much, more…

Who this course is for:

  • This Microsoft Access Level 3 course was designed for those looking to advance their Access knowledge and skills to an advanced level, taking advantage of several more advanced Microsoft Access features
  • 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. How to normalize other databases for quicker data retrieval Find unmatched and, or duplicate records using a Query Reduce repetitive actions using Macros and adding Macro Buttons How to require and automate data entry with Macros Pull up related records fast using the Where Condition Emphasize data, or records with Conditional Formatting Compact, repair, backup and password protect your database Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements You will need Access installed on your computer to follow along and complete the exercise files Videos have been recorded using Access 2016, but all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 Description Drive Your Microsoft Access Skills to an Advanced Level Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options. Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert. Below are just a few of the topics that you will master: Table normalization and restructuring of poorly designed databases More targeted Query results by using Subqueries Perform summary calculations of intersecting values of row and column headings using Crosstab Queries Automate data entry, based upon certain data entered into other fields, with Automated Macros Alphabetically sort, label, and group records in your Reports How to attach any file including documents and images to a record. How to hide empty Record Labels from displaying and taking up unnecessary space in your Reports and much, much, more… Who this course is for: This Microsoft Access Level 3 course was designed for those looking to advance their Access knowledge and skills to an advanced level, taking advantage of several more advanced Microsoft Access features 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 11 sections • 50 lectures • 4h 14m total length Expand all sections Normalization Standard 1 lecture • 4min Normalization Standard Preview 03:34 Access Level 3 - Advanced 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 More Advanced Tables 4 lectures • 29min Table Analyzer Preview 11:52 Many to Many Relationships 07:21 Restructuring Tables 08:31 Hide Table Columns 01:18 More Advanced Tables Quiz 2 questions More Advanced Queries 5 lectures • 27min Subqueries 05:40 Unmatched Query 04:45 Duplicate Query 02:27 Criteria Groups Query 07:57 Crosstab Query Wizard 05:58 More Advanced Queries Quiz 4 questions Macros 6 lectures • 30min Create Macros 09:48 Macro Button 04:08 Where Condition 03:34 Require Data Entry Macro 05:08 Display Message Macro 02:29 Automated Macro 05:16 Macros Quiz 6 questions More Advanced Forms & Reports 5 lectures • 30min Conditional Formatting 04:37 Report Charts 04:47 Multiple Columns & Groups 15:04 Cancelling Print Job 03:52 Export to PDF or XPS 01:33 More Advanced Forms & Reports Quiz 5 questions Maintaining Database 8 lectures • 22min Linking to Other Database Tables 04:35 Database Properties 03:09 Compact & Repair Database 01:35 Backup Database 01:21 Password Protect 03:53 Object Dependency 02:19 Database Documenter 03:11 Performace Analyzer 02:23 Maintaining Database Quiz 6 questions Database Integration 9 lectures • 57min Import XML Data 10:55 Export to XML 02:41 Link to Outlook Contacts 04:11 Table Attachment Field 05:01 Save As Previous Version 02:50 Navigation Forms 08:06 Switchboard 10:12 Modifying Switchboards 04:12 Form Startup & Options 08:54 Database Integration Quiz 4 questions Distribute Database & Security 6 lectures • 18min Split Database 05:49 Distributing Split Database 02:29 Database Access Modes 02:44 Trusted Location 02:37 Protect VBA Code 01:56 File Protection ACCDE 02:38 Distribute Database & Security Quiz 4 questions Bonus! 4 lectures • 31min Digitally Sign Database 05:55 Hide Empty Record Labels in Reports 07:04 Create Table of Contents 13:10 Custom Display Control for Text Box 04:50 Bonus! Quiz 4 questions 1 more section 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:'6781a0b40f7c5433',m:'7f8b731bf9b35fff895da02fc99d3f6c024fd0a0-1627847766-1800-ATre4InJAXneyNglbZ09KTz7pAfu1fyvw0qelgIEIlyqJajLNHGA61dbwurYewEQo/AuNJyzWCyZOOOxxknmGCfh3GVNSWoF5iEMMuzzb+QYAE9Og7t30NTIwNrqzz8zb7HFTsCfH51C4sz/mU7sfK7U36MHYFYdYtdL92RkthF6CqcX4RiCYxlB4xMLDFt+jA==',s:[0x6bed3d345b,0x0b605d9b01],}})();
  2. Find unmatched and, or duplicate records using a Query Reduce repetitive actions using Macros and adding Macro Buttons How to require and automate data entry with Macros Pull up related records fast using the Where Condition Emphasize data, or records with Conditional Formatting Compact, repair, backup and password protect your database Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements You will need Access installed on your computer to follow along and complete the exercise files Videos have been recorded using Access 2016, but all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 Description Drive Your Microsoft Access Skills to an Advanced Level Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options. Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert. Below are just a few of the topics that you will master: Table normalization and restructuring of poorly designed databases More targeted Query results by using Subqueries Perform summary calculations of intersecting values of row and column headings using Crosstab Queries Automate data entry, based upon certain data entered into other fields, with Automated Macros Alphabetically sort, label, and group records in your Reports How to attach any file including documents and images to a record. How to hide empty Record Labels from displaying and taking up unnecessary space in your Reports and much, much, more… Who this course is for: This Microsoft Access Level 3 course was designed for those looking to advance their Access knowledge and skills to an advanced level, taking advantage of several more advanced Microsoft Access features 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 11 sections • 50 lectures • 4h 14m total length Expand all sections Normalization Standard 1 lecture • 4min Normalization Standard Preview 03:34 Access Level 3 - Advanced 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 More Advanced Tables 4 lectures • 29min Table Analyzer Preview 11:52 Many to Many Relationships 07:21 Restructuring Tables 08:31 Hide Table Columns 01:18 More Advanced Tables Quiz 2 questions More Advanced Queries 5 lectures • 27min Subqueries 05:40 Unmatched Query 04:45 Duplicate Query 02:27 Criteria Groups Query 07:57 Crosstab Query Wizard 05:58 More Advanced Queries Quiz 4 questions Macros 6 lectures • 30min Create Macros 09:48 Macro Button 04:08 Where Condition 03:34 Require Data Entry Macro 05:08 Display Message Macro 02:29 Automated Macro 05:16 Macros Quiz 6 questions More Advanced Forms & Reports 5 lectures • 30min Conditional Formatting 04:37 Report Charts 04:47 Multiple Columns & Groups 15:04 Cancelling Print Job 03:52 Export to PDF or XPS 01:33 More Advanced Forms & Reports Quiz 5 questions Maintaining Database 8 lectures • 22min Linking to Other Database Tables 04:35 Database Properties 03:09 Compact & Repair Database 01:35 Backup Database 01:21 Password Protect 03:53 Object Dependency 02:19 Database Documenter 03:11 Performace Analyzer 02:23 Maintaining Database Quiz 6 questions Database Integration 9 lectures • 57min Import XML Data 10:55 Export to XML 02:41 Link to Outlook Contacts 04:11 Table Attachment Field 05:01 Save As Previous Version 02:50 Navigation Forms 08:06 Switchboard 10:12 Modifying Switchboards 04:12 Form Startup & Options 08:54 Database Integration Quiz 4 questions Distribute Database & Security 6 lectures • 18min Split Database 05:49 Distributing Split Database 02:29 Database Access Modes 02:44 Trusted Location 02:37 Protect VBA Code 01:56 File Protection ACCDE 02:38 Distribute Database & Security Quiz 4 questions Bonus! 4 lectures • 31min Digitally Sign Database 05:55 Hide Empty Record Labels in Reports 07:04 Create Table of Contents 13:10 Custom Display Control for Text Box 04:50 Bonus! Quiz 4 questions 1 more section 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:'6781a0b40f7c5433',m:'7f8b731bf9b35fff895da02fc99d3f6c024fd0a0-1627847766-1800-ATre4InJAXneyNglbZ09KTz7pAfu1fyvw0qelgIEIlyqJajLNHGA61dbwurYewEQo/AuNJyzWCyZOOOxxknmGCfh3GVNSWoF5iEMMuzzb+QYAE9Og7t30NTIwNrqzz8zb7HFTsCfH51C4sz/mU7sfK7U36MHYFYdYtdL92RkthF6CqcX4RiCYxlB4xMLDFt+jA==',s:[0x6bed3d345b,0x0b605d9b01],}})();
  3. Reduce repetitive actions using Macros and adding Macro Buttons How to require and automate data entry with Macros Pull up related records fast using the Where Condition Emphasize data, or records with Conditional Formatting Compact, repair, backup and password protect your database Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements You will need Access installed on your computer to follow along and complete the exercise files Videos have been recorded using Access 2016, but all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 Description Drive Your Microsoft Access Skills to an Advanced Level Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options. Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert. Below are just a few of the topics that you will master: Table normalization and restructuring of poorly designed databases More targeted Query results by using Subqueries Perform summary calculations of intersecting values of row and column headings using Crosstab Queries Automate data entry, based upon certain data entered into other fields, with Automated Macros Alphabetically sort, label, and group records in your Reports How to attach any file including documents and images to a record. How to hide empty Record Labels from displaying and taking up unnecessary space in your Reports and much, much, more… Who this course is for: This Microsoft Access Level 3 course was designed for those looking to advance their Access knowledge and skills to an advanced level, taking advantage of several more advanced Microsoft Access features 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 11 sections • 50 lectures • 4h 14m total length Expand all sections Normalization Standard 1 lecture • 4min Normalization Standard Preview 03:34 Access Level 3 - Advanced 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 More Advanced Tables 4 lectures • 29min Table Analyzer Preview 11:52 Many to Many Relationships 07:21 Restructuring Tables 08:31 Hide Table Columns 01:18 More Advanced Tables Quiz 2 questions More Advanced Queries 5 lectures • 27min Subqueries 05:40 Unmatched Query 04:45 Duplicate Query 02:27 Criteria Groups Query 07:57 Crosstab Query Wizard 05:58 More Advanced Queries Quiz 4 questions Macros 6 lectures • 30min Create Macros 09:48 Macro Button 04:08 Where Condition 03:34 Require Data Entry Macro 05:08 Display Message Macro 02:29 Automated Macro 05:16 Macros Quiz 6 questions More Advanced Forms & Reports 5 lectures • 30min Conditional Formatting 04:37 Report Charts 04:47 Multiple Columns & Groups 15:04 Cancelling Print Job 03:52 Export to PDF or XPS 01:33 More Advanced Forms & Reports Quiz 5 questions Maintaining Database 8 lectures • 22min Linking to Other Database Tables 04:35 Database Properties 03:09 Compact & Repair Database 01:35 Backup Database 01:21 Password Protect 03:53 Object Dependency 02:19 Database Documenter 03:11 Performace Analyzer 02:23 Maintaining Database Quiz 6 questions Database Integration 9 lectures • 57min Import XML Data 10:55 Export to XML 02:41 Link to Outlook Contacts 04:11 Table Attachment Field 05:01 Save As Previous Version 02:50 Navigation Forms 08:06 Switchboard 10:12 Modifying Switchboards 04:12 Form Startup & Options 08:54 Database Integration Quiz 4 questions Distribute Database & Security 6 lectures • 18min Split Database 05:49 Distributing Split Database 02:29 Database Access Modes 02:44 Trusted Location 02:37 Protect VBA Code 01:56 File Protection ACCDE 02:38 Distribute Database & Security Quiz 4 questions Bonus! 4 lectures • 31min Digitally Sign Database 05:55 Hide Empty Record Labels in Reports 07:04 Create Table of Contents 13:10 Custom Display Control for Text Box 04:50 Bonus! Quiz 4 questions 1 more section 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:'6781a0b40f7c5433',m:'7f8b731bf9b35fff895da02fc99d3f6c024fd0a0-1627847766-1800-ATre4InJAXneyNglbZ09KTz7pAfu1fyvw0qelgIEIlyqJajLNHGA61dbwurYewEQo/AuNJyzWCyZOOOxxknmGCfh3GVNSWoF5iEMMuzzb+QYAE9Og7t30NTIwNrqzz8zb7HFTsCfH51C4sz/mU7sfK7U36MHYFYdYtdL92RkthF6CqcX4RiCYxlB4xMLDFt+jA==',s:[0x6bed3d345b,0x0b605d9b01],}})();
  4. How to require and automate data entry with Macros Pull up related records fast using the Where Condition Emphasize data, or records with Conditional Formatting Compact, repair, backup and password protect your database Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements You will need Access installed on your computer to follow along and complete the exercise files Videos have been recorded using Access 2016, but all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 Description Drive Your Microsoft Access Skills to an Advanced Level Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options. Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert. Below are just a few of the topics that you will master: Table normalization and restructuring of poorly designed databases More targeted Query results by using Subqueries Perform summary calculations of intersecting values of row and column headings using Crosstab Queries Automate data entry, based upon certain data entered into other fields, with Automated Macros Alphabetically sort, label, and group records in your Reports How to attach any file including documents and images to a record. How to hide empty Record Labels from displaying and taking up unnecessary space in your Reports and much, much, more… Who this course is for: This Microsoft Access Level 3 course was designed for those looking to advance their Access knowledge and skills to an advanced level, taking advantage of several more advanced Microsoft Access features 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 11 sections • 50 lectures • 4h 14m total length Expand all sections Normalization Standard 1 lecture • 4min Normalization Standard Preview 03:34 Access Level 3 - Advanced 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 More Advanced Tables 4 lectures • 29min Table Analyzer Preview 11:52 Many to Many Relationships 07:21 Restructuring Tables 08:31 Hide Table Columns 01:18 More Advanced Tables Quiz 2 questions More Advanced Queries 5 lectures • 27min Subqueries 05:40 Unmatched Query 04:45 Duplicate Query 02:27 Criteria Groups Query 07:57 Crosstab Query Wizard 05:58 More Advanced Queries Quiz 4 questions Macros 6 lectures • 30min Create Macros 09:48 Macro Button 04:08 Where Condition 03:34 Require Data Entry Macro 05:08 Display Message Macro 02:29 Automated Macro 05:16 Macros Quiz 6 questions More Advanced Forms & Reports 5 lectures • 30min Conditional Formatting 04:37 Report Charts 04:47 Multiple Columns & Groups 15:04 Cancelling Print Job 03:52 Export to PDF or XPS 01:33 More Advanced Forms & Reports Quiz 5 questions Maintaining Database 8 lectures • 22min Linking to Other Database Tables 04:35 Database Properties 03:09 Compact & Repair Database 01:35 Backup Database 01:21 Password Protect 03:53 Object Dependency 02:19 Database Documenter 03:11 Performace Analyzer 02:23 Maintaining Database Quiz 6 questions Database Integration 9 lectures • 57min Import XML Data 10:55 Export to XML 02:41 Link to Outlook Contacts 04:11 Table Attachment Field 05:01 Save As Previous Version 02:50 Navigation Forms 08:06 Switchboard 10:12 Modifying Switchboards 04:12 Form Startup & Options 08:54 Database Integration Quiz 4 questions Distribute Database & Security 6 lectures • 18min Split Database 05:49 Distributing Split Database 02:29 Database Access Modes 02:44 Trusted Location 02:37 Protect VBA Code 01:56 File Protection ACCDE 02:38 Distribute Database & Security Quiz 4 questions Bonus! 4 lectures • 31min Digitally Sign Database 05:55 Hide Empty Record Labels in Reports 07:04 Create Table of Contents 13:10 Custom Display Control for Text Box 04:50 Bonus! Quiz 4 questions 1 more section 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:'6781a0b40f7c5433',m:'7f8b731bf9b35fff895da02fc99d3f6c024fd0a0-1627847766-1800-ATre4InJAXneyNglbZ09KTz7pAfu1fyvw0qelgIEIlyqJajLNHGA61dbwurYewEQo/AuNJyzWCyZOOOxxknmGCfh3GVNSWoF5iEMMuzzb+QYAE9Og7t30NTIwNrqzz8zb7HFTsCfH51C4sz/mU7sfK7U36MHYFYdYtdL92RkthF6CqcX4RiCYxlB4xMLDFt+jA==',s:[0x6bed3d345b,0x0b605d9b01],}})();
  5. Pull up related records fast using the Where Condition Emphasize data, or records with Conditional Formatting Compact, repair, backup and password protect your database Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements You will need Access installed on your computer to follow along and complete the exercise files Videos have been recorded using Access 2016, but all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 Description Drive Your Microsoft Access Skills to an Advanced Level Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options. Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert. Below are just a few of the topics that you will master: Table normalization and restructuring of poorly designed databases More targeted Query results by using Subqueries Perform summary calculations of intersecting values of row and column headings using Crosstab Queries Automate data entry, based upon certain data entered into other fields, with Automated Macros Alphabetically sort, label, and group records in your Reports How to attach any file including documents and images to a record. How to hide empty Record Labels from displaying and taking up unnecessary space in your Reports and much, much, more… Who this course is for: This Microsoft Access Level 3 course was designed for those looking to advance their Access knowledge and skills to an advanced level, taking advantage of several more advanced Microsoft Access features 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 11 sections • 50 lectures • 4h 14m total length Expand all sections Normalization Standard 1 lecture • 4min Normalization Standard Preview 03:34 Access Level 3 - Advanced 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 More Advanced Tables 4 lectures • 29min Table Analyzer Preview 11:52 Many to Many Relationships 07:21 Restructuring Tables 08:31 Hide Table Columns 01:18 More Advanced Tables Quiz 2 questions More Advanced Queries 5 lectures • 27min Subqueries 05:40 Unmatched Query 04:45 Duplicate Query 02:27 Criteria Groups Query 07:57 Crosstab Query Wizard 05:58 More Advanced Queries Quiz 4 questions Macros 6 lectures • 30min Create Macros 09:48 Macro Button 04:08 Where Condition 03:34 Require Data Entry Macro 05:08 Display Message Macro 02:29 Automated Macro 05:16 Macros Quiz 6 questions More Advanced Forms & Reports 5 lectures • 30min Conditional Formatting 04:37 Report Charts 04:47 Multiple Columns & Groups 15:04 Cancelling Print Job 03:52 Export to PDF or XPS 01:33 More Advanced Forms & Reports Quiz 5 questions Maintaining Database 8 lectures • 22min Linking to Other Database Tables 04:35 Database Properties 03:09 Compact & Repair Database 01:35 Backup Database 01:21 Password Protect 03:53 Object Dependency 02:19 Database Documenter 03:11 Performace Analyzer 02:23 Maintaining Database Quiz 6 questions Database Integration 9 lectures • 57min Import XML Data 10:55 Export to XML 02:41 Link to Outlook Contacts 04:11 Table Attachment Field 05:01 Save As Previous Version 02:50 Navigation Forms 08:06 Switchboard 10:12 Modifying Switchboards 04:12 Form Startup & Options 08:54 Database Integration Quiz 4 questions Distribute Database & Security 6 lectures • 18min Split Database 05:49 Distributing Split Database 02:29 Database Access Modes 02:44 Trusted Location 02:37 Protect VBA Code 01:56 File Protection ACCDE 02:38 Distribute Database & Security Quiz 4 questions Bonus! 4 lectures • 31min Digitally Sign Database 05:55 Hide Empty Record Labels in Reports 07:04 Create Table of Contents 13:10 Custom Display Control for Text Box 04:50 Bonus! Quiz 4 questions 1 more section 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:'6781a0b40f7c5433',m:'7f8b731bf9b35fff895da02fc99d3f6c024fd0a0-1627847766-1800-ATre4InJAXneyNglbZ09KTz7pAfu1fyvw0qelgIEIlyqJajLNHGA61dbwurYewEQo/AuNJyzWCyZOOOxxknmGCfh3GVNSWoF5iEMMuzzb+QYAE9Og7t30NTIwNrqzz8zb7HFTsCfH51C4sz/mU7sfK7U36MHYFYdYtdL92RkthF6CqcX4RiCYxlB4xMLDFt+jA==',s:[0x6bed3d345b,0x0b605d9b01],}})();
  6. Emphasize data, or records with Conditional Formatting Compact, repair, backup and password protect your database Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements You will need Access installed on your computer to follow along and complete the exercise files Videos have been recorded using Access 2016, but all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 Description Drive Your Microsoft Access Skills to an Advanced Level Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options. Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert. Below are just a few of the topics that you will master: Table normalization and restructuring of poorly designed databases More targeted Query results by using Subqueries Perform summary calculations of intersecting values of row and column headings using Crosstab Queries Automate data entry, based upon certain data entered into other fields, with Automated Macros Alphabetically sort, label, and group records in your Reports How to attach any file including documents and images to a record. How to hide empty Record Labels from displaying and taking up unnecessary space in your Reports and much, much, more… Who this course is for: This Microsoft Access Level 3 course was designed for those looking to advance their Access knowledge and skills to an advanced level, taking advantage of several more advanced Microsoft Access features 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 11 sections • 50 lectures • 4h 14m total length Expand all sections Normalization Standard 1 lecture • 4min Normalization Standard Preview 03:34 Access Level 3 - Advanced 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 More Advanced Tables 4 lectures • 29min Table Analyzer Preview 11:52 Many to Many Relationships 07:21 Restructuring Tables 08:31 Hide Table Columns 01:18 More Advanced Tables Quiz 2 questions More Advanced Queries 5 lectures • 27min Subqueries 05:40 Unmatched Query 04:45 Duplicate Query 02:27 Criteria Groups Query 07:57 Crosstab Query Wizard 05:58 More Advanced Queries Quiz 4 questions Macros 6 lectures • 30min Create Macros 09:48 Macro Button 04:08 Where Condition 03:34 Require Data Entry Macro 05:08 Display Message Macro 02:29 Automated Macro 05:16 Macros Quiz 6 questions More Advanced Forms & Reports 5 lectures • 30min Conditional Formatting 04:37 Report Charts 04:47 Multiple Columns & Groups 15:04 Cancelling Print Job 03:52 Export to PDF or XPS 01:33 More Advanced Forms & Reports Quiz 5 questions Maintaining Database 8 lectures • 22min Linking to Other Database Tables 04:35 Database Properties 03:09 Compact & Repair Database 01:35 Backup Database 01:21 Password Protect 03:53 Object Dependency 02:19 Database Documenter 03:11 Performace Analyzer 02:23 Maintaining Database Quiz 6 questions Database Integration 9 lectures • 57min Import XML Data 10:55 Export to XML 02:41 Link to Outlook Contacts 04:11 Table Attachment Field 05:01 Save As Previous Version 02:50 Navigation Forms 08:06 Switchboard 10:12 Modifying Switchboards 04:12 Form Startup & Options 08:54 Database Integration Quiz 4 questions Distribute Database & Security 6 lectures • 18min Split Database 05:49 Distributing Split Database 02:29 Database Access Modes 02:44 Trusted Location 02:37 Protect VBA Code 01:56 File Protection ACCDE 02:38 Distribute Database & Security Quiz 4 questions Bonus! 4 lectures • 31min Digitally Sign Database 05:55 Hide Empty Record Labels in Reports 07:04 Create Table of Contents 13:10 Custom Display Control for Text Box 04:50 Bonus! Quiz 4 questions 1 more section 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:'6781a0b40f7c5433',m:'7f8b731bf9b35fff895da02fc99d3f6c024fd0a0-1627847766-1800-ATre4InJAXneyNglbZ09KTz7pAfu1fyvw0qelgIEIlyqJajLNHGA61dbwurYewEQo/AuNJyzWCyZOOOxxknmGCfh3GVNSWoF5iEMMuzzb+QYAE9Og7t30NTIwNrqzz8zb7HFTsCfH51C4sz/mU7sfK7U36MHYFYdYtdL92RkthF6CqcX4RiCYxlB4xMLDFt+jA==',s:[0x6bed3d345b,0x0b605d9b01],}})();
  7. Compact, repair, backup and password protect your database Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements You will need Access installed on your computer to follow along and complete the exercise files Videos have been recorded using Access 2016, but all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 Description Drive Your Microsoft Access Skills to an Advanced Level Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options. Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert. Below are just a few of the topics that you will master: Table normalization and restructuring of poorly designed databases More targeted Query results by using Subqueries Perform summary calculations of intersecting values of row and column headings using Crosstab Queries Automate data entry, based upon certain data entered into other fields, with Automated Macros Alphabetically sort, label, and group records in your Reports How to attach any file including documents and images to a record. How to hide empty Record Labels from displaying and taking up unnecessary space in your Reports and much, much, more… Who this course is for: This Microsoft Access Level 3 course was designed for those looking to advance their Access knowledge and skills to an advanced level, taking advantage of several more advanced Microsoft Access features 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 11 sections • 50 lectures • 4h 14m total length Expand all sections Normalization Standard 1 lecture • 4min Normalization Standard Preview 03:34 Access Level 3 - Advanced 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 More Advanced Tables 4 lectures • 29min Table Analyzer Preview 11:52 Many to Many Relationships 07:21 Restructuring Tables 08:31 Hide Table Columns 01:18 More Advanced Tables Quiz 2 questions More Advanced Queries 5 lectures • 27min Subqueries 05:40 Unmatched Query 04:45 Duplicate Query 02:27 Criteria Groups Query 07:57 Crosstab Query Wizard 05:58 More Advanced Queries Quiz 4 questions Macros 6 lectures • 30min Create Macros 09:48 Macro Button 04:08 Where Condition 03:34 Require Data Entry Macro 05:08 Display Message Macro 02:29 Automated Macro 05:16 Macros Quiz 6 questions More Advanced Forms & Reports 5 lectures • 30min Conditional Formatting 04:37 Report Charts 04:47 Multiple Columns & Groups 15:04 Cancelling Print Job 03:52 Export to PDF or XPS 01:33 More Advanced Forms & Reports Quiz 5 questions Maintaining Database 8 lectures • 22min Linking to Other Database Tables 04:35 Database Properties 03:09 Compact & Repair Database 01:35 Backup Database 01:21 Password Protect 03:53 Object Dependency 02:19 Database Documenter 03:11 Performace Analyzer 02:23 Maintaining Database Quiz 6 questions Database Integration 9 lectures • 57min Import XML Data 10:55 Export to XML 02:41 Link to Outlook Contacts 04:11 Table Attachment Field 05:01 Save As Previous Version 02:50 Navigation Forms 08:06 Switchboard 10:12 Modifying Switchboards 04:12 Form Startup & Options 08:54 Database Integration Quiz 4 questions Distribute Database & Security 6 lectures • 18min Split Database 05:49 Distributing Split Database 02:29 Database Access Modes 02:44 Trusted Location 02:37 Protect VBA Code 01:56 File Protection ACCDE 02:38 Distribute Database & Security Quiz 4 questions Bonus! 4 lectures • 31min Digitally Sign Database 05:55 Hide Empty Record Labels in Reports 07:04 Create Table of Contents 13:10 Custom Display Control for Text Box 04:50 Bonus! Quiz 4 questions 1 more section 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:'6781a0b40f7c5433',m:'7f8b731bf9b35fff895da02fc99d3f6c024fd0a0-1627847766-1800-ATre4InJAXneyNglbZ09KTz7pAfu1fyvw0qelgIEIlyqJajLNHGA61dbwurYewEQo/AuNJyzWCyZOOOxxknmGCfh3GVNSWoF5iEMMuzzb+QYAE9Og7t30NTIwNrqzz8zb7HFTsCfH51C4sz/mU7sfK7U36MHYFYdYtdL92RkthF6CqcX4RiCYxlB4xMLDFt+jA==',s:[0x6bed3d345b,0x0b605d9b01],}})();
  8. Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training Requirements You will need Access installed on your computer to follow along and complete the exercise files Videos have been recorded using Access 2016, but all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007 Description Drive Your Microsoft Access Skills to an Advanced Level Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options. Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert. Below are just a few of the topics that you will master: Table normalization and restructuring of poorly designed databases More targeted Query results by using Subqueries Perform summary calculations of intersecting values of row and column headings using Crosstab Queries Automate data entry, based upon certain data entered into other fields, with Automated Macros Alphabetically sort, label, and group records in your Reports How to attach any file including documents and images to a record. How to hide empty Record Labels from displaying and taking up unnecessary space in your Reports and much, much, more… Who this course is for: This Microsoft Access Level 3 course was designed for those looking to advance their Access knowledge and skills to an advanced level, taking advantage of several more advanced Microsoft Access features 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 11 sections • 50 lectures • 4h 14m total length Expand all sections Normalization Standard 1 lecture • 4min Normalization Standard Preview 03:34 Access Level 3 - Advanced 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 More Advanced Tables 4 lectures • 29min Table Analyzer Preview 11:52 Many to Many Relationships 07:21 Restructuring Tables 08:31 Hide Table Columns 01:18 More Advanced Tables Quiz 2 questions More Advanced Queries 5 lectures • 27min Subqueries 05:40 Unmatched Query 04:45 Duplicate Query 02:27 Criteria Groups Query 07:57 Crosstab Query Wizard 05:58 More Advanced Queries Quiz 4 questions Macros 6 lectures • 30min Create Macros 09:48 Macro Button 04:08 Where Condition 03:34 Require Data Entry Macro 05:08 Display Message Macro 02:29 Automated Macro 05:16 Macros Quiz 6 questions More Advanced Forms & Reports 5 lectures • 30min Conditional Formatting 04:37 Report Charts 04:47 Multiple Columns & Groups 15:04 Cancelling Print Job 03:52 Export to PDF or XPS 01:33 More Advanced Forms & Reports Quiz 5 questions Maintaining Database 8 lectures • 22min Linking to Other Database Tables 04:35 Database Properties 03:09 Compact & Repair Database 01:35 Backup Database 01:21 Password Protect 03:53 Object Dependency 02:19 Database Documenter 03:11 Performace Analyzer 02:23 Maintaining Database Quiz 6 questions Database Integration 9 lectures • 57min Import XML Data 10:55 Export to XML 02:41 Link to Outlook Contacts 04:11 Table Attachment Field 05:01 Save As Previous Version 02:50 Navigation Forms 08:06 Switchboard 10:12 Modifying Switchboards 04:12 Form Startup & Options 08:54 Database Integration Quiz 4 questions Distribute Database & Security 6 lectures • 18min Split Database 05:49 Distributing Split Database 02:29 Database Access Modes 02:44 Trusted Location 02:37 Protect VBA Code 01:56 File Protection ACCDE 02:38 Distribute Database & Security Quiz 4 questions Bonus! 4 lectures • 31min Digitally Sign Database 05:55 Hide Empty Record Labels in Reports 07:04 Create Table of Contents 13:10 Custom Display Control for Text Box 04:50 Bonus! Quiz 4 questions 1 more section 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:'6781a0b40f7c5433',m:'7f8b731bf9b35fff895da02fc99d3f6c024fd0a0-1627847766-1800-ATre4InJAXneyNglbZ09KTz7pAfu1fyvw0qelgIEIlyqJajLNHGA61dbwurYewEQo/AuNJyzWCyZOOOxxknmGCfh3GVNSWoF5iEMMuzzb+QYAE9Og7t30NTIwNrqzz8zb7HFTsCfH51C4sz/mU7sfK7U36MHYFYdYtdL92RkthF6CqcX4RiCYxlB4xMLDFt+jA==',s:[0x6bed3d345b,0x0b605d9b01],}})();