Тёмный

How to create a simple shop database in Microsoft Access 

ITsEasyTraining1st
Подписаться 12 тыс.
Просмотров 63 тыс.
50% 1

This is a Microsoft Access database tutorial covering, how to create a simple shop database part one. The tutor starts off by creating a blank database and naming it ShopDatabase. The tutor then creates a Customer table, a Stock table and a Sales table. The tutor mentions that you can create look up links which then create one to many relationships in the database. The tutor adds some records in each table and explains how the table works. The tutor covers some of the different data types available in Microsoft access and mentions the field size options. How to create a simple shop database in Microsoft Access. Simple shop database part one. Database tutorial.
#shopdatabase
#msaccess
Join this channel to get access to perks:
/ @itseasytraining1st
Most popular video at the moment:
If you want to support me, check this out: / itseasy
Online training courses:
itseasytraining.teachable.com/
www.udemy.com/course/microsof...
Playlists for this channel:
Access: • Unleash the POWER of S...
Excel: • Link web based data in...
Word: • How to use Microsoft W...
Visio: • How to create a basic ...
Project: • How to use Baselines a...
PowerPoint: • Zoom feature in Micros...
Publisher: • How to set or create B...
OneNote: • OneNote Overview, link...
Office 365: • Video
#itseasytraining
Classroom based courses can be arranged at www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at itseasytraining.teachable.com/
Udemy Courses www.udemy.com/user/stephen-sa...
Training Guide Books
Excel for New Managers
www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers payhip.com/b/IE4x
Microsoft Project Overview payhip.com/b/wY0m
Microsoft Visio Basics payhip.com/b/5XeV
Microsoft Access Introduction payhip.com/b/ynSL
A PowerPoint Overview payhip.com/b/YkQv

Хобби

Опубликовано:

 

12 фев 2023

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 33   
@ITsEasyTraining1st
@ITsEasyTraining1st Год назад
Shop database part one. Check out courses at www.itseasy.co.uk or online at: www.udemy.com/course/mymicrosoft-access/?referralCode=38E973A16F0D008AE0C3
@marvinrose2045
@marvinrose2045 Год назад
Great Tutorial, no bull no sales just straight to the point. Thank you.
@ITsEasyTraining1st
@ITsEasyTraining1st Год назад
You are welcome
@ericagrace8954
@ericagrace8954 8 месяцев назад
Thankyou so much for this it is very informative will surely help with my assignment
@ITsEasyTraining1st
@ITsEasyTraining1st 8 месяцев назад
Most welcome 😊
@EasyMSAccess
@EasyMSAccess Год назад
Thanks for the insight
@ITsEasyTraining1st
@ITsEasyTraining1st Год назад
My pleasure!
@gregoryjeffries8475
@gregoryjeffries8475 5 месяцев назад
Good video, informative and easy to follow. Thank you for your time and effort.
@ITsEasyTraining1st
@ITsEasyTraining1st 5 месяцев назад
You are welcome!
@libreofficetutorials9499
@libreofficetutorials9499 Год назад
Love this
@ITsEasyTraining1st
@ITsEasyTraining1st Год назад
thanks
@davemason2604
@davemason2604 Год назад
Good vid. I still struggle with Access due to learning difficulties even tho self learning for many years. I am from Bradford so nice to see Bradford mentions. btw leeds is LS not LE lol 😀
@ITsEasyTraining1st
@ITsEasyTraining1st Год назад
Keep it up. LS I will note, I live in Newcastle now so no longer local
@EasyMSProject
@EasyMSProject Год назад
Great start
@ITsEasyTraining1st
@ITsEasyTraining1st Год назад
thanks
@iljak2914
@iljak2914 Год назад
Thanks, we wait for advanced Shop😜👍
@ITsEasyTraining1st
@ITsEasyTraining1st Год назад
coming soon
@TheTy63
@TheTy63 Год назад
Nice job 👍
@ITsEasyTraining1st
@ITsEasyTraining1st Год назад
Thanks 👍
@sas1136
@sas1136 6 месяцев назад
Thanks for you effort, could you please tell me how to make the quantity reduces whenever a recipt is created
@ITsEasyTraining1st
@ITsEasyTraining1st 6 месяцев назад
You have to create an update query, there is an example in the Access playlist
@grannysaxton9568
@grannysaxton9568 Год назад
Nice to know
@ITsEasyTraining1st
@ITsEasyTraining1st Год назад
thanks
@protoz651
@protoz651 7 месяцев назад
thnx mansh
@ITsEasyTraining1st
@ITsEasyTraining1st 7 месяцев назад
welcome
@Albertbullterrier
@Albertbullterrier Год назад
Good Start
@ITsEasyTraining1st
@ITsEasyTraining1st Год назад
Thanks
@moodkn
@moodkn 8 месяцев назад
Thanks....!
@ITsEasyTraining1st
@ITsEasyTraining1st 8 месяцев назад
You're welcome!
@nomi_87
@nomi_87 6 месяцев назад
i want to create a database for my shop where i can see my customers who buys things on credit from my store and i need to tract their transaction, because i'm tired of writing in my diary/register book please help me out with this
@ITsEasyTraining1st
@ITsEasyTraining1st 6 месяцев назад
You should be able to follow the shop database series it will help. You could do an online course it is not expensive. www.udemy.com/course/microsoft-access-intro/?referralCode=822715AB3FC8EC89D2F0
@maharlikanophirian7952
@maharlikanophirian7952 2 месяца назад
How change Price without affect the historical data
@ITsEasyTraining1st
@ITsEasyTraining1st 2 месяца назад
Create an archive table for the historical data
Далее
How to create a customer invoice in Microsoft Access
12:03
How to use Microsoft Access - Beginner Tutorial
31:07
Is Microsoft Access Still Viable in 2024?
21:19
Просмотров 38 тыс.
EASILY Make an Automated Data Entry Form in Excel
14:52
Microsoft Access A to Z: Designing Table Relationships
10:40
Ваше мнение?
1:00
Просмотров 3,1 млн
One moment can change your life ✨🔄
0:32
Просмотров 33 млн