MS Access for Absolute Beginners

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

Course Description

This course introduces students to MS Access

  • Learn how to start using MS Access from scratch
  • Learn how to create tables
  • Learn how to import and export data using MS Access
  • Learn how to use queries to select data, perform calculations, modify tables, delete data, update databases, as well as other functions

The course is suitable for beginners, as well as anyone who would like to learn a new skill.

***Course Instructor Revenue will be donated to charity

Who this course is for:

  • This course is suitable for MS Access beginners
  • Anyone who would like to learn how to work with databases

Course content

5 sections • 23 lectures • 1h 49m total length

Instructor

Financial Analyst and Excel Enthusiast
  • 4.2 Instructor Rating
  • 463 Reviews
  • 9,263 Students
  • 2 Courses

Hi Everyone, and Thank You for considering this course!

Over the last 10 years I have performed various financial analysis roles in the banking and financial securities industries, and have extensively used MS Excel and MS Access for personal financial planning, working with customer data, financial modelling, management reporting, and project analysis. I hope to share some of my knowledge and experience with you.

Expected Outcomes

  1. Build MS Access Tables Extract Data from Tables Build New Tables, Update Tables, Merge Tables, and other Database skills Import and Export Data To/From MS Access Perform basic calculations in MS Access Requirements MS Access installed on a PC or a Laptop. Description This course introduces students to MS Access Learn how to start using MS Access from scratch Learn how to create tables Learn how to import and export data using MS Access Learn how to use queries to select data, perform calculations, modify tables, delete data, update databases, as well as other functions The course is suitable for beginners, as well as anyone who would like to learn a new skill. ***Course Instructor Revenue will be donated to charity Who this course is for: This course is suitable for MS Access beginners Anyone who would like to learn how to work with databases Show more Show less Course content 5 sections • 23 lectures • 1h 49m total length Expand all sections Introduction 1 lecture • 2min Introduction (and Course Files) Preview 01:58 Working with Tables 5 lectures • 26min Creating a Table Preview 05:49 Creating a Table using Table Design 05:15 Import External Data into Access 05:52 Import External Data in CSV/TXT 06:04 Export MS Access tables to an external format 02:49 Working with MS Access Queries 12 lectures • 1hr 8min Select Query 10:57 Calculate within the Select Query 05:36 Make Table Query Preview 04:58 Append Query 04:48 Update Query 06:23 CrossTab Query 09:56 Delete Query 03:55 Start using the Query Wizard: Select Query 04:51 Query Wizard: CrossTab 02:36 Find duplicate records in a Database 03:46 Remove duplicate records from a Database 06:49 Unmatched Query Wizard 03:51 Relationship Between Tables 2 lectures • 8min Relate two tables together 02:31 Change Table Join Relationships 05:47 Working with Functions 3 lectures • 5min SUM Functions 01:17 AVG (Average) Function 01:13 MIN and MAX Function 02:01 Instructor Stanley Ka Financial Analyst and Excel Enthusiast 4.2 Instructor Rating 463 Reviews 9,263 Students 2 Courses Hi Everyone, and Thank You for considering this course! Over the last 10 years I have performed various financial analysis roles in the banking and financial securities industries, and have extensively used MS Excel and MS Access for personal financial planning, working with customer data, financial modelling, management reporting, and project analysis. I hope to share some of my knowledge and experience with you. 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:'678140bd4c6840d7',m:'a4154dc426dab1cd340b1ac57775e54a9b763d13-1627843835-1800-AUyedRUAoUh/JLDzqX0V/87H68dWlrhNMjvpgb3APZfRtMOCvuE5SIGiCQuBgnjh8e9j90h7UYa3BtdbVHdTOLQvkbGORQjCyKCKaOvSg5add+oNKs/jFSz6pzYIUWkZa3R51D6H7iSzjmXYPn5RXL4GNr3EbwGaBh9iyEXtIaT2',s:[0x8bd643b39c,0xc23af6f841],}})();
  2. Extract Data from Tables Build New Tables, Update Tables, Merge Tables, and other Database skills Import and Export Data To/From MS Access Perform basic calculations in MS Access Requirements MS Access installed on a PC or a Laptop. Description This course introduces students to MS Access Learn how to start using MS Access from scratch Learn how to create tables Learn how to import and export data using MS Access Learn how to use queries to select data, perform calculations, modify tables, delete data, update databases, as well as other functions The course is suitable for beginners, as well as anyone who would like to learn a new skill. ***Course Instructor Revenue will be donated to charity Who this course is for: This course is suitable for MS Access beginners Anyone who would like to learn how to work with databases Show more Show less Course content 5 sections • 23 lectures • 1h 49m total length Expand all sections Introduction 1 lecture • 2min Introduction (and Course Files) Preview 01:58 Working with Tables 5 lectures • 26min Creating a Table Preview 05:49 Creating a Table using Table Design 05:15 Import External Data into Access 05:52 Import External Data in CSV/TXT 06:04 Export MS Access tables to an external format 02:49 Working with MS Access Queries 12 lectures • 1hr 8min Select Query 10:57 Calculate within the Select Query 05:36 Make Table Query Preview 04:58 Append Query 04:48 Update Query 06:23 CrossTab Query 09:56 Delete Query 03:55 Start using the Query Wizard: Select Query 04:51 Query Wizard: CrossTab 02:36 Find duplicate records in a Database 03:46 Remove duplicate records from a Database 06:49 Unmatched Query Wizard 03:51 Relationship Between Tables 2 lectures • 8min Relate two tables together 02:31 Change Table Join Relationships 05:47 Working with Functions 3 lectures • 5min SUM Functions 01:17 AVG (Average) Function 01:13 MIN and MAX Function 02:01 Instructor Stanley Ka Financial Analyst and Excel Enthusiast 4.2 Instructor Rating 463 Reviews 9,263 Students 2 Courses Hi Everyone, and Thank You for considering this course! Over the last 10 years I have performed various financial analysis roles in the banking and financial securities industries, and have extensively used MS Excel and MS Access for personal financial planning, working with customer data, financial modelling, management reporting, and project analysis. I hope to share some of my knowledge and experience with you. 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:'678140bd4c6840d7',m:'a4154dc426dab1cd340b1ac57775e54a9b763d13-1627843835-1800-AUyedRUAoUh/JLDzqX0V/87H68dWlrhNMjvpgb3APZfRtMOCvuE5SIGiCQuBgnjh8e9j90h7UYa3BtdbVHdTOLQvkbGORQjCyKCKaOvSg5add+oNKs/jFSz6pzYIUWkZa3R51D6H7iSzjmXYPn5RXL4GNr3EbwGaBh9iyEXtIaT2',s:[0x8bd643b39c,0xc23af6f841],}})();
  3. Build New Tables, Update Tables, Merge Tables, and other Database skills Import and Export Data To/From MS Access Perform basic calculations in MS Access Requirements MS Access installed on a PC or a Laptop. Description This course introduces students to MS Access Learn how to start using MS Access from scratch Learn how to create tables Learn how to import and export data using MS Access Learn how to use queries to select data, perform calculations, modify tables, delete data, update databases, as well as other functions The course is suitable for beginners, as well as anyone who would like to learn a new skill. ***Course Instructor Revenue will be donated to charity Who this course is for: This course is suitable for MS Access beginners Anyone who would like to learn how to work with databases Show more Show less Course content 5 sections • 23 lectures • 1h 49m total length Expand all sections Introduction 1 lecture • 2min Introduction (and Course Files) Preview 01:58 Working with Tables 5 lectures • 26min Creating a Table Preview 05:49 Creating a Table using Table Design 05:15 Import External Data into Access 05:52 Import External Data in CSV/TXT 06:04 Export MS Access tables to an external format 02:49 Working with MS Access Queries 12 lectures • 1hr 8min Select Query 10:57 Calculate within the Select Query 05:36 Make Table Query Preview 04:58 Append Query 04:48 Update Query 06:23 CrossTab Query 09:56 Delete Query 03:55 Start using the Query Wizard: Select Query 04:51 Query Wizard: CrossTab 02:36 Find duplicate records in a Database 03:46 Remove duplicate records from a Database 06:49 Unmatched Query Wizard 03:51 Relationship Between Tables 2 lectures • 8min Relate two tables together 02:31 Change Table Join Relationships 05:47 Working with Functions 3 lectures • 5min SUM Functions 01:17 AVG (Average) Function 01:13 MIN and MAX Function 02:01 Instructor Stanley Ka Financial Analyst and Excel Enthusiast 4.2 Instructor Rating 463 Reviews 9,263 Students 2 Courses Hi Everyone, and Thank You for considering this course! Over the last 10 years I have performed various financial analysis roles in the banking and financial securities industries, and have extensively used MS Excel and MS Access for personal financial planning, working with customer data, financial modelling, management reporting, and project analysis. I hope to share some of my knowledge and experience with you. 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:'678140bd4c6840d7',m:'a4154dc426dab1cd340b1ac57775e54a9b763d13-1627843835-1800-AUyedRUAoUh/JLDzqX0V/87H68dWlrhNMjvpgb3APZfRtMOCvuE5SIGiCQuBgnjh8e9j90h7UYa3BtdbVHdTOLQvkbGORQjCyKCKaOvSg5add+oNKs/jFSz6pzYIUWkZa3R51D6H7iSzjmXYPn5RXL4GNr3EbwGaBh9iyEXtIaT2',s:[0x8bd643b39c,0xc23af6f841],}})();
  4. Import and Export Data To/From MS Access Perform basic calculations in MS Access Requirements MS Access installed on a PC or a Laptop. Description This course introduces students to MS Access Learn how to start using MS Access from scratch Learn how to create tables Learn how to import and export data using MS Access Learn how to use queries to select data, perform calculations, modify tables, delete data, update databases, as well as other functions The course is suitable for beginners, as well as anyone who would like to learn a new skill. ***Course Instructor Revenue will be donated to charity Who this course is for: This course is suitable for MS Access beginners Anyone who would like to learn how to work with databases Show more Show less Course content 5 sections • 23 lectures • 1h 49m total length Expand all sections Introduction 1 lecture • 2min Introduction (and Course Files) Preview 01:58 Working with Tables 5 lectures • 26min Creating a Table Preview 05:49 Creating a Table using Table Design 05:15 Import External Data into Access 05:52 Import External Data in CSV/TXT 06:04 Export MS Access tables to an external format 02:49 Working with MS Access Queries 12 lectures • 1hr 8min Select Query 10:57 Calculate within the Select Query 05:36 Make Table Query Preview 04:58 Append Query 04:48 Update Query 06:23 CrossTab Query 09:56 Delete Query 03:55 Start using the Query Wizard: Select Query 04:51 Query Wizard: CrossTab 02:36 Find duplicate records in a Database 03:46 Remove duplicate records from a Database 06:49 Unmatched Query Wizard 03:51 Relationship Between Tables 2 lectures • 8min Relate two tables together 02:31 Change Table Join Relationships 05:47 Working with Functions 3 lectures • 5min SUM Functions 01:17 AVG (Average) Function 01:13 MIN and MAX Function 02:01 Instructor Stanley Ka Financial Analyst and Excel Enthusiast 4.2 Instructor Rating 463 Reviews 9,263 Students 2 Courses Hi Everyone, and Thank You for considering this course! Over the last 10 years I have performed various financial analysis roles in the banking and financial securities industries, and have extensively used MS Excel and MS Access for personal financial planning, working with customer data, financial modelling, management reporting, and project analysis. I hope to share some of my knowledge and experience with you. 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:'678140bd4c6840d7',m:'a4154dc426dab1cd340b1ac57775e54a9b763d13-1627843835-1800-AUyedRUAoUh/JLDzqX0V/87H68dWlrhNMjvpgb3APZfRtMOCvuE5SIGiCQuBgnjh8e9j90h7UYa3BtdbVHdTOLQvkbGORQjCyKCKaOvSg5add+oNKs/jFSz6pzYIUWkZa3R51D6H7iSzjmXYPn5RXL4GNr3EbwGaBh9iyEXtIaT2',s:[0x8bd643b39c,0xc23af6f841],}})();
  5. Perform basic calculations in MS Access Requirements MS Access installed on a PC or a Laptop. Description This course introduces students to MS Access Learn how to start using MS Access from scratch Learn how to create tables Learn how to import and export data using MS Access Learn how to use queries to select data, perform calculations, modify tables, delete data, update databases, as well as other functions The course is suitable for beginners, as well as anyone who would like to learn a new skill. ***Course Instructor Revenue will be donated to charity Who this course is for: This course is suitable for MS Access beginners Anyone who would like to learn how to work with databases Show more Show less Course content 5 sections • 23 lectures • 1h 49m total length Expand all sections Introduction 1 lecture • 2min Introduction (and Course Files) Preview 01:58 Working with Tables 5 lectures • 26min Creating a Table Preview 05:49 Creating a Table using Table Design 05:15 Import External Data into Access 05:52 Import External Data in CSV/TXT 06:04 Export MS Access tables to an external format 02:49 Working with MS Access Queries 12 lectures • 1hr 8min Select Query 10:57 Calculate within the Select Query 05:36 Make Table Query Preview 04:58 Append Query 04:48 Update Query 06:23 CrossTab Query 09:56 Delete Query 03:55 Start using the Query Wizard: Select Query 04:51 Query Wizard: CrossTab 02:36 Find duplicate records in a Database 03:46 Remove duplicate records from a Database 06:49 Unmatched Query Wizard 03:51 Relationship Between Tables 2 lectures • 8min Relate two tables together 02:31 Change Table Join Relationships 05:47 Working with Functions 3 lectures • 5min SUM Functions 01:17 AVG (Average) Function 01:13 MIN and MAX Function 02:01 Instructor Stanley Ka Financial Analyst and Excel Enthusiast 4.2 Instructor Rating 463 Reviews 9,263 Students 2 Courses Hi Everyone, and Thank You for considering this course! Over the last 10 years I have performed various financial analysis roles in the banking and financial securities industries, and have extensively used MS Excel and MS Access for personal financial planning, working with customer data, financial modelling, management reporting, and project analysis. I hope to share some of my knowledge and experience with you. 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:'678140bd4c6840d7',m:'a4154dc426dab1cd340b1ac57775e54a9b763d13-1627843835-1800-AUyedRUAoUh/JLDzqX0V/87H68dWlrhNMjvpgb3APZfRtMOCvuE5SIGiCQuBgnjh8e9j90h7UYa3BtdbVHdTOLQvkbGORQjCyKCKaOvSg5add+oNKs/jFSz6pzYIUWkZa3R51D6H7iSzjmXYPn5RXL4GNr3EbwGaBh9iyEXtIaT2',s:[0x8bd643b39c,0xc23af6f841],}})();