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:
⌚ 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:
🙌📩 NEWSLETTER
– Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week:
🔽 CONNECT WITH ME
– Official website:
– LinkedIn:
– Discord:
– Twitter:
– Facebook:
– TikTok:
– Instagram:
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off |
✅ 🌐 Squarespace Websites |
✅ 🔍 Grammarly |
✅ 🛍️ Shopify |
✅ 📋 Notion |
✅ 🖼️ Figma |
✅ 🤖 ElevenLabs Text-to-Speech |
🎒 MY COURSES
– Go from Excel novice to data analysis ninja in just 2 hours:
🙏 REQUEST VIDEOS
🔔 SUBSCRIBE ON YOUTUBE
🙌 SUPPORT THE CHANNEL
– Hit the THANKS button in any video!
– Amazon affiliate link:
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert
