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.
📚 RESOURCES
– Sample Access database: https://1drv.ms/u/s!AmxrofZZlZ-whKx-OHtH9VLpU4PdJw?e=0aRP1p
⌚ TIMESTAMPS
00:00 Introduction
01:01 Advantages of a database over Excel
02:36 Access alternatives
03:17 Overview of tutorial structure
04:10 Access start page
05:04 Create blank database
05: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
📺 RELATED VIDEOS
– Playlist with all my videos on Access: https://youtube.com/playlist?list=PLlKpQrBME6xJ4Mxv00syl8iOSgL-GVLMG
🙌 SUPPORT THE CHANNEL
– Hit the THANKS button in any video!
– Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel — the price to you is the same)
🔽 CONNECT WITH ME
– Official web site: http://www.kevinstratvert.com
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Discord: https://discord.gg/kHuujY2pZf
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert
– Instagram: https://www.instagram.com/kevinstratvert/
🎒 MY COURSES
– Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1
#stratvert
source