How to set up a shop database in Microsoft Access part 2

In this video, I'm going to continue to teach you how to set up and use a shop database in Access. This video is perfect for anyone who wants to learn how to use Microsoft Access to manage their shop data.
If you're a shop owner or manager, then this video is a must-watch! In this video, I'll show you how to set up and use a shop database in Access, so that you can easier manage your inventory and sales data. By the end of this video series, you'll have everything you need to start using Access to manage your shop data! How to set up a shop database in Microsoft Access part 2.. Microsoft Access tutorial. Access tutoring.
#msaccess #database
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]

How to set up a simple shop databse part 2. Check out courses at www.itrseasy.co.uk

[@gsgrady]

Great video Steve. Helped me help someone else.

[@ITsEasyTraining1st]

nice to hear

[@just2178]

I had to make such a project for an exam and this helped me, thank you so much

[@ITsEasyTraining1st]

You are welcome 😊

[@2busygal]

Thank you so much, this is exactly what I needed. Haven’t created databases for many years but used to for work. Now I have an Etsy shop where I sell handmade cards. I need a way to track raw materials and their costs in order to determine inventory and cost/profit per sale. This lets me set up what I was envisioning.

[@ITsEasyTraining1st]

You're very welcome!

[@moodkn]

Thanks....! Helpful Exercise

[@ITsEasyTraining1st]

Glad you liked it!

[@paul-philippkern7371]

Did you cover how stock is going out of inventory in any video? It is not in the playlist.

[@ITsEasyTraining1st]

Do you mean how to update stock or flag up low stock levels I have videos for both.

[@grannysaxton9568]

good series

[@ITsEasyTraining1st]

thanks

[@Albertbullterrier]

thanks

[@ITsEasyTraining1st]

Welcome

[@honyarawa713]

❤

[@aniquewaseem4576]

Sir asked me to design a project having attributes, entities and relationships
Also relational schema and normalization
Did i make this project and send to sir or not ?

[@ITsEasyTraining1st]

Not sure

[@fahadalomair9080]

When is part 3 coming out?

[@ITsEasyTraining1st]

next week

[@bondniko]

That's all pretty, of course. But why in the 21st century all tutorials only speak about manual input forms? A real challenge is to built a cool relationship database with all the dependencies and try to upload a sales file for a month with hundreds of transactions. How about that? One has to make sure that your input excel file has product id's, not names, that are consistent with your access database ones.

[@ITsEasyTraining1st]

That is true and doable

[@satyashivraut_ximb5198]

where is part 1,
can you provide the link please

[@ITsEasyTraining1st]

I will put it in the playlist