Microsoft Access Level 1 - Beginner Access

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

Course Description

Quickly Get a Solid Foundation on Access Basics

During this Microsoft Access Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Access experience on. Enroll now and I'll guide you step-by-step, through the basics of creating relational databases and working with Tables, Queries, Forms and Reports. In very little time you will master the basics of Access that'll provide a sure foundation for more advanced Access techniques.

At completion of this course you will have mastered the most popular Access basic tools and have the foundational skills with a sureness to complete many daily Access tasks with efficiency and ease. Below are just a few of the topics that you will master in Access:

  • Build a solid understanding on the basics of Microsoft Access

  • Step by step in creating Microsoft Access Databases

  • Create Tables and how to enter, filter and sort Records

  • Create Primary, Composite and Foreign keys to link Tables

  • How to create relationships One-to-One and One-to-Many

  • Create a Query and how to add calculating fields

  • Create Forms to view records in a more organized layout

  • Use Reports to display your records in printable and/or email formats

Who this course is for:

  • This Microsoft Access Beginner Level 1 course is for anyone who is just starting out in Access
  • For those who’ve used Access, but want to find out some little-known tips, tricks and shortcuts and become more efficient
  • 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 create an Access Database from scratch Create Tables to store and organize all raw data Use a Query to search and retrieve data fast Enter and view records in a more organized layout using Forms Generate very detailed, professional looking Reports 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 Quickly Get a Solid Foundation on Access Basics During this Microsoft Access Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Access experience on. Enroll now and I'll guide you step-by-step, through the basics of creating relational databases and working with Tables, Queries, Forms and Reports. In very little time you will master the basics of Access that'll provide a sure foundation for more advanced Access techniques. At completion of this course you will have mastered the most popular Access basic tools and have the foundational skills with a sureness to complete many daily Access tasks with efficiency and ease. Below are just a few of the topics that you will master in Access: Build a solid understanding on the basics of Microsoft Access Step by step in creating Microsoft Access Databases Create Tables and how to enter, filter and sort Records Create Primary, Composite and Foreign keys to link Tables How to create relationships One-to-One and One-to-Many Create a Query and how to add calculating fields Create Forms to view records in a more organized layout Use Reports to display your records in printable and/or email formats Who this course is for: This Microsoft Access Beginner Level 1 course is for anyone who is just starting out in Access For those who’ve used Access, but want to find out some little-known tips, tricks and shortcuts and become more efficient 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 Featured review Clayton Reed 137 courses 9 reviews Rating: 5.0 out of 5 a year ago Great Course and Outstanding Instructor! The instructor does an outstanding job at covering the material. He was very thorough and kept the training fun. This is the first of three Access courses that I purchased from him and I am looking forward to taking the other two courses. Thank you Kirt for the professional Access training. Show more Show less Course content 8 sections • 46 lectures • 7h 32m total length Expand all sections Access Introduction 1 lecture • 13min Introduction Preview 13:20 Access Level 1 - Beginner 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Basics 9 lectures • 1hr 6min Access Overview - First Look Preview 13:34 New Tell Me What You Want Or Help Feature Preview 01:48 Change Office Theme Preview 04:40 Quick Access Toolbar Preview 07:02 Customize Ribbon Preview 09:01 Datasheet Appearance Preview 01:46 Document Window Options Preview 07:25 Basic Introduction to Tables, Queries, Forms & Reports Preview 13:41 Create a New Database Preview 06:41 Basics Quiz 9 questions Tables 14 lectures • 2hr 35min Creating Tables 23:18 Entering Records in Tables 04:35 Export Table to XPS or PDF 03:31 Table Structuring 09:31 Tips for Managing Tables 05:25 Basics on Primary, Composite & Foreign Keys 13:51 Basic Introduction Setting Up Tables for Relationships 07:35 Create One-to-Many Relationships 17:48 Create One-to-One Relationships 13:29 Denormalization or Denormalize 13:32 Managing Table Data 15:03 Sorting Records 05:11 Filtering Records 10:03 Subdatasheets 11:43 Tables Quiz 17 questions Queries 6 lectures • 1hr 12min Query Wizard 19:22 Basics on Creating a Query in Design View 12:15 Setting Query Criteria 20:58 Add a Calculating Field 07:33 Grouping Records & Totals 08:15 Customize Table or Query Datasheet 03:39 Queries Quiz 6 questions Forms 4 lectures • 52min Basic Introduction to Forms 18:42 Create Forms Instantly 12:06 Form Wizard 05:58 How to Modify & Edit Forms 14:49 Forms Quiz 4 questions Reports 10 lectures • 1hr 29min Report Views 08:11 How to Create Instant Reports 08:48 Step by Step Report Wizard 10:37 Ceate Custom Calculating Fields 22:19 Formatting Controls 06:16 Applying Themes 05:29 Inserting Images 07:41 Insert Background Images & Watermarks 09:27 Inserting Hyperlinks 04:07 Microsoft Access 2016 Reports: Prepare for Print 06:31 Reports Quiz 8 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:'678180198fd95463',m:'ef02b24cf5b7245ef1ba96ea5949b975d9dad035-1627846431-1800-Af2FdVw6VJqznhwCuEObCC7FDzcokk4p14Fk2rOsEgSDO3/0/t4fm2yoyKiwRCZ16xsfdYuumgGlYkeLARfzHJXsISNXumBEvmBvtEAELFpJeQOk096eqLaTGufA0Yz3M735Mny/7oUJDwLMLKHjr8j2m3Q99q2ynq/AJc6XMGUW',s:[0x9243c1295c,0x8865e6f25e],}})();
  2. Create Tables to store and organize all raw data Use a Query to search and retrieve data fast Enter and view records in a more organized layout using Forms Generate very detailed, professional looking Reports 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 Quickly Get a Solid Foundation on Access Basics During this Microsoft Access Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Access experience on. Enroll now and I'll guide you step-by-step, through the basics of creating relational databases and working with Tables, Queries, Forms and Reports. In very little time you will master the basics of Access that'll provide a sure foundation for more advanced Access techniques. At completion of this course you will have mastered the most popular Access basic tools and have the foundational skills with a sureness to complete many daily Access tasks with efficiency and ease. Below are just a few of the topics that you will master in Access: Build a solid understanding on the basics of Microsoft Access Step by step in creating Microsoft Access Databases Create Tables and how to enter, filter and sort Records Create Primary, Composite and Foreign keys to link Tables How to create relationships One-to-One and One-to-Many Create a Query and how to add calculating fields Create Forms to view records in a more organized layout Use Reports to display your records in printable and/or email formats Who this course is for: This Microsoft Access Beginner Level 1 course is for anyone who is just starting out in Access For those who’ve used Access, but want to find out some little-known tips, tricks and shortcuts and become more efficient 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 Featured review Clayton Reed 137 courses 9 reviews Rating: 5.0 out of 5 a year ago Great Course and Outstanding Instructor! The instructor does an outstanding job at covering the material. He was very thorough and kept the training fun. This is the first of three Access courses that I purchased from him and I am looking forward to taking the other two courses. Thank you Kirt for the professional Access training. Show more Show less Course content 8 sections • 46 lectures • 7h 32m total length Expand all sections Access Introduction 1 lecture • 13min Introduction Preview 13:20 Access Level 1 - Beginner 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Basics 9 lectures • 1hr 6min Access Overview - First Look Preview 13:34 New Tell Me What You Want Or Help Feature Preview 01:48 Change Office Theme Preview 04:40 Quick Access Toolbar Preview 07:02 Customize Ribbon Preview 09:01 Datasheet Appearance Preview 01:46 Document Window Options Preview 07:25 Basic Introduction to Tables, Queries, Forms & Reports Preview 13:41 Create a New Database Preview 06:41 Basics Quiz 9 questions Tables 14 lectures • 2hr 35min Creating Tables 23:18 Entering Records in Tables 04:35 Export Table to XPS or PDF 03:31 Table Structuring 09:31 Tips for Managing Tables 05:25 Basics on Primary, Composite & Foreign Keys 13:51 Basic Introduction Setting Up Tables for Relationships 07:35 Create One-to-Many Relationships 17:48 Create One-to-One Relationships 13:29 Denormalization or Denormalize 13:32 Managing Table Data 15:03 Sorting Records 05:11 Filtering Records 10:03 Subdatasheets 11:43 Tables Quiz 17 questions Queries 6 lectures • 1hr 12min Query Wizard 19:22 Basics on Creating a Query in Design View 12:15 Setting Query Criteria 20:58 Add a Calculating Field 07:33 Grouping Records & Totals 08:15 Customize Table or Query Datasheet 03:39 Queries Quiz 6 questions Forms 4 lectures • 52min Basic Introduction to Forms 18:42 Create Forms Instantly 12:06 Form Wizard 05:58 How to Modify & Edit Forms 14:49 Forms Quiz 4 questions Reports 10 lectures • 1hr 29min Report Views 08:11 How to Create Instant Reports 08:48 Step by Step Report Wizard 10:37 Ceate Custom Calculating Fields 22:19 Formatting Controls 06:16 Applying Themes 05:29 Inserting Images 07:41 Insert Background Images & Watermarks 09:27 Inserting Hyperlinks 04:07 Microsoft Access 2016 Reports: Prepare for Print 06:31 Reports Quiz 8 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:'678180198fd95463',m:'ef02b24cf5b7245ef1ba96ea5949b975d9dad035-1627846431-1800-Af2FdVw6VJqznhwCuEObCC7FDzcokk4p14Fk2rOsEgSDO3/0/t4fm2yoyKiwRCZ16xsfdYuumgGlYkeLARfzHJXsISNXumBEvmBvtEAELFpJeQOk096eqLaTGufA0Yz3M735Mny/7oUJDwLMLKHjr8j2m3Q99q2ynq/AJc6XMGUW',s:[0x9243c1295c,0x8865e6f25e],}})();
  3. Use a Query to search and retrieve data fast Enter and view records in a more organized layout using Forms Generate very detailed, professional looking Reports 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 Quickly Get a Solid Foundation on Access Basics During this Microsoft Access Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Access experience on. Enroll now and I'll guide you step-by-step, through the basics of creating relational databases and working with Tables, Queries, Forms and Reports. In very little time you will master the basics of Access that'll provide a sure foundation for more advanced Access techniques. At completion of this course you will have mastered the most popular Access basic tools and have the foundational skills with a sureness to complete many daily Access tasks with efficiency and ease. Below are just a few of the topics that you will master in Access: Build a solid understanding on the basics of Microsoft Access Step by step in creating Microsoft Access Databases Create Tables and how to enter, filter and sort Records Create Primary, Composite and Foreign keys to link Tables How to create relationships One-to-One and One-to-Many Create a Query and how to add calculating fields Create Forms to view records in a more organized layout Use Reports to display your records in printable and/or email formats Who this course is for: This Microsoft Access Beginner Level 1 course is for anyone who is just starting out in Access For those who’ve used Access, but want to find out some little-known tips, tricks and shortcuts and become more efficient 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 Featured review Clayton Reed 137 courses 9 reviews Rating: 5.0 out of 5 a year ago Great Course and Outstanding Instructor! The instructor does an outstanding job at covering the material. He was very thorough and kept the training fun. This is the first of three Access courses that I purchased from him and I am looking forward to taking the other two courses. Thank you Kirt for the professional Access training. Show more Show less Course content 8 sections • 46 lectures • 7h 32m total length Expand all sections Access Introduction 1 lecture • 13min Introduction Preview 13:20 Access Level 1 - Beginner 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Basics 9 lectures • 1hr 6min Access Overview - First Look Preview 13:34 New Tell Me What You Want Or Help Feature Preview 01:48 Change Office Theme Preview 04:40 Quick Access Toolbar Preview 07:02 Customize Ribbon Preview 09:01 Datasheet Appearance Preview 01:46 Document Window Options Preview 07:25 Basic Introduction to Tables, Queries, Forms & Reports Preview 13:41 Create a New Database Preview 06:41 Basics Quiz 9 questions Tables 14 lectures • 2hr 35min Creating Tables 23:18 Entering Records in Tables 04:35 Export Table to XPS or PDF 03:31 Table Structuring 09:31 Tips for Managing Tables 05:25 Basics on Primary, Composite & Foreign Keys 13:51 Basic Introduction Setting Up Tables for Relationships 07:35 Create One-to-Many Relationships 17:48 Create One-to-One Relationships 13:29 Denormalization or Denormalize 13:32 Managing Table Data 15:03 Sorting Records 05:11 Filtering Records 10:03 Subdatasheets 11:43 Tables Quiz 17 questions Queries 6 lectures • 1hr 12min Query Wizard 19:22 Basics on Creating a Query in Design View 12:15 Setting Query Criteria 20:58 Add a Calculating Field 07:33 Grouping Records & Totals 08:15 Customize Table or Query Datasheet 03:39 Queries Quiz 6 questions Forms 4 lectures • 52min Basic Introduction to Forms 18:42 Create Forms Instantly 12:06 Form Wizard 05:58 How to Modify & Edit Forms 14:49 Forms Quiz 4 questions Reports 10 lectures • 1hr 29min Report Views 08:11 How to Create Instant Reports 08:48 Step by Step Report Wizard 10:37 Ceate Custom Calculating Fields 22:19 Formatting Controls 06:16 Applying Themes 05:29 Inserting Images 07:41 Insert Background Images & Watermarks 09:27 Inserting Hyperlinks 04:07 Microsoft Access 2016 Reports: Prepare for Print 06:31 Reports Quiz 8 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:'678180198fd95463',m:'ef02b24cf5b7245ef1ba96ea5949b975d9dad035-1627846431-1800-Af2FdVw6VJqznhwCuEObCC7FDzcokk4p14Fk2rOsEgSDO3/0/t4fm2yoyKiwRCZ16xsfdYuumgGlYkeLARfzHJXsISNXumBEvmBvtEAELFpJeQOk096eqLaTGufA0Yz3M735Mny/7oUJDwLMLKHjr8j2m3Q99q2ynq/AJc6XMGUW',s:[0x9243c1295c,0x8865e6f25e],}})();
  4. Enter and view records in a more organized layout using Forms Generate very detailed, professional looking Reports 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 Quickly Get a Solid Foundation on Access Basics During this Microsoft Access Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Access experience on. Enroll now and I'll guide you step-by-step, through the basics of creating relational databases and working with Tables, Queries, Forms and Reports. In very little time you will master the basics of Access that'll provide a sure foundation for more advanced Access techniques. At completion of this course you will have mastered the most popular Access basic tools and have the foundational skills with a sureness to complete many daily Access tasks with efficiency and ease. Below are just a few of the topics that you will master in Access: Build a solid understanding on the basics of Microsoft Access Step by step in creating Microsoft Access Databases Create Tables and how to enter, filter and sort Records Create Primary, Composite and Foreign keys to link Tables How to create relationships One-to-One and One-to-Many Create a Query and how to add calculating fields Create Forms to view records in a more organized layout Use Reports to display your records in printable and/or email formats Who this course is for: This Microsoft Access Beginner Level 1 course is for anyone who is just starting out in Access For those who’ve used Access, but want to find out some little-known tips, tricks and shortcuts and become more efficient 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 Featured review Clayton Reed 137 courses 9 reviews Rating: 5.0 out of 5 a year ago Great Course and Outstanding Instructor! The instructor does an outstanding job at covering the material. He was very thorough and kept the training fun. This is the first of three Access courses that I purchased from him and I am looking forward to taking the other two courses. Thank you Kirt for the professional Access training. Show more Show less Course content 8 sections • 46 lectures • 7h 32m total length Expand all sections Access Introduction 1 lecture • 13min Introduction Preview 13:20 Access Level 1 - Beginner 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Basics 9 lectures • 1hr 6min Access Overview - First Look Preview 13:34 New Tell Me What You Want Or Help Feature Preview 01:48 Change Office Theme Preview 04:40 Quick Access Toolbar Preview 07:02 Customize Ribbon Preview 09:01 Datasheet Appearance Preview 01:46 Document Window Options Preview 07:25 Basic Introduction to Tables, Queries, Forms & Reports Preview 13:41 Create a New Database Preview 06:41 Basics Quiz 9 questions Tables 14 lectures • 2hr 35min Creating Tables 23:18 Entering Records in Tables 04:35 Export Table to XPS or PDF 03:31 Table Structuring 09:31 Tips for Managing Tables 05:25 Basics on Primary, Composite & Foreign Keys 13:51 Basic Introduction Setting Up Tables for Relationships 07:35 Create One-to-Many Relationships 17:48 Create One-to-One Relationships 13:29 Denormalization or Denormalize 13:32 Managing Table Data 15:03 Sorting Records 05:11 Filtering Records 10:03 Subdatasheets 11:43 Tables Quiz 17 questions Queries 6 lectures • 1hr 12min Query Wizard 19:22 Basics on Creating a Query in Design View 12:15 Setting Query Criteria 20:58 Add a Calculating Field 07:33 Grouping Records & Totals 08:15 Customize Table or Query Datasheet 03:39 Queries Quiz 6 questions Forms 4 lectures • 52min Basic Introduction to Forms 18:42 Create Forms Instantly 12:06 Form Wizard 05:58 How to Modify & Edit Forms 14:49 Forms Quiz 4 questions Reports 10 lectures • 1hr 29min Report Views 08:11 How to Create Instant Reports 08:48 Step by Step Report Wizard 10:37 Ceate Custom Calculating Fields 22:19 Formatting Controls 06:16 Applying Themes 05:29 Inserting Images 07:41 Insert Background Images & Watermarks 09:27 Inserting Hyperlinks 04:07 Microsoft Access 2016 Reports: Prepare for Print 06:31 Reports Quiz 8 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:'678180198fd95463',m:'ef02b24cf5b7245ef1ba96ea5949b975d9dad035-1627846431-1800-Af2FdVw6VJqznhwCuEObCC7FDzcokk4p14Fk2rOsEgSDO3/0/t4fm2yoyKiwRCZ16xsfdYuumgGlYkeLARfzHJXsISNXumBEvmBvtEAELFpJeQOk096eqLaTGufA0Yz3M735Mny/7oUJDwLMLKHjr8j2m3Q99q2ynq/AJc6XMGUW',s:[0x9243c1295c,0x8865e6f25e],}})();
  5. Generate very detailed, professional looking Reports 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 Quickly Get a Solid Foundation on Access Basics During this Microsoft Access Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Access experience on. Enroll now and I'll guide you step-by-step, through the basics of creating relational databases and working with Tables, Queries, Forms and Reports. In very little time you will master the basics of Access that'll provide a sure foundation for more advanced Access techniques. At completion of this course you will have mastered the most popular Access basic tools and have the foundational skills with a sureness to complete many daily Access tasks with efficiency and ease. Below are just a few of the topics that you will master in Access: Build a solid understanding on the basics of Microsoft Access Step by step in creating Microsoft Access Databases Create Tables and how to enter, filter and sort Records Create Primary, Composite and Foreign keys to link Tables How to create relationships One-to-One and One-to-Many Create a Query and how to add calculating fields Create Forms to view records in a more organized layout Use Reports to display your records in printable and/or email formats Who this course is for: This Microsoft Access Beginner Level 1 course is for anyone who is just starting out in Access For those who’ve used Access, but want to find out some little-known tips, tricks and shortcuts and become more efficient 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 Featured review Clayton Reed 137 courses 9 reviews Rating: 5.0 out of 5 a year ago Great Course and Outstanding Instructor! The instructor does an outstanding job at covering the material. He was very thorough and kept the training fun. This is the first of three Access courses that I purchased from him and I am looking forward to taking the other two courses. Thank you Kirt for the professional Access training. Show more Show less Course content 8 sections • 46 lectures • 7h 32m total length Expand all sections Access Introduction 1 lecture • 13min Introduction Preview 13:20 Access Level 1 - Beginner 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Basics 9 lectures • 1hr 6min Access Overview - First Look Preview 13:34 New Tell Me What You Want Or Help Feature Preview 01:48 Change Office Theme Preview 04:40 Quick Access Toolbar Preview 07:02 Customize Ribbon Preview 09:01 Datasheet Appearance Preview 01:46 Document Window Options Preview 07:25 Basic Introduction to Tables, Queries, Forms & Reports Preview 13:41 Create a New Database Preview 06:41 Basics Quiz 9 questions Tables 14 lectures • 2hr 35min Creating Tables 23:18 Entering Records in Tables 04:35 Export Table to XPS or PDF 03:31 Table Structuring 09:31 Tips for Managing Tables 05:25 Basics on Primary, Composite & Foreign Keys 13:51 Basic Introduction Setting Up Tables for Relationships 07:35 Create One-to-Many Relationships 17:48 Create One-to-One Relationships 13:29 Denormalization or Denormalize 13:32 Managing Table Data 15:03 Sorting Records 05:11 Filtering Records 10:03 Subdatasheets 11:43 Tables Quiz 17 questions Queries 6 lectures • 1hr 12min Query Wizard 19:22 Basics on Creating a Query in Design View 12:15 Setting Query Criteria 20:58 Add a Calculating Field 07:33 Grouping Records & Totals 08:15 Customize Table or Query Datasheet 03:39 Queries Quiz 6 questions Forms 4 lectures • 52min Basic Introduction to Forms 18:42 Create Forms Instantly 12:06 Form Wizard 05:58 How to Modify & Edit Forms 14:49 Forms Quiz 4 questions Reports 10 lectures • 1hr 29min Report Views 08:11 How to Create Instant Reports 08:48 Step by Step Report Wizard 10:37 Ceate Custom Calculating Fields 22:19 Formatting Controls 06:16 Applying Themes 05:29 Inserting Images 07:41 Insert Background Images & Watermarks 09:27 Inserting Hyperlinks 04:07 Microsoft Access 2016 Reports: Prepare for Print 06:31 Reports Quiz 8 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:'678180198fd95463',m:'ef02b24cf5b7245ef1ba96ea5949b975d9dad035-1627846431-1800-Af2FdVw6VJqznhwCuEObCC7FDzcokk4p14Fk2rOsEgSDO3/0/t4fm2yoyKiwRCZ16xsfdYuumgGlYkeLARfzHJXsISNXumBEvmBvtEAELFpJeQOk096eqLaTGufA0Yz3M735Mny/7oUJDwLMLKHjr8j2m3Q99q2ynq/AJc6XMGUW',s:[0x9243c1295c,0x8865e6f25e],}})();
  6. 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 Quickly Get a Solid Foundation on Access Basics During this Microsoft Access Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Access experience on. Enroll now and I'll guide you step-by-step, through the basics of creating relational databases and working with Tables, Queries, Forms and Reports. In very little time you will master the basics of Access that'll provide a sure foundation for more advanced Access techniques. At completion of this course you will have mastered the most popular Access basic tools and have the foundational skills with a sureness to complete many daily Access tasks with efficiency and ease. Below are just a few of the topics that you will master in Access: Build a solid understanding on the basics of Microsoft Access Step by step in creating Microsoft Access Databases Create Tables and how to enter, filter and sort Records Create Primary, Composite and Foreign keys to link Tables How to create relationships One-to-One and One-to-Many Create a Query and how to add calculating fields Create Forms to view records in a more organized layout Use Reports to display your records in printable and/or email formats Who this course is for: This Microsoft Access Beginner Level 1 course is for anyone who is just starting out in Access For those who’ve used Access, but want to find out some little-known tips, tricks and shortcuts and become more efficient 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 Featured review Clayton Reed 137 courses 9 reviews Rating: 5.0 out of 5 a year ago Great Course and Outstanding Instructor! The instructor does an outstanding job at covering the material. He was very thorough and kept the training fun. This is the first of three Access courses that I purchased from him and I am looking forward to taking the other two courses. Thank you Kirt for the professional Access training. Show more Show less Course content 8 sections • 46 lectures • 7h 32m total length Expand all sections Access Introduction 1 lecture • 13min Introduction Preview 13:20 Access Level 1 - Beginner 1 lecture • 6min Exercise Files, Instructor's Notes, Quiz & Answers 05:58 Basics 9 lectures • 1hr 6min Access Overview - First Look Preview 13:34 New Tell Me What You Want Or Help Feature Preview 01:48 Change Office Theme Preview 04:40 Quick Access Toolbar Preview 07:02 Customize Ribbon Preview 09:01 Datasheet Appearance Preview 01:46 Document Window Options Preview 07:25 Basic Introduction to Tables, Queries, Forms & Reports Preview 13:41 Create a New Database Preview 06:41 Basics Quiz 9 questions Tables 14 lectures • 2hr 35min Creating Tables 23:18 Entering Records in Tables 04:35 Export Table to XPS or PDF 03:31 Table Structuring 09:31 Tips for Managing Tables 05:25 Basics on Primary, Composite & Foreign Keys 13:51 Basic Introduction Setting Up Tables for Relationships 07:35 Create One-to-Many Relationships 17:48 Create One-to-One Relationships 13:29 Denormalization or Denormalize 13:32 Managing Table Data 15:03 Sorting Records 05:11 Filtering Records 10:03 Subdatasheets 11:43 Tables Quiz 17 questions Queries 6 lectures • 1hr 12min Query Wizard 19:22 Basics on Creating a Query in Design View 12:15 Setting Query Criteria 20:58 Add a Calculating Field 07:33 Grouping Records & Totals 08:15 Customize Table or Query Datasheet 03:39 Queries Quiz 6 questions Forms 4 lectures • 52min Basic Introduction to Forms 18:42 Create Forms Instantly 12:06 Form Wizard 05:58 How to Modify & Edit Forms 14:49 Forms Quiz 4 questions Reports 10 lectures • 1hr 29min Report Views 08:11 How to Create Instant Reports 08:48 Step by Step Report Wizard 10:37 Ceate Custom Calculating Fields 22:19 Formatting Controls 06:16 Applying Themes 05:29 Inserting Images 07:41 Insert Background Images & Watermarks 09:27 Inserting Hyperlinks 04:07 Microsoft Access 2016 Reports: Prepare for Print 06:31 Reports Quiz 8 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:'678180198fd95463',m:'ef02b24cf5b7245ef1ba96ea5949b975d9dad035-1627846431-1800-Af2FdVw6VJqznhwCuEObCC7FDzcokk4p14Fk2rOsEgSDO3/0/t4fm2yoyKiwRCZ16xsfdYuumgGlYkeLARfzHJXsISNXumBEvmBvtEAELFpJeQOk096eqLaTGufA0Yz3M735Mny/7oUJDwLMLKHjr8j2m3Q99q2ynq/AJc6XMGUW',s:[0x9243c1295c,0x8865e6f25e],}})();