How to use Microsoft Access - Beginner Tutorial

Share this & earn $10
Kevin Stratvert
Published at : 11 Nov 2021
600168 views
16874
164

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

kevin stratvertaccessmicrosoft access

The Junction - Vital ingredients for a long lasting relationship. 5h Oct 2021

The Junction - Vital ingredients for a long lasting relationship. 5h Oct 2021

Energy | The Dr. Binocs Show | Educational Videos For Kids

Energy | The Dr. Binocs Show | Educational Videos For Kids

Enrique Iglesias - Ring My Bells (Lyrics)

Enrique Iglesias - Ring My Bells (Lyrics)

The Greek '90s Dance NonStopMix | OFFICIAL Part 1

The Greek '90s Dance NonStopMix | OFFICIAL Part 1

How to get Pleasure of Allah | Class 3: Things that matter

How to get Pleasure of Allah | Class 3: Things that matter

What is a Weblog (Blog)?

What is a Weblog (Blog)?

[5-0] | 26.09.2021 |  Arsenal Women vs Manchester City Women | FA WSL 2021-22 | Week 3

[5-0] | 26.09.2021 | Arsenal Women vs Manchester City Women | FA WSL 2021-22 | Week 3

HOW TO SOCIALIZE WITH PEOPLE

HOW TO SOCIALIZE WITH PEOPLE

The Offspring - "Self Esteem"

The Offspring - "Self Esteem"

Because of Who you Are-Vicki Yohe

Because of Who you Are-Vicki Yohe

Melissa & Doug Suspend Family Game

Melissa & Doug Suspend Family Game

1. Introduction to Delegated Legislation

1. Introduction to Delegated Legislation

Correlation Does Not Imply Causation | Neil Barnes | RocketMill

Correlation Does Not Imply Causation | Neil Barnes | RocketMill

10 Work From Home Jobs that Pay $100/Day or More! (2021)

10 Work From Home Jobs that Pay $100/Day or More! (2021)

Government Is (Usually) Bad News, God Is (The) Good News

Government Is (Usually) Bad News, God Is (The) Good News

7 Monthly Dividend Funds and How to Find the Perfect ETF

7 Monthly Dividend Funds and How to Find the Perfect ETF

Plastic Flowers

Plastic Flowers

The Neighbourhood - Female Robbery (Official Video)

The Neighbourhood - Female Robbery (Official Video)

RANGEMENT et TRIE EXTRÊME de ma chambre * Satisfaisant*

RANGEMENT et TRIE EXTRÊME de ma chambre * Satisfaisant*

The TWO feat. Bastoun - ROSEDA (Ti Frere Cover)

The TWO feat. Bastoun - ROSEDA (Ti Frere Cover)

plenka - in point of fact

plenka - in point of fact

8 Things People with Anxiety Want You to Know

8 Things People with Anxiety Want You to Know

easily - bruno major || lyrics

easily - bruno major || lyrics

20 Simple and Cheap Home Improvements Ideas

20 Simple and Cheap Home Improvements Ideas

Question song for kids | Is it? | Yes it is | No it isn't

Question song for kids | Is it? | Yes it is | No it isn't

10 Ingenious Tricks That Will Take You to Another Level of Work – Tips and Tricks

10 Ingenious Tricks That Will Take You to Another Level of Work – Tips and Tricks

THE LAST STRAW! BBC 'Stoned' As PARTIAL To Haz&Meg Over William After Documentary BLASTED OUTRAGE

THE LAST STRAW! BBC 'Stoned' As PARTIAL To Haz&Meg Over William After Documentary BLASTED OUTRAGE

Nobody Noticed These NEW Accessories Have Special Effects!? (ROBLOX)

Nobody Noticed These NEW Accessories Have Special Effects!? (ROBLOX)

How many voters does it take to make socialism ethical?

How many voters does it take to make socialism ethical?

Η καταστροφή του ανθρώπου (Μέρος 1ο)

Η καταστροφή του ανθρώπου (Μέρος 1ο)

WITH REGARD TO vs. WITH REGARDS TO || Pinay English Teacher

WITH REGARD TO vs. WITH REGARDS TO || Pinay English Teacher

Sofia The First | All You Desire - Song | Disney Junior UK

Sofia The First | All You Desire - Song | Disney Junior UK

Gucci Mane Lots Of Cash

Gucci Mane Lots Of Cash

Bruno Mars, Anderson .Paak, Silk Sonic - Leave the Door Open [Official Video]

Bruno Mars, Anderson .Paak, Silk Sonic - Leave the Door Open [Official Video]

Sadhguru About Why Angry - Short Tempered People Are More Intense | Spiritual Guru

Sadhguru About Why Angry - Short Tempered People Are More Intense | Spiritual Guru

*FIDGET TOYS* Decide What I TRADE In Adopt Me Roblox !! Roblox Adopt Me Trading And FIDGET TRADING

*FIDGET TOYS* Decide What I TRADE In Adopt Me Roblox !! Roblox Adopt Me Trading And FIDGET TRADING

Bugoy na Koykoy - Tanga Akin To

Bugoy na Koykoy - Tanga Akin To

Depeche Mode - Useless (Official Video)

Depeche Mode - Useless (Official Video)

When sales go wrong - Great Deal

When sales go wrong - Great Deal

Ready As I'll Ever Be 🍳  | Music Video | Tangled: The Series | Disney Channel

Ready As I'll Ever Be 🍳 | Music Video | Tangled: The Series | Disney Channel

🔵 Under No Circumstances - Under No Circumstances + Inversion - Under No Circumstances Grammar - ESL

🔵 Under No Circumstances - Under No Circumstances + Inversion - Under No Circumstances Grammar - ESL

Link Building for Beginners: Complete Guide to Get Backlinks in 2020

Link Building for Beginners: Complete Guide to Get Backlinks in 2020

Hozier - Almost (Sweet Music) (Official Video)

Hozier - Almost (Sweet Music) (Official Video)

Zephyr Drama Club Sum Of Money Chukchu Nite

Zephyr Drama Club Sum Of Money Chukchu Nite

Before You Judge Me, Make Sure You're Perfect // Baddie Quotes (Kixxsy)

Before You Judge Me, Make Sure You're Perfect // Baddie Quotes (Kixxsy)

Magnetism | The Dr. Binocs Show | Educational Videos For Kids

Magnetism | The Dr. Binocs Show | Educational Videos For Kids

Tiësto - The Business (Robert Cristian Remix) | RX7 Night Drive

Tiësto - The Business (Robert Cristian Remix) | RX7 Night Drive

Economical (All Levels Gold)

Economical (All Levels Gold)

It is a comfortable precision cold welding process!

It is a comfortable precision cold welding process!