How to create a simple shop database in Microsoft Access

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:
itseasytrainin...
www.udemy.com/...
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...
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at itseasytrainin...
Udemy Courses www.udemy.com/...
Training Guide Books
Excel for New Managers
www.amazon.co....
Microsoft Project Overview www.amazon.co....
Microsoft Visio Basic www.amazon.co....
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

[@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]

Great Tutorial, no bull no sales just straight to the point. Thank you.

[@ITsEasyTraining1st]

You are welcome

[@ericagrace8954]

Thankyou so much for this it is very informative will surely help with my assignment

[@ITsEasyTraining1st]

Most welcome 😊

[@gregoryjeffries8475]

Good video, informative and easy to follow. Thank you for your time and effort.

[@ITsEasyTraining1st]

You are welcome!

[@EasyMSProject]

Great start

[@ITsEasyTraining1st]

thanks

[@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]

Keep it up. LS I will note, I live in Newcastle now so no longer local

[@Albertbullterrier]

Good Start

[@ITsEasyTraining1st]

Thanks

[@iljak2914]

Thanks, we wait for advanced Shop😜👍

[@ITsEasyTraining1st]

coming soon

[@sas1136]

Thanks for you effort, could you please tell me how to make the quantity reduces whenever a recipt is created

[@ITsEasyTraining1st]

You have to create an update query, there is an example in the Access playlist

[@libreofficetutorials9499]

Love this

[@ITsEasyTraining1st]

thanks

[@EasyMSAccess]

Thanks for the insight

[@ITsEasyTraining1st]

My pleasure!

[@protoz651]

thnx mansh

[@ITsEasyTraining1st]

welcome

[@moodkn]

Thanks....!

[@ITsEasyTraining1st]

You're welcome!

[@grannysaxton9568]

Nice to know

[@ITsEasyTraining1st]

thanks

[@TheTy63]

Nice job 👍

[@ITsEasyTraining1st]

Thanks 👍

[@nomi_87]

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]

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]

How change Price without affect the historical data

[@ITsEasyTraining1st]

Create an archive table for the historical data