In this step-by-step tutorial, learn how to use Microsoft Access. We walk what Access is for, why you should use it over a spreadsheet, how to create tables, how to add a form, how to run SQL queries, and how to create a report. By the end of this video, you'll understand the fundamentals of working with databases in Access. Additional resources: - My Access database: https://1drv.ms/u/s!AmxrofZZlZ-whKx-OHtH9VLpU4PdJw?e=0aRP1p Timestamps 0:00 Introduction 1:01 Advantages of a database over Excel 2:36 Access alternatives 3:17 Overview of tutorial structure 4:10 Access start page 5:04 Create blank database 5:22 Tables, fields & records 14:36 Calculated field & expression builder 15:50 Sample order data 16:50 Opening & closing windows 17:16 Relationships 19:01 Import data sources 19:25 Forms 22:12 Queries 27:51 Reports 30:02 Save Database 30:25 Wrap up Watch related playlists and videos - Playlist with all my videos on Access: https://youtube.com/playlist?list=PLlKpQrBME6xJ4Mxv00syl8iOSgL-GVLMG Connect with me on social: - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com Support me with your Amazon purchases: https://amzn.to/3kCP2yz As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same. #stratvert