Step-by-step tutorial: Building an inventory management system and invoice registration in Access

190 views

ZinTechPro

Published on Dec 19, 2024
About :

In this tutorial, we will show you how to design a simple and functional system for recording sales invoices and managing inventory in Microsoft Access. This project includes designing a main form for invoice details, connecting the forms to tables, and writing VBA code to automatically store information in the tables. If you want to do the sales process, manage inventory, and update customer information in the simplest way possible in Access, this video is for you! What you will learn in this video: Create main tables (products, customers, invoices) Design a main form to receive information Connect forms to tables and automatically connect data Write VBA code to record invoices and details in tables Manage and update inventory and customer accounts This tutorial is very suitable for beginners and those who are looking for a practical and simple project in Access. Be sure to watch until the end and share your comments with us! 00:00 Introduction and introduction to the project 01:20 Creating main tables (products, customers, invoices) 04:00 Designing the main form for registering invoices 08:40 Writing VBA code to register invoices in the Invoices table 10:40 How to update inventory and customer accounts 11:20 Creating a query and report on issued invoices #microsoftaccess #access #system #warehouse #registering_invoices #project #vba #training #sales_management #programming

  • vidoe Comments
Trend Videos
5:36
[Grand Prize] Jang Na-ra of 'Good Partner' wins the grand prize!
SBS Drama
897,101 views   2 days ago
5:54
21 years since debut, skills that never go away👏 'Lover' that touches everyone's heartstrings♬ TV CHOSUN 241219 broadcast [Mr. Trot 3 - Episode 1] TV Chosun
TVCHOSUN - TV조선
739,125 views   4 days ago
30:36
Ryu Hyun-jin talks about the differences between the major league and the KBO
이대호 [RE:DAEHO]
1,048,668 views   7 days ago
12:17
A day when my heart ached like it was torn apart
삐루빼로
1,425,481 views   5 days ago
32:10
“Next year, it’ll really! Totally! Be different~!” The reason Ryu-Yoon-Kim are paying attention to Hanwha Eagles Cyber ​​Yoon Seok-min Ep. Ryu Hyun-jin + Kim Kwang-hyun-2 (There’s an event~★)
사이버 윤석민
518,118 views   3 days ago
32:10
“Next year, it’ll really! Totally! Be different~!” The reason Ryu-Yoon-Kim are paying attention to Hanwha Eagles Cyber ​​Yoon Seok-min Ep. Ryu Hyun-jin + Kim Kwang-hyun-2 (There’s an event~★)
사이버 윤석민
518,118 views   3 days ago
3:34
This is how to eat winter cabbage and apples🥬I've been eating it every day instead of breakfast these days, and my belly fat has gone down (ft. cabbage and apple salad, homemade tofu mayonnaise)
쿠킹 프린세스 cooking
676,333 views   10 days ago
17:33
Lee Young-ja and Park Se-ri drinking ginseng wine and talking drunk
이영자 TV
1,554,018 views   5 days ago
21:33
Sister, see you on Saturday❤ Younger man Kang Hoon collection! 〈Red Velvet & Espa – Beautiful Christmas♪〉 #highlight#amazingsaturday amazingsaturday EP.346
놀라운 토요일 Amazing Saturday
308,123 views   2 days ago
17:33
Lee Young-ja and Park Se-ri drinking ginseng wine and talking drunk
이영자 TV
1,554,018 views   5 days ago
23:38
The ultimate skyblock survival game
우융
434,032 views   6 days ago
3:19
Tell Me - Jinusean (With Jang Wonyoung) [2024 KBS Song Festival Global Festival] KBS 241220 Broadcast
KBS Kpop
1,542,950 views   3 days ago
2:33
[Pre-release] The youngest contestant on Mr. Trot 3, 8 years old, is 'true'!
미스&미스터트롯
618,962 views   5 days ago
2:20
[Superman] Teaser Trailer
Warner Bros. Korea
1,774,190 views   4 days ago
3:19
Tell Me - Jinusean (With Jang Wonyoung) [2024 KBS Song Festival Global Festival] KBS 241220 Broadcast
KBS Kpop
1,542,950 views   3 days ago
14:55
Unforgettable wedding vlog
담다미담
481,636 views   6 days ago
34:11
Birthday party on a deserted island the size of a booger 【Philippines 2】
빠니보틀 Pani Bottle
778,656 views   5 days ago
6:58
A stage like a drama with a story😢 'Thank you, life'♬ TV CHOSUN 241219 broadcast [Mr. Trot 3 - Episode 1] TV Chosun
TVCHOSUN - TV조선
639,904 views   4 days ago
15:39
I wonder where he is and what he is doing.. Suddenly a sewing machine
원지의하루
333,890 views   2 days ago
12:17
A day when my heart ached like it was torn apart
삐루빼로
1,425,481 views   5 days ago
14:35
Lilka becomes a T1 teacher
릴카
650,453 views   2 days ago
24:43
mukbang, spicy, kimchi.
나나먹방 Nana mukbang
162,479 views   6 days ago
3:34
This is how to eat winter cabbage and apples🥬I've been eating it every day instead of breakfast these days, and my belly fat has gone down (ft. cabbage and apple salad, homemade tofu mayonnaise)
쿠킹 프린세스 cooking
676,333 views   10 days ago
15:39
I wonder where he is and what he is doing.. Suddenly a sewing machine
원지의하루
333,890 views   2 days ago
2:20
[Superman] Teaser Trailer
Warner Bros. Korea
1,774,190 views   4 days ago
29:25
2024🎄 The most expensive Guerlain advent calendar vs. the cheapest Benefit advent calendar
회사원A
400,196 views   3 days ago
14:35
Lilka becomes a T1 teacher
릴카
650,453 views   2 days ago
27:57
[Highlight] More frustrating for those watching💥 What is the fate of 'Jorimping' Choi Kang-rok who entered the 15-minute world view?! Please Take Care of My Refrigerator JTBC 241222 Broadcast
JTBC Entertainment
923,109 views   1 day ago
12:08
vlog * PC room part-time job vlog Why is this real?
도민이
349,389 views   8 days ago
5:54
21 years since debut, skills that never go away👏 'Lover' that touches everyone's heartstrings♬ TV CHOSUN 241219 broadcast [Mr. Trot 3 - Episode 1] TV Chosun
TVCHOSUN - TV조선
739,125 views   4 days ago
8:48
I messed up my Japanese university interview and Q&A
수쩡민
372,124 views   7 days ago
24:40
Hermit Lee Hae-ri's villa breeding
걍밍경
926,785 views   4 days ago
Google AdSense
336 x 280
Up Next
33:30
WE CHANGED THE CHILDREN FOR 24 HOURS WITH CEREN YALDIZ!? (HE GOES CRAZY!) @Cerenyaldz @OykuKarta
Gamze Karta
5,418,152 views
9 months ago
35:04
SPENDING A DAY WITHOUT INTERNET #24Hours (NO TV, PHONE, TABLET!!
Gamze Karta
1,656,308 views
1 year ago
26:40
SPENDING A DAY CARING FOR 4 BABIES!! (Öykü Was Very Jealous)
Gamze Karta
2,059,680 views
1 year ago
17:26
I SNEAKENED TO MY SISTER'S HOUSE AT NIGHT AND SCARED HER!? (Horror Joke) Ahmet Can Dündar Sıla Dündar
Ahmet Can Dündar
5,806,206 views
1 year ago
8:46
Sushi date, lavash and lots of fun with the girls
Selcan Şahan
616 views
9 days ago
38:43
24 HOURS IN A TWO-ROOM TENT! LAST ONE OUT WINS
Rukiye Çetinkaya
2,201,511 views
3 weeks ago
22:41
WE ARE RELEASING A SONG WITH STORY!? @OykuKarta
Gamze Karta
1,858,698 views
11 months ago
32:09
WE BECAME A BRIDE WITH UZUNMAKARNA!? (WE DANCED IN THE STREET!) @uzunmakarna9841
Gamze Karta
2,953,349 views
9 months ago
44:43
WEEKEND SAPANCA HOLIDAY!! / VLOG
Gamze Karta
2,419,777 views
2 years ago
31:40
WE STAYED IN THE CAR FOR 24 HOURS AS A FAMILY, LAST ONE OUT WINS! (5000TL PRIZE)
Gamze Karta
3,191,987 views
1 year ago
22:44
We hid from @GamzeKarta for 24 hours with Öykü! 😂
Uzunmakarna
2,164,311 views
5 months ago
21:21
THE MOST AWAITED *Psychological Provocation* (WE ARE GETTING A DIVORCE!)
Gamze Karta
911,342 views
1 year ago
20:31
Being a mother of two for 24 hours! I LOOKED AT ATLAS AND STORY AT THE SAME TIME. (I GO CRAZY!!) @GamzeKarta
Ceren Yaldız
3,762,500 views
9 months ago
2:22:50
Far City Episode 7
Uzak Şehir
1,310,036 views
15 hours ago
17:14
OH MY GOD ELIF SINEM THERE IS A THIEF ‼️ ELIF CALL THE POLICE !! OH MY GOD THE PHONE IS LOST !!
SİNEM OYUNDA TV
89,974 views
2 days ago
1:00:20
Nastya and Maggie take care of her sister - Video series for children
Like Nastya TR
20,200 views
5 hours ago
23:00
WE KIDNAPPED GAMZE KARTA'S DAUGHTER!! GAMZE KARTA ÖYKÜ KARTA
Tuğba Eroğlu
2,332,302 views
2 months ago
32:33
DRAW or EAT COMPETITION THE BEST DRAWER WINS!
Rukiye Çetinkaya
1,219,611 views
10 days ago
15:41
ELIF CINEMA MY FATHER FELL SICK ‼️ HE DIDN'T TAKE MEDICINE THE DOCTOR CAME AND HE KNEW MY FATHER !!
SİNEM OYUNDA TV
20,684 views
6 hours ago
11:59
24 HOURS ONE COLOR CHALLENGE 🌈 @elifsinemtv ⁠@GamzeKarta
Prenses Öykü
1,941,487 views
1 year ago
13:18
WE TRIED FOREIGN COUNTRIES' SCHOOL MEALS! @GamzeKarta @Cerenyaldz
Prenses Öykü
669,150 views
8 months ago
13:57
ONE HAND, DOUBLE HAND, NO HAND EATING CHALLENGE!! PENALTY GAME WITH REWARDS!! @GamzeKarta @OykuKarta
ELİF SİNEM TV
562,451 views
1 year ago
15:37
ONE HAND, DOUBLE HAND, HANDLESS FOOD COMPETITION!? LOL DOLL AWARD WINNER!! ⁠@GamzeKarta
Prenses Öykü
799,645 views
7 months ago
18:57
Escape from Kuromi! IN ROBLOX! (In Ukrainian)
Sha Ksu
7,048 views
5 months ago
26:20
LARGE, MEDIUM, or SMALL FOOD COMPETITION!? LINA KOPTU
Rukiye Çetinkaya
10,679,153 views
1 year ago
26:30
WE BOUGHT DIFFERENT Snacks from Foreign Countries from Turkey! @GamzeKarta
Prenses Öykü
710,005 views
10 months ago
17:36
DRAW or EAT COMPETITION PENALTY CHALLENGE 🖊️ @GamzeKarta
Prenses Öykü
346,150 views
8 months ago
19:58
WE ATE ONLY NOODLES FOR A DAY!? @GamzeKarta
Prenses Öykü
851,122 views
10 months ago
18:41
I'M GETTING MARRIED ON MY BROTHER, A JOKE!? (ARDA CRIED)
Tuğba Eroğlu
1,234,451 views
1 month ago
11:33
EVERYTHING IS WRONG HERE!! 😱 WE'RE DIZZY!! @GamzeKarta
Prenses Öykü
2,579,998 views
2 years ago
16:01
24 HOURS ONE COLOR MARKET SHOPPING CHALLENGE 🌈 @GamzeKarta
Prenses Öykü
914,500 views
9 months ago
22:47
LARGE, MEDIUM or SMALL COOKING COMPETITION!! ELIF SINEM CRIED A LOT!!
ELİF SİNEM TV
1,834,465 views
1 year ago
19:57
2 CHILDREN SPENDING A DAY WATCHING YOUTUBER!? (I went crazy!) @OykuKarta @elifsinemtv
Gamze Karta
3,990,066 views
1 year ago
17:43
ELIF SINEM BECAME A TAILOR, LOTS OF CUSTOMERS CAME!! BARBIE DESIGNER SHOP!!
ELİF SİNEM TV
2,488,045 views
1 year ago
23:00
WE KIDNAPPED GAMZE KARTA'S DAUGHTER!! GAMZE KARTA ÖYKÜ KARTA
Tuğba Eroğlu
2,332,302 views
2 months ago
14:04
MY CAT IS LOST!? (We tried to tell Öykü!) @GamzeKarta
Prenses Öykü
2,047,124 views
11 months ago
31:40
WE STAYED IN THE CAR FOR 24 HOURS AS A FAMILY, LAST ONE OUT WINS! (5000TL PRIZE)
Gamze Karta
3,191,987 views
1 year ago
21:53
SPENDING A DAY CARING FOR TWO BABIES!! (HE REUNITES WITH ASEL ÖYKÜ!) @OykuKarta
Gamze Karta
1,512,508 views
10 months ago
Google AdSense
336 x 280

fetery.com. Copyright 2024