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:

Most popular video at the moment:

Online training courses:

Playlists for this channel:

#itseasytraining

Courses are available through Microsoft Teams, Online and Face to face in the UK

Training Guide Books

Excel for New Managers

Very cheap E_books are here:

[marvinrose]

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

[ericagrace]

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

[gregoryjeffries]

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

[davemason]

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
😀

[sas]

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

[maharlikanophirian]

How change Price without affect the historical data

[nomi_]

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