Access

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: 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: youtube.com/playlist?list=PLlKpQrBME6xJ4Mxv00syl8iOSgL-GVLMG

🚩 Connect with me on social
- LinkedIn: linkedin.com/in/kevinstratvert/
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert/

🙏 Request How To Tutorial Videos
forms.gle/BDrTNUoxheEoMLGt5

🔔 Subscribe to my YouTube channel
youtube.com/user/kevlers?sub_confirmation=1

🎬 Want to watch again? Navigate back to my YouTube channel quickly
kevinstratvert.com

🛍 Support me with your Amazon purchases: 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