How to use Microsoft Access - Beginner Tutorial

Veröffentlicht am: 25 Februar 2021
auf dem Kanal: Kevin Stratvert
3,193,036
71k

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-O...

⌚ 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:    • 💜 How to use Microsoft Teams  

🙌📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn:   / kevinstratvert  
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter:   / kevstrat  
- Facebook:   / kevin-stratvert-101912218227818  
- TikTok:   / kevinstratvert  
- Instagram:   / kevinstratvert  

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?...

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ 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


Auf dieser Seite können Sie das Online-Video How to use Microsoft Access - Beginner Tutorial mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Kevin Stratvert 25 Februar 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 3,193,036 Mal angesehen und es wurde von 71 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!