Excel to Access: Intro to Microsoft Access for Excel Users

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

Course Description

Learn more than the basic structures in Access. Learn the concepts underneath and how they relate to and work wth Excel. Learn Access from an instructor with years of experience teaching Access and creating custom databases for businesses.

From a recent Student Review:

5 Stars - I finally have a grasp of Access and relational databases!

Thanks to Bruce's course, I can confidently say I have a good grasp of what Microsoft Access is, how to use it effectively and how it differs from Microsoft Excel.

Bruce is clear and concise in his lectures. I enjoyed the hands-on/real world example style of teaching with downloadable Access & Excel files. - Joey Sullivan

You will build a strong foundation in Access by understanding the logic behind its structure:

  • Create tables and learn how to properly structure them.
  • Extensive Training on ALL types of queries.
  • Create reports from scratch instead of relying on wizards.
  • Learn how to create advanced reports based on queries.
  • Learn everything you need to know to build powerful and attractive forms.
  • Build subforms and learn how to move in and out of them.
  • Learn about simple macros.
  • Make basic command buttons in forms.
  • Learn a simple way to make multi value lookups on forms.

Another Student Review:

5 Stars - Fantastic Course!

I have been trying to come to grips with Access for some time now, but each time I became frustrated and eventually gave up. This course is structured in a way that gripped my interest and motivated me to complete it. Bruce has extensive knowledge and the way that he presents the material, makes it easy to follow and understand and it is a very valuable resource. - John Ovens

These Powerful Skills Will Skyrocket Your Value in the Marketplace!

By learning how to use Access WITH Excel, you will rise to a level of skill that few others have. Learning Access gives you incredible power over your data, no matter how large your data files are. Nightmare editing tasks will no longer bother you as you use your knowledge of queries to update thousands of records in minutes! Employers are waking up to the power of Access and those who have this knowledge will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you the capability to double or triple your productivity!

There is a HUGE need in the marketplace for people with these skills! This is your opportunity to break away from the pack of people who try and do everything with Excel, instead of learning that for many tasks, Access is the proper tool. This could be your shortest path to increasing your income!

From a Student Review:

"This is an amazing class/series. Bruce does a fantastic job explaining each concept and does so with such concern for the student. Just in presentation one can identify that this is a passion for Bruce and not just read from a script. I cannot wait to put this education to use within my career!! Thank you for creating this material!" - Rick WIlliams

Content and Overview

All you need to do the course is basic experience with Windows programs. If you have or are using Excel, that is even better. Much of the course is presented as a comparison to Excel and explains what tasks each program is best suited for.

Even though there are many lectures and several hours of content, each section focuses on one set of concepts so it is easy to do one section at a time, when your schedule allows. You will find that each chapter builds on the previous one as you build your understanding of Access, one step at a time.

By the time you have finished the course you will have done so much with Access and it will be so familiar that you will be ready to tackle your own data tasks immediately, putting your new learned skills into practical use and impressing your boss and coworkers.

The course is complete with working files and finished samples for everything that is covered. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Click the Take This Course button to take your first step towards quickly increasing your income! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!

From Another Student Review:

5 Stars - Absolutely the Best Course I Have Taken

I am not one to write many reviews, but when a course has reached beyond my expectations, I had no choice but to give compliments to the author Mr. Bruce Myron.

The content of the course was extremely comprehensive and informative in which every student will walk away having the best foundation of MS Access one can get. The clarity and tone of each video had me eager to learn more and has already assisted me with applications I had at work. With the knowledge I have gained, not only will it help separate myself from my co-workers, but allow me to increase my income over time.

The greatest treat one will get in this course is the interaction from Mr. Myron. He is absolutely the difference maker from any other course I had taken and made me feel that I was not alone while taking this course. I cannot wait to begin the other courses to get to the next level of my career.

Trust me, when it comes to learning MS Access from the ground up through Mr. Myron's courses, starting with Excel To Access: Intro to Access for Excel Users, one will be ecstatic with the results. - David Richardson

Another Student Review:

5 Stars - Brilliant piece of work!

Thanks Bruce for making these lectures. They are very well done, relevant and clear. I have literally copied line for line of many of these lectures into a project i am working on. Highly recommended also are the other videos which also contain golden nuggets: Access to Excel to Outlook, Access to Excel-Instant Reports and pivot tables, Microsoft Access vba for non programmers. And as a bonus, Bruce has been very helpful in answering, guiding and explaining content from his lecture when i asked for clarification.

Brilliant Bruce, thanks again - Steven Kawuma

Required Software

You should have Office 2010 or later. The course was created using Office 2013.

Who this course is for:

  • This course is perfect for anyone who wants to learn Access quickly and understand the differences between Access and Excel.

Expected Outcomes

  1. Understand the basics of Access tables, queries, forms and reports. Know how to structure tables being imported from Excel. Know how to create powerful queries and use them to create and modify tables. Understand how reports work and how to base them on tables or queries. Know how to create forms and subforms. Curated for the Udemy Business collection Requirements A basic understanding of Excel is preferred, but not a requirement. Students should know the basics of using Windows programs. Description Learn more than the basic structures in Access . Learn the concepts underneath and how they relate to and work wth Excel. Learn Access from an instructor with years of experience teaching Access and creating custom databases for businesses. From a recent Student Review: 5 Stars - I finally have a grasp of Access and relational databases! Thanks to Bruce's course, I can confidently say I have a good grasp of what Microsoft Access is, how to use it effectively and how it differs from Microsoft Excel. Bruce is clear and concise in his lectures. I enjoyed the hands-on/real world example style of teaching with downloadable Access & Excel files. - Joey Sullivan You will build a strong foundation in Access by understanding the logic behind its structure: Create tables and learn how to properly structure them. Extensive Training on ALL types of queries. Create reports from scratch instead of relying on wizards. Learn how to create advanced reports based on queries. Learn everything you need to know to build powerful and attractive forms. Build subforms and learn how to move in and out of them. Learn about simple macros. Make basic command buttons in forms. Learn a simple way to make multi value lookups on forms. Another Student Review: 5 Stars - Fantastic Course! I have been trying to come to grips with Access for some time now, but each time I became frustrated and eventually gave up. This course is structured in a way that gripped my interest and motivated me to complete it. Bruce has extensive knowledge and the way that he presents the material, makes it easy to follow and understand and it is a very valuable resource. - John Ovens These Powerful Skills Will Skyrocket Your Value in the Marketplace! By learning how to use Access WITH Excel, you will rise to a level of skill that few others have. Learning Access gives you incredible power over your data, no matter how large your data files are. Nightmare editing tasks will no longer bother you as you use your knowledge of queries to update thousands of records in minutes! Employers are waking up to the power of Access and those who have this knowledge will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you the capability to double or triple your productivity! There is a HUGE need in the marketplace for people with these skills! This is your opportunity to break away from the pack of people who try and do everything with Excel, instead of learning that for many tasks, Access is the proper tool. This could be your shortest path to increasing your income! From a Student Review: "This is an amazing class/series. Bruce does a fantastic job explaining each concept and does so with such concern for the student. Just in presentation one can identify that this is a passion for Bruce and not just read from a script. I cannot wait to put this education to use within my career!! Thank you for creating this material!" - Rick WIlliams Content and Overview All you need to do the course is basic experience with Windows programs. If you have or are using Excel, that is even better. Much of the course is presented as a comparison to Excel and explains what tasks each program is best suited for. Even though there are many lectures and several hours of content, each section focuses on one set of concepts so it is easy to do one section at a time, when your schedule allows. You will find that each chapter builds on the previous one as you build your understanding of Access, one step at a time. By the time you have finished the course you will have done so much with Access and it will be so familiar that you will be ready to tackle your own data tasks immediately , putting your new learned skills into practical use and impressing your boss and coworkers. The course is complete with working files and finished samples for everything that is covered. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course. Click the Take This Course button to take your first step towards quickly increasing your income! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund! From Another Student Review: 5 Stars - Absolutely the Best Course I Have Taken I am not one to write many reviews, but when a course has reached beyond my expectations, I had no choice but to give compliments to the author Mr. Bruce Myron. The content of the course was extremely comprehensive and informative in which every student will walk away having the best foundation of MS Access one can get. The clarity and tone of each video had me eager to learn more and has already assisted me with applications I had at work. With the knowledge I have gained, not only will it help separate myself from my co-workers, but allow me to increase my income over time. The greatest treat one will get in this course is the interaction from Mr. Myron. He is absolutely the difference maker from any other course I had taken and made me feel that I was not alone while taking this course. I cannot wait to begin the other courses to get to the next level of my career. Trust me, when it comes to learning MS Access from the ground up through Mr. Myron's courses, starting with Excel To Access: Intro to Access for Excel Users, one will be ecstatic with the results. - David Richardson Another Student Review: 5 Stars - Brilliant piece of work! Thanks Bruce for making these lectures. They are very well done, relevant and clear. I have literally copied line for line of many of these lectures into a project i am working on. Highly recommended also are the other videos which also contain golden nuggets: Access to Excel to Outlook, Access to Excel-Instant Reports and pivot tables, Microsoft Access vba for non programmers. And as a bonus, Bruce has been very helpful in answering, guiding and explaining content from his lecture when i asked for clarification. Brilliant Bruce, thanks again - Steven Kawuma Required Software You should have Office 2010 or later. The course was created using Office 2013. Who this course is for: This course is perfect for anyone who wants to learn Access quickly and understand the differences between Access and Excel. Show more Show less Featured review Vedad Suljić 3 courses 2 reviews Rating: 4.5 out of 5 a year ago For me as someone who had zero knowledge and experience in MS Access this was a very good course to get not just basic but also advanced knowledge. Bruce is well experienced and you can just feel it. If I have to find a con, this would be it. At some parts he spends to much time for editing, although I consider this as important, but in the course it's just important to get the message. All in all. BRAVO Show more Show less Course content 20 sections • 120 lectures • 10h 0m total length Expand all sections Introduction - Course Layout and Objectives 3 lectures • 6min Course Introduction 00:35 Course Overview by Section Preview 05:18 Important NOTE on DOWNLOADABLE RESOURCES 00:19 Why You Need Access 3 lectures • 8min Comparing the Access and Excel Screens Preview 02:06 Why You Need Access Preview 02:33 Where Do We Go From Here? Preview 03:46 The TABLE Object 14 lectures • 1hr 9min Intro to Tables and Tabbed vs Overlap View Preview 06:35 Editing, Adding and Deleting Records 07:25 Sorting a Table 03:13 Basic Filters 04:07 Advanced Filters 07:42 Using Find and Replace with Tables 06:12 Create a Table and add a Primary Key and Fields 04:52 Create Table 2 - Add the Rest of the Fields to the Table 05:28 Create Table 3 - Why Are There So Many Numeric Field Sizes? 01:46 List of Reserved Words 8 pages Table Properties 1 - Formats and Input Masks 05:05 Table Properties 2 - Defaults and Validation Rules 06:09 Table Properties 3 - Add Lookups to a Table 05:26 Modify Table Design - Add, Delete and Move Fields 05:23 The REPORT Object 11 lectures • 1hr 13min Introduction and Create a Report Preview 05:52 Using the Report Wizard Preview 06:08 What Are Controls? 04:46 Report View and Layout View 04:46 Modify the Report Design and Selecting Controls 08:22 Entering Formulas into Text Boxes 10:08 Sorting and Subtotals in Reports 07:14 Conditional Formatting 03:48 The Properties Box 06:46 Using the Properties Box 12:55 Conclusion and Why We Need Queries 02:20 The QUERY Object - SELECT Queries 11 lectures • 46min Overview of Select Queries Database 03:15 Intro to Select Queries Preview 06:15 Sorting in Select Queries Preview 04:00 Using Criteria in Queries - And vs OR 04:14 Using Criteria in Queries - Wildcards 04:22 List of Query Wildcard Characters 2 pages Using Criteria in Queries - Formulas in Criteria 03:01 Calculations in Select Queries 05:01 Multiple Tables in Queries 06:55 Parameters in queries 04:53 A Parameter Query Trick 04:29 Reports Revisited 4 lectures • 22min Review the Report Source Table Structure 05:54 Using a Select Query as a Report Source 02:41 Setting up Date Parameters 06:27 Final Touch - a Title with Dates 07:17 Unique Value, TOP and Total Queries 5 lectures • 31min Unique Value Queries - Part 1 04:22 Unique Value Queries - Part 2 05:54 TOP queries 06:15 Total Queries - Part 1 06:56 Total Queries - Part 2 07:03 ACTION Queries 6 lectures • 33min Intro to Action Queries with a Make Table Query 05:26 Append Query 06:51 Delete Query 03:38 Update Qry Part 1 - Increase Prices 02:54 Update Query 2 - Add an Order Total Field 09:05 A Quick MACRO to Automate Updating the Order Totals 05:09 Migrating from Excel to Access 1: Get the Data Into Access 3 lectures • 16min Import Problems 1 - Heading not removed Preview 03:33 Import Problems 2 - Common Import Errors Preview 08:43 A Clean Import - but is it? Preview 03:44 Migrating from Excel to Access 2: Design the Correct Structure 9 lectures • 31min Combine data in Excel before bringing into Access 04:35 Planning Your Database - 3 Best Practices - NUMBER 1 03:47 Planning Your Database - 3 Best Practices - NUMBER 2 04:20 Planning Your Database - 3 Best Practices - NUMBER 3 02:14 Three Best Practices in Designing Table Structures 1 page How to Print Your Table Structures 01:47 How to Use the Relationships screen 04:41 Why I Don't Use the Relationships screen 06:40 Why You DON'T want to Use Analyze Table! 03:12 10 more sections Instructor Bruce Myron Productivity Specialist 4.6 Instructor Rating 23,165 Reviews 112,526 Students 19 Courses Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business. "Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do. I have also spent time as a full time trainer providing group classes on the Microsoft Office programs. In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible. Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed. My goal is to show my students how to create systems that business will value and that will create long term income. 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:'6780fe504e14f43b',m:'b71db204203bd4d6922318aca0d0c389dbe4a133-1627841114-1800-AYfi/LoOY2Oa0qq2iMP4gBb3Jfs5KP8YJyzxW00VfiyF1MHtX70JbLrE2vWSOlp6SFvPQfy5vNgYpQEotPk7eq2+ZrnUOCFOzvW09ApeFc6lO7AyEFhPXuozKYhrS8LUrfg10Ukn0BMet8bRKAqKfgaYTjlAwistZAiM3wg+991G',s:[0x006057b09a,0x345c2d4a46],}})();
  2. Know how to structure tables being imported from Excel. Know how to create powerful queries and use them to create and modify tables. Understand how reports work and how to base them on tables or queries. Know how to create forms and subforms. Curated for the Udemy Business collection Requirements A basic understanding of Excel is preferred, but not a requirement. Students should know the basics of using Windows programs. Description Learn more than the basic structures in Access . Learn the concepts underneath and how they relate to and work wth Excel. Learn Access from an instructor with years of experience teaching Access and creating custom databases for businesses. From a recent Student Review: 5 Stars - I finally have a grasp of Access and relational databases! Thanks to Bruce's course, I can confidently say I have a good grasp of what Microsoft Access is, how to use it effectively and how it differs from Microsoft Excel. Bruce is clear and concise in his lectures. I enjoyed the hands-on/real world example style of teaching with downloadable Access & Excel files. - Joey Sullivan You will build a strong foundation in Access by understanding the logic behind its structure: Create tables and learn how to properly structure them. Extensive Training on ALL types of queries. Create reports from scratch instead of relying on wizards. Learn how to create advanced reports based on queries. Learn everything you need to know to build powerful and attractive forms. Build subforms and learn how to move in and out of them. Learn about simple macros. Make basic command buttons in forms. Learn a simple way to make multi value lookups on forms. Another Student Review: 5 Stars - Fantastic Course! I have been trying to come to grips with Access for some time now, but each time I became frustrated and eventually gave up. This course is structured in a way that gripped my interest and motivated me to complete it. Bruce has extensive knowledge and the way that he presents the material, makes it easy to follow and understand and it is a very valuable resource. - John Ovens These Powerful Skills Will Skyrocket Your Value in the Marketplace! By learning how to use Access WITH Excel, you will rise to a level of skill that few others have. Learning Access gives you incredible power over your data, no matter how large your data files are. Nightmare editing tasks will no longer bother you as you use your knowledge of queries to update thousands of records in minutes! Employers are waking up to the power of Access and those who have this knowledge will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you the capability to double or triple your productivity! There is a HUGE need in the marketplace for people with these skills! This is your opportunity to break away from the pack of people who try and do everything with Excel, instead of learning that for many tasks, Access is the proper tool. This could be your shortest path to increasing your income! From a Student Review: "This is an amazing class/series. Bruce does a fantastic job explaining each concept and does so with such concern for the student. Just in presentation one can identify that this is a passion for Bruce and not just read from a script. I cannot wait to put this education to use within my career!! Thank you for creating this material!" - Rick WIlliams Content and Overview All you need to do the course is basic experience with Windows programs. If you have or are using Excel, that is even better. Much of the course is presented as a comparison to Excel and explains what tasks each program is best suited for. Even though there are many lectures and several hours of content, each section focuses on one set of concepts so it is easy to do one section at a time, when your schedule allows. You will find that each chapter builds on the previous one as you build your understanding of Access, one step at a time. By the time you have finished the course you will have done so much with Access and it will be so familiar that you will be ready to tackle your own data tasks immediately , putting your new learned skills into practical use and impressing your boss and coworkers. The course is complete with working files and finished samples for everything that is covered. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course. Click the Take This Course button to take your first step towards quickly increasing your income! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund! From Another Student Review: 5 Stars - Absolutely the Best Course I Have Taken I am not one to write many reviews, but when a course has reached beyond my expectations, I had no choice but to give compliments to the author Mr. Bruce Myron. The content of the course was extremely comprehensive and informative in which every student will walk away having the best foundation of MS Access one can get. The clarity and tone of each video had me eager to learn more and has already assisted me with applications I had at work. With the knowledge I have gained, not only will it help separate myself from my co-workers, but allow me to increase my income over time. The greatest treat one will get in this course is the interaction from Mr. Myron. He is absolutely the difference maker from any other course I had taken and made me feel that I was not alone while taking this course. I cannot wait to begin the other courses to get to the next level of my career. Trust me, when it comes to learning MS Access from the ground up through Mr. Myron's courses, starting with Excel To Access: Intro to Access for Excel Users, one will be ecstatic with the results. - David Richardson Another Student Review: 5 Stars - Brilliant piece of work! Thanks Bruce for making these lectures. They are very well done, relevant and clear. I have literally copied line for line of many of these lectures into a project i am working on. Highly recommended also are the other videos which also contain golden nuggets: Access to Excel to Outlook, Access to Excel-Instant Reports and pivot tables, Microsoft Access vba for non programmers. And as a bonus, Bruce has been very helpful in answering, guiding and explaining content from his lecture when i asked for clarification. Brilliant Bruce, thanks again - Steven Kawuma Required Software You should have Office 2010 or later. The course was created using Office 2013. Who this course is for: This course is perfect for anyone who wants to learn Access quickly and understand the differences between Access and Excel. Show more Show less Featured review Vedad Suljić 3 courses 2 reviews Rating: 4.5 out of 5 a year ago For me as someone who had zero knowledge and experience in MS Access this was a very good course to get not just basic but also advanced knowledge. Bruce is well experienced and you can just feel it. If I have to find a con, this would be it. At some parts he spends to much time for editing, although I consider this as important, but in the course it's just important to get the message. All in all. BRAVO Show more Show less Course content 20 sections • 120 lectures • 10h 0m total length Expand all sections Introduction - Course Layout and Objectives 3 lectures • 6min Course Introduction 00:35 Course Overview by Section Preview 05:18 Important NOTE on DOWNLOADABLE RESOURCES 00:19 Why You Need Access 3 lectures • 8min Comparing the Access and Excel Screens Preview 02:06 Why You Need Access Preview 02:33 Where Do We Go From Here? Preview 03:46 The TABLE Object 14 lectures • 1hr 9min Intro to Tables and Tabbed vs Overlap View Preview 06:35 Editing, Adding and Deleting Records 07:25 Sorting a Table 03:13 Basic Filters 04:07 Advanced Filters 07:42 Using Find and Replace with Tables 06:12 Create a Table and add a Primary Key and Fields 04:52 Create Table 2 - Add the Rest of the Fields to the Table 05:28 Create Table 3 - Why Are There So Many Numeric Field Sizes? 01:46 List of Reserved Words 8 pages Table Properties 1 - Formats and Input Masks 05:05 Table Properties 2 - Defaults and Validation Rules 06:09 Table Properties 3 - Add Lookups to a Table 05:26 Modify Table Design - Add, Delete and Move Fields 05:23 The REPORT Object 11 lectures • 1hr 13min Introduction and Create a Report Preview 05:52 Using the Report Wizard Preview 06:08 What Are Controls? 04:46 Report View and Layout View 04:46 Modify the Report Design and Selecting Controls 08:22 Entering Formulas into Text Boxes 10:08 Sorting and Subtotals in Reports 07:14 Conditional Formatting 03:48 The Properties Box 06:46 Using the Properties Box 12:55 Conclusion and Why We Need Queries 02:20 The QUERY Object - SELECT Queries 11 lectures • 46min Overview of Select Queries Database 03:15 Intro to Select Queries Preview 06:15 Sorting in Select Queries Preview 04:00 Using Criteria in Queries - And vs OR 04:14 Using Criteria in Queries - Wildcards 04:22 List of Query Wildcard Characters 2 pages Using Criteria in Queries - Formulas in Criteria 03:01 Calculations in Select Queries 05:01 Multiple Tables in Queries 06:55 Parameters in queries 04:53 A Parameter Query Trick 04:29 Reports Revisited 4 lectures • 22min Review the Report Source Table Structure 05:54 Using a Select Query as a Report Source 02:41 Setting up Date Parameters 06:27 Final Touch - a Title with Dates 07:17 Unique Value, TOP and Total Queries 5 lectures • 31min Unique Value Queries - Part 1 04:22 Unique Value Queries - Part 2 05:54 TOP queries 06:15 Total Queries - Part 1 06:56 Total Queries - Part 2 07:03 ACTION Queries 6 lectures • 33min Intro to Action Queries with a Make Table Query 05:26 Append Query 06:51 Delete Query 03:38 Update Qry Part 1 - Increase Prices 02:54 Update Query 2 - Add an Order Total Field 09:05 A Quick MACRO to Automate Updating the Order Totals 05:09 Migrating from Excel to Access 1: Get the Data Into Access 3 lectures • 16min Import Problems 1 - Heading not removed Preview 03:33 Import Problems 2 - Common Import Errors Preview 08:43 A Clean Import - but is it? Preview 03:44 Migrating from Excel to Access 2: Design the Correct Structure 9 lectures • 31min Combine data in Excel before bringing into Access 04:35 Planning Your Database - 3 Best Practices - NUMBER 1 03:47 Planning Your Database - 3 Best Practices - NUMBER 2 04:20 Planning Your Database - 3 Best Practices - NUMBER 3 02:14 Three Best Practices in Designing Table Structures 1 page How to Print Your Table Structures 01:47 How to Use the Relationships screen 04:41 Why I Don't Use the Relationships screen 06:40 Why You DON'T want to Use Analyze Table! 03:12 10 more sections Instructor Bruce Myron Productivity Specialist 4.6 Instructor Rating 23,165 Reviews 112,526 Students 19 Courses Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business. "Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do. I have also spent time as a full time trainer providing group classes on the Microsoft Office programs. In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible. Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed. My goal is to show my students how to create systems that business will value and that will create long term income. 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:'6780fe504e14f43b',m:'b71db204203bd4d6922318aca0d0c389dbe4a133-1627841114-1800-AYfi/LoOY2Oa0qq2iMP4gBb3Jfs5KP8YJyzxW00VfiyF1MHtX70JbLrE2vWSOlp6SFvPQfy5vNgYpQEotPk7eq2+ZrnUOCFOzvW09ApeFc6lO7AyEFhPXuozKYhrS8LUrfg10Ukn0BMet8bRKAqKfgaYTjlAwistZAiM3wg+991G',s:[0x006057b09a,0x345c2d4a46],}})();
  3. Know how to create powerful queries and use them to create and modify tables. Understand how reports work and how to base them on tables or queries. Know how to create forms and subforms. Curated for the Udemy Business collection Requirements A basic understanding of Excel is preferred, but not a requirement. Students should know the basics of using Windows programs. Description Learn more than the basic structures in Access . Learn the concepts underneath and how they relate to and work wth Excel. Learn Access from an instructor with years of experience teaching Access and creating custom databases for businesses. From a recent Student Review: 5 Stars - I finally have a grasp of Access and relational databases! Thanks to Bruce's course, I can confidently say I have a good grasp of what Microsoft Access is, how to use it effectively and how it differs from Microsoft Excel. Bruce is clear and concise in his lectures. I enjoyed the hands-on/real world example style of teaching with downloadable Access & Excel files. - Joey Sullivan You will build a strong foundation in Access by understanding the logic behind its structure: Create tables and learn how to properly structure them. Extensive Training on ALL types of queries. Create reports from scratch instead of relying on wizards. Learn how to create advanced reports based on queries. Learn everything you need to know to build powerful and attractive forms. Build subforms and learn how to move in and out of them. Learn about simple macros. Make basic command buttons in forms. Learn a simple way to make multi value lookups on forms. Another Student Review: 5 Stars - Fantastic Course! I have been trying to come to grips with Access for some time now, but each time I became frustrated and eventually gave up. This course is structured in a way that gripped my interest and motivated me to complete it. Bruce has extensive knowledge and the way that he presents the material, makes it easy to follow and understand and it is a very valuable resource. - John Ovens These Powerful Skills Will Skyrocket Your Value in the Marketplace! By learning how to use Access WITH Excel, you will rise to a level of skill that few others have. Learning Access gives you incredible power over your data, no matter how large your data files are. Nightmare editing tasks will no longer bother you as you use your knowledge of queries to update thousands of records in minutes! Employers are waking up to the power of Access and those who have this knowledge will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you the capability to double or triple your productivity! There is a HUGE need in the marketplace for people with these skills! This is your opportunity to break away from the pack of people who try and do everything with Excel, instead of learning that for many tasks, Access is the proper tool. This could be your shortest path to increasing your income! From a Student Review: "This is an amazing class/series. Bruce does a fantastic job explaining each concept and does so with such concern for the student. Just in presentation one can identify that this is a passion for Bruce and not just read from a script. I cannot wait to put this education to use within my career!! Thank you for creating this material!" - Rick WIlliams Content and Overview All you need to do the course is basic experience with Windows programs. If you have or are using Excel, that is even better. Much of the course is presented as a comparison to Excel and explains what tasks each program is best suited for. Even though there are many lectures and several hours of content, each section focuses on one set of concepts so it is easy to do one section at a time, when your schedule allows. You will find that each chapter builds on the previous one as you build your understanding of Access, one step at a time. By the time you have finished the course you will have done so much with Access and it will be so familiar that you will be ready to tackle your own data tasks immediately , putting your new learned skills into practical use and impressing your boss and coworkers. The course is complete with working files and finished samples for everything that is covered. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course. Click the Take This Course button to take your first step towards quickly increasing your income! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund! From Another Student Review: 5 Stars - Absolutely the Best Course I Have Taken I am not one to write many reviews, but when a course has reached beyond my expectations, I had no choice but to give compliments to the author Mr. Bruce Myron. The content of the course was extremely comprehensive and informative in which every student will walk away having the best foundation of MS Access one can get. The clarity and tone of each video had me eager to learn more and has already assisted me with applications I had at work. With the knowledge I have gained, not only will it help separate myself from my co-workers, but allow me to increase my income over time. The greatest treat one will get in this course is the interaction from Mr. Myron. He is absolutely the difference maker from any other course I had taken and made me feel that I was not alone while taking this course. I cannot wait to begin the other courses to get to the next level of my career. Trust me, when it comes to learning MS Access from the ground up through Mr. Myron's courses, starting with Excel To Access: Intro to Access for Excel Users, one will be ecstatic with the results. - David Richardson Another Student Review: 5 Stars - Brilliant piece of work! Thanks Bruce for making these lectures. They are very well done, relevant and clear. I have literally copied line for line of many of these lectures into a project i am working on. Highly recommended also are the other videos which also contain golden nuggets: Access to Excel to Outlook, Access to Excel-Instant Reports and pivot tables, Microsoft Access vba for non programmers. And as a bonus, Bruce has been very helpful in answering, guiding and explaining content from his lecture when i asked for clarification. Brilliant Bruce, thanks again - Steven Kawuma Required Software You should have Office 2010 or later. The course was created using Office 2013. Who this course is for: This course is perfect for anyone who wants to learn Access quickly and understand the differences between Access and Excel. Show more Show less Featured review Vedad Suljić 3 courses 2 reviews Rating: 4.5 out of 5 a year ago For me as someone who had zero knowledge and experience in MS Access this was a very good course to get not just basic but also advanced knowledge. Bruce is well experienced and you can just feel it. If I have to find a con, this would be it. At some parts he spends to much time for editing, although I consider this as important, but in the course it's just important to get the message. All in all. BRAVO Show more Show less Course content 20 sections • 120 lectures • 10h 0m total length Expand all sections Introduction - Course Layout and Objectives 3 lectures • 6min Course Introduction 00:35 Course Overview by Section Preview 05:18 Important NOTE on DOWNLOADABLE RESOURCES 00:19 Why You Need Access 3 lectures • 8min Comparing the Access and Excel Screens Preview 02:06 Why You Need Access Preview 02:33 Where Do We Go From Here? Preview 03:46 The TABLE Object 14 lectures • 1hr 9min Intro to Tables and Tabbed vs Overlap View Preview 06:35 Editing, Adding and Deleting Records 07:25 Sorting a Table 03:13 Basic Filters 04:07 Advanced Filters 07:42 Using Find and Replace with Tables 06:12 Create a Table and add a Primary Key and Fields 04:52 Create Table 2 - Add the Rest of the Fields to the Table 05:28 Create Table 3 - Why Are There So Many Numeric Field Sizes? 01:46 List of Reserved Words 8 pages Table Properties 1 - Formats and Input Masks 05:05 Table Properties 2 - Defaults and Validation Rules 06:09 Table Properties 3 - Add Lookups to a Table 05:26 Modify Table Design - Add, Delete and Move Fields 05:23 The REPORT Object 11 lectures • 1hr 13min Introduction and Create a Report Preview 05:52 Using the Report Wizard Preview 06:08 What Are Controls? 04:46 Report View and Layout View 04:46 Modify the Report Design and Selecting Controls 08:22 Entering Formulas into Text Boxes 10:08 Sorting and Subtotals in Reports 07:14 Conditional Formatting 03:48 The Properties Box 06:46 Using the Properties Box 12:55 Conclusion and Why We Need Queries 02:20 The QUERY Object - SELECT Queries 11 lectures • 46min Overview of Select Queries Database 03:15 Intro to Select Queries Preview 06:15 Sorting in Select Queries Preview 04:00 Using Criteria in Queries - And vs OR 04:14 Using Criteria in Queries - Wildcards 04:22 List of Query Wildcard Characters 2 pages Using Criteria in Queries - Formulas in Criteria 03:01 Calculations in Select Queries 05:01 Multiple Tables in Queries 06:55 Parameters in queries 04:53 A Parameter Query Trick 04:29 Reports Revisited 4 lectures • 22min Review the Report Source Table Structure 05:54 Using a Select Query as a Report Source 02:41 Setting up Date Parameters 06:27 Final Touch - a Title with Dates 07:17 Unique Value, TOP and Total Queries 5 lectures • 31min Unique Value Queries - Part 1 04:22 Unique Value Queries - Part 2 05:54 TOP queries 06:15 Total Queries - Part 1 06:56 Total Queries - Part 2 07:03 ACTION Queries 6 lectures • 33min Intro to Action Queries with a Make Table Query 05:26 Append Query 06:51 Delete Query 03:38 Update Qry Part 1 - Increase Prices 02:54 Update Query 2 - Add an Order Total Field 09:05 A Quick MACRO to Automate Updating the Order Totals 05:09 Migrating from Excel to Access 1: Get the Data Into Access 3 lectures • 16min Import Problems 1 - Heading not removed Preview 03:33 Import Problems 2 - Common Import Errors Preview 08:43 A Clean Import - but is it? Preview 03:44 Migrating from Excel to Access 2: Design the Correct Structure 9 lectures • 31min Combine data in Excel before bringing into Access 04:35 Planning Your Database - 3 Best Practices - NUMBER 1 03:47 Planning Your Database - 3 Best Practices - NUMBER 2 04:20 Planning Your Database - 3 Best Practices - NUMBER 3 02:14 Three Best Practices in Designing Table Structures 1 page How to Print Your Table Structures 01:47 How to Use the Relationships screen 04:41 Why I Don't Use the Relationships screen 06:40 Why You DON'T want to Use Analyze Table! 03:12 10 more sections Instructor Bruce Myron Productivity Specialist 4.6 Instructor Rating 23,165 Reviews 112,526 Students 19 Courses Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business. "Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do. I have also spent time as a full time trainer providing group classes on the Microsoft Office programs. In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible. Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed. My goal is to show my students how to create systems that business will value and that will create long term income. 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:'6780fe504e14f43b',m:'b71db204203bd4d6922318aca0d0c389dbe4a133-1627841114-1800-AYfi/LoOY2Oa0qq2iMP4gBb3Jfs5KP8YJyzxW00VfiyF1MHtX70JbLrE2vWSOlp6SFvPQfy5vNgYpQEotPk7eq2+ZrnUOCFOzvW09ApeFc6lO7AyEFhPXuozKYhrS8LUrfg10Ukn0BMet8bRKAqKfgaYTjlAwistZAiM3wg+991G',s:[0x006057b09a,0x345c2d4a46],}})();
  4. Understand how reports work and how to base them on tables or queries. Know how to create forms and subforms. Curated for the Udemy Business collection Requirements A basic understanding of Excel is preferred, but not a requirement. Students should know the basics of using Windows programs. Description Learn more than the basic structures in Access . Learn the concepts underneath and how they relate to and work wth Excel. Learn Access from an instructor with years of experience teaching Access and creating custom databases for businesses. From a recent Student Review: 5 Stars - I finally have a grasp of Access and relational databases! Thanks to Bruce's course, I can confidently say I have a good grasp of what Microsoft Access is, how to use it effectively and how it differs from Microsoft Excel. Bruce is clear and concise in his lectures. I enjoyed the hands-on/real world example style of teaching with downloadable Access & Excel files. - Joey Sullivan You will build a strong foundation in Access by understanding the logic behind its structure: Create tables and learn how to properly structure them. Extensive Training on ALL types of queries. Create reports from scratch instead of relying on wizards. Learn how to create advanced reports based on queries. Learn everything you need to know to build powerful and attractive forms. Build subforms and learn how to move in and out of them. Learn about simple macros. Make basic command buttons in forms. Learn a simple way to make multi value lookups on forms. Another Student Review: 5 Stars - Fantastic Course! I have been trying to come to grips with Access for some time now, but each time I became frustrated and eventually gave up. This course is structured in a way that gripped my interest and motivated me to complete it. Bruce has extensive knowledge and the way that he presents the material, makes it easy to follow and understand and it is a very valuable resource. - John Ovens These Powerful Skills Will Skyrocket Your Value in the Marketplace! By learning how to use Access WITH Excel, you will rise to a level of skill that few others have. Learning Access gives you incredible power over your data, no matter how large your data files are. Nightmare editing tasks will no longer bother you as you use your knowledge of queries to update thousands of records in minutes! Employers are waking up to the power of Access and those who have this knowledge will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you the capability to double or triple your productivity! There is a HUGE need in the marketplace for people with these skills! This is your opportunity to break away from the pack of people who try and do everything with Excel, instead of learning that for many tasks, Access is the proper tool. This could be your shortest path to increasing your income! From a Student Review: "This is an amazing class/series. Bruce does a fantastic job explaining each concept and does so with such concern for the student. Just in presentation one can identify that this is a passion for Bruce and not just read from a script. I cannot wait to put this education to use within my career!! Thank you for creating this material!" - Rick WIlliams Content and Overview All you need to do the course is basic experience with Windows programs. If you have or are using Excel, that is even better. Much of the course is presented as a comparison to Excel and explains what tasks each program is best suited for. Even though there are many lectures and several hours of content, each section focuses on one set of concepts so it is easy to do one section at a time, when your schedule allows. You will find that each chapter builds on the previous one as you build your understanding of Access, one step at a time. By the time you have finished the course you will have done so much with Access and it will be so familiar that you will be ready to tackle your own data tasks immediately , putting your new learned skills into practical use and impressing your boss and coworkers. The course is complete with working files and finished samples for everything that is covered. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course. Click the Take This Course button to take your first step towards quickly increasing your income! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund! From Another Student Review: 5 Stars - Absolutely the Best Course I Have Taken I am not one to write many reviews, but when a course has reached beyond my expectations, I had no choice but to give compliments to the author Mr. Bruce Myron. The content of the course was extremely comprehensive and informative in which every student will walk away having the best foundation of MS Access one can get. The clarity and tone of each video had me eager to learn more and has already assisted me with applications I had at work. With the knowledge I have gained, not only will it help separate myself from my co-workers, but allow me to increase my income over time. The greatest treat one will get in this course is the interaction from Mr. Myron. He is absolutely the difference maker from any other course I had taken and made me feel that I was not alone while taking this course. I cannot wait to begin the other courses to get to the next level of my career. Trust me, when it comes to learning MS Access from the ground up through Mr. Myron's courses, starting with Excel To Access: Intro to Access for Excel Users, one will be ecstatic with the results. - David Richardson Another Student Review: 5 Stars - Brilliant piece of work! Thanks Bruce for making these lectures. They are very well done, relevant and clear. I have literally copied line for line of many of these lectures into a project i am working on. Highly recommended also are the other videos which also contain golden nuggets: Access to Excel to Outlook, Access to Excel-Instant Reports and pivot tables, Microsoft Access vba for non programmers. And as a bonus, Bruce has been very helpful in answering, guiding and explaining content from his lecture when i asked for clarification. Brilliant Bruce, thanks again - Steven Kawuma Required Software You should have Office 2010 or later. The course was created using Office 2013. Who this course is for: This course is perfect for anyone who wants to learn Access quickly and understand the differences between Access and Excel. Show more Show less Featured review Vedad Suljić 3 courses 2 reviews Rating: 4.5 out of 5 a year ago For me as someone who had zero knowledge and experience in MS Access this was a very good course to get not just basic but also advanced knowledge. Bruce is well experienced and you can just feel it. If I have to find a con, this would be it. At some parts he spends to much time for editing, although I consider this as important, but in the course it's just important to get the message. All in all. BRAVO Show more Show less Course content 20 sections • 120 lectures • 10h 0m total length Expand all sections Introduction - Course Layout and Objectives 3 lectures • 6min Course Introduction 00:35 Course Overview by Section Preview 05:18 Important NOTE on DOWNLOADABLE RESOURCES 00:19 Why You Need Access 3 lectures • 8min Comparing the Access and Excel Screens Preview 02:06 Why You Need Access Preview 02:33 Where Do We Go From Here? Preview 03:46 The TABLE Object 14 lectures • 1hr 9min Intro to Tables and Tabbed vs Overlap View Preview 06:35 Editing, Adding and Deleting Records 07:25 Sorting a Table 03:13 Basic Filters 04:07 Advanced Filters 07:42 Using Find and Replace with Tables 06:12 Create a Table and add a Primary Key and Fields 04:52 Create Table 2 - Add the Rest of the Fields to the Table 05:28 Create Table 3 - Why Are There So Many Numeric Field Sizes? 01:46 List of Reserved Words 8 pages Table Properties 1 - Formats and Input Masks 05:05 Table Properties 2 - Defaults and Validation Rules 06:09 Table Properties 3 - Add Lookups to a Table 05:26 Modify Table Design - Add, Delete and Move Fields 05:23 The REPORT Object 11 lectures • 1hr 13min Introduction and Create a Report Preview 05:52 Using the Report Wizard Preview 06:08 What Are Controls? 04:46 Report View and Layout View 04:46 Modify the Report Design and Selecting Controls 08:22 Entering Formulas into Text Boxes 10:08 Sorting and Subtotals in Reports 07:14 Conditional Formatting 03:48 The Properties Box 06:46 Using the Properties Box 12:55 Conclusion and Why We Need Queries 02:20 The QUERY Object - SELECT Queries 11 lectures • 46min Overview of Select Queries Database 03:15 Intro to Select Queries Preview 06:15 Sorting in Select Queries Preview 04:00 Using Criteria in Queries - And vs OR 04:14 Using Criteria in Queries - Wildcards 04:22 List of Query Wildcard Characters 2 pages Using Criteria in Queries - Formulas in Criteria 03:01 Calculations in Select Queries 05:01 Multiple Tables in Queries 06:55 Parameters in queries 04:53 A Parameter Query Trick 04:29 Reports Revisited 4 lectures • 22min Review the Report Source Table Structure 05:54 Using a Select Query as a Report Source 02:41 Setting up Date Parameters 06:27 Final Touch - a Title with Dates 07:17 Unique Value, TOP and Total Queries 5 lectures • 31min Unique Value Queries - Part 1 04:22 Unique Value Queries - Part 2 05:54 TOP queries 06:15 Total Queries - Part 1 06:56 Total Queries - Part 2 07:03 ACTION Queries 6 lectures • 33min Intro to Action Queries with a Make Table Query 05:26 Append Query 06:51 Delete Query 03:38 Update Qry Part 1 - Increase Prices 02:54 Update Query 2 - Add an Order Total Field 09:05 A Quick MACRO to Automate Updating the Order Totals 05:09 Migrating from Excel to Access 1: Get the Data Into Access 3 lectures • 16min Import Problems 1 - Heading not removed Preview 03:33 Import Problems 2 - Common Import Errors Preview 08:43 A Clean Import - but is it? Preview 03:44 Migrating from Excel to Access 2: Design the Correct Structure 9 lectures • 31min Combine data in Excel before bringing into Access 04:35 Planning Your Database - 3 Best Practices - NUMBER 1 03:47 Planning Your Database - 3 Best Practices - NUMBER 2 04:20 Planning Your Database - 3 Best Practices - NUMBER 3 02:14 Three Best Practices in Designing Table Structures 1 page How to Print Your Table Structures 01:47 How to Use the Relationships screen 04:41 Why I Don't Use the Relationships screen 06:40 Why You DON'T want to Use Analyze Table! 03:12 10 more sections Instructor Bruce Myron Productivity Specialist 4.6 Instructor Rating 23,165 Reviews 112,526 Students 19 Courses Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business. "Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do. I have also spent time as a full time trainer providing group classes on the Microsoft Office programs. In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible. Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed. My goal is to show my students how to create systems that business will value and that will create long term income. 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:'6780fe504e14f43b',m:'b71db204203bd4d6922318aca0d0c389dbe4a133-1627841114-1800-AYfi/LoOY2Oa0qq2iMP4gBb3Jfs5KP8YJyzxW00VfiyF1MHtX70JbLrE2vWSOlp6SFvPQfy5vNgYpQEotPk7eq2+ZrnUOCFOzvW09ApeFc6lO7AyEFhPXuozKYhrS8LUrfg10Ukn0BMet8bRKAqKfgaYTjlAwistZAiM3wg+991G',s:[0x006057b09a,0x345c2d4a46],}})();
  5. Know how to create forms and subforms. Curated for the Udemy Business collection Requirements A basic understanding of Excel is preferred, but not a requirement. Students should know the basics of using Windows programs. Description Learn more than the basic structures in Access . Learn the concepts underneath and how they relate to and work wth Excel. Learn Access from an instructor with years of experience teaching Access and creating custom databases for businesses. From a recent Student Review: 5 Stars - I finally have a grasp of Access and relational databases! Thanks to Bruce's course, I can confidently say I have a good grasp of what Microsoft Access is, how to use it effectively and how it differs from Microsoft Excel. Bruce is clear and concise in his lectures. I enjoyed the hands-on/real world example style of teaching with downloadable Access & Excel files. - Joey Sullivan You will build a strong foundation in Access by understanding the logic behind its structure: Create tables and learn how to properly structure them. Extensive Training on ALL types of queries. Create reports from scratch instead of relying on wizards. Learn how to create advanced reports based on queries. Learn everything you need to know to build powerful and attractive forms. Build subforms and learn how to move in and out of them. Learn about simple macros. Make basic command buttons in forms. Learn a simple way to make multi value lookups on forms. Another Student Review: 5 Stars - Fantastic Course! I have been trying to come to grips with Access for some time now, but each time I became frustrated and eventually gave up. This course is structured in a way that gripped my interest and motivated me to complete it. Bruce has extensive knowledge and the way that he presents the material, makes it easy to follow and understand and it is a very valuable resource. - John Ovens These Powerful Skills Will Skyrocket Your Value in the Marketplace! By learning how to use Access WITH Excel, you will rise to a level of skill that few others have. Learning Access gives you incredible power over your data, no matter how large your data files are. Nightmare editing tasks will no longer bother you as you use your knowledge of queries to update thousands of records in minutes! Employers are waking up to the power of Access and those who have this knowledge will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you the capability to double or triple your productivity! There is a HUGE need in the marketplace for people with these skills! This is your opportunity to break away from the pack of people who try and do everything with Excel, instead of learning that for many tasks, Access is the proper tool. This could be your shortest path to increasing your income! From a Student Review: "This is an amazing class/series. Bruce does a fantastic job explaining each concept and does so with such concern for the student. Just in presentation one can identify that this is a passion for Bruce and not just read from a script. I cannot wait to put this education to use within my career!! Thank you for creating this material!" - Rick WIlliams Content and Overview All you need to do the course is basic experience with Windows programs. If you have or are using Excel, that is even better. Much of the course is presented as a comparison to Excel and explains what tasks each program is best suited for. Even though there are many lectures and several hours of content, each section focuses on one set of concepts so it is easy to do one section at a time, when your schedule allows. You will find that each chapter builds on the previous one as you build your understanding of Access, one step at a time. By the time you have finished the course you will have done so much with Access and it will be so familiar that you will be ready to tackle your own data tasks immediately , putting your new learned skills into practical use and impressing your boss and coworkers. The course is complete with working files and finished samples for everything that is covered. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course. Click the Take This Course button to take your first step towards quickly increasing your income! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund! From Another Student Review: 5 Stars - Absolutely the Best Course I Have Taken I am not one to write many reviews, but when a course has reached beyond my expectations, I had no choice but to give compliments to the author Mr. Bruce Myron. The content of the course was extremely comprehensive and informative in which every student will walk away having the best foundation of MS Access one can get. The clarity and tone of each video had me eager to learn more and has already assisted me with applications I had at work. With the knowledge I have gained, not only will it help separate myself from my co-workers, but allow me to increase my income over time. The greatest treat one will get in this course is the interaction from Mr. Myron. He is absolutely the difference maker from any other course I had taken and made me feel that I was not alone while taking this course. I cannot wait to begin the other courses to get to the next level of my career. Trust me, when it comes to learning MS Access from the ground up through Mr. Myron's courses, starting with Excel To Access: Intro to Access for Excel Users, one will be ecstatic with the results. - David Richardson Another Student Review: 5 Stars - Brilliant piece of work! Thanks Bruce for making these lectures. They are very well done, relevant and clear. I have literally copied line for line of many of these lectures into a project i am working on. Highly recommended also are the other videos which also contain golden nuggets: Access to Excel to Outlook, Access to Excel-Instant Reports and pivot tables, Microsoft Access vba for non programmers. And as a bonus, Bruce has been very helpful in answering, guiding and explaining content from his lecture when i asked for clarification. Brilliant Bruce, thanks again - Steven Kawuma Required Software You should have Office 2010 or later. The course was created using Office 2013. Who this course is for: This course is perfect for anyone who wants to learn Access quickly and understand the differences between Access and Excel. Show more Show less Featured review Vedad Suljić 3 courses 2 reviews Rating: 4.5 out of 5 a year ago For me as someone who had zero knowledge and experience in MS Access this was a very good course to get not just basic but also advanced knowledge. Bruce is well experienced and you can just feel it. If I have to find a con, this would be it. At some parts he spends to much time for editing, although I consider this as important, but in the course it's just important to get the message. All in all. BRAVO Show more Show less Course content 20 sections • 120 lectures • 10h 0m total length Expand all sections Introduction - Course Layout and Objectives 3 lectures • 6min Course Introduction 00:35 Course Overview by Section Preview 05:18 Important NOTE on DOWNLOADABLE RESOURCES 00:19 Why You Need Access 3 lectures • 8min Comparing the Access and Excel Screens Preview 02:06 Why You Need Access Preview 02:33 Where Do We Go From Here? Preview 03:46 The TABLE Object 14 lectures • 1hr 9min Intro to Tables and Tabbed vs Overlap View Preview 06:35 Editing, Adding and Deleting Records 07:25 Sorting a Table 03:13 Basic Filters 04:07 Advanced Filters 07:42 Using Find and Replace with Tables 06:12 Create a Table and add a Primary Key and Fields 04:52 Create Table 2 - Add the Rest of the Fields to the Table 05:28 Create Table 3 - Why Are There So Many Numeric Field Sizes? 01:46 List of Reserved Words 8 pages Table Properties 1 - Formats and Input Masks 05:05 Table Properties 2 - Defaults and Validation Rules 06:09 Table Properties 3 - Add Lookups to a Table 05:26 Modify Table Design - Add, Delete and Move Fields 05:23 The REPORT Object 11 lectures • 1hr 13min Introduction and Create a Report Preview 05:52 Using the Report Wizard Preview 06:08 What Are Controls? 04:46 Report View and Layout View 04:46 Modify the Report Design and Selecting Controls 08:22 Entering Formulas into Text Boxes 10:08 Sorting and Subtotals in Reports 07:14 Conditional Formatting 03:48 The Properties Box 06:46 Using the Properties Box 12:55 Conclusion and Why We Need Queries 02:20 The QUERY Object - SELECT Queries 11 lectures • 46min Overview of Select Queries Database 03:15 Intro to Select Queries Preview 06:15 Sorting in Select Queries Preview 04:00 Using Criteria in Queries - And vs OR 04:14 Using Criteria in Queries - Wildcards 04:22 List of Query Wildcard Characters 2 pages Using Criteria in Queries - Formulas in Criteria 03:01 Calculations in Select Queries 05:01 Multiple Tables in Queries 06:55 Parameters in queries 04:53 A Parameter Query Trick 04:29 Reports Revisited 4 lectures • 22min Review the Report Source Table Structure 05:54 Using a Select Query as a Report Source 02:41 Setting up Date Parameters 06:27 Final Touch - a Title with Dates 07:17 Unique Value, TOP and Total Queries 5 lectures • 31min Unique Value Queries - Part 1 04:22 Unique Value Queries - Part 2 05:54 TOP queries 06:15 Total Queries - Part 1 06:56 Total Queries - Part 2 07:03 ACTION Queries 6 lectures • 33min Intro to Action Queries with a Make Table Query 05:26 Append Query 06:51 Delete Query 03:38 Update Qry Part 1 - Increase Prices 02:54 Update Query 2 - Add an Order Total Field 09:05 A Quick MACRO to Automate Updating the Order Totals 05:09 Migrating from Excel to Access 1: Get the Data Into Access 3 lectures • 16min Import Problems 1 - Heading not removed Preview 03:33 Import Problems 2 - Common Import Errors Preview 08:43 A Clean Import - but is it? Preview 03:44 Migrating from Excel to Access 2: Design the Correct Structure 9 lectures • 31min Combine data in Excel before bringing into Access 04:35 Planning Your Database - 3 Best Practices - NUMBER 1 03:47 Planning Your Database - 3 Best Practices - NUMBER 2