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

[@ITsEasyTraining1st]

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

[@just2178]

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

[@ITsEasyTraining1st]

You are welcome 😊

[@gsgrady]

Great video Steve. Helped me help someone else.

[@ITsEasyTraining1st]

nice to hear

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

[@grannysaxton9568]

good series

[@ITsEasyTraining1st]

thanks

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

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

[@Albertbullterrier]

thanks

[@ITsEasyTraining1st]

Welcome

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

[@Shadersdmx]

When is part 3 coming out?

[@ITsEasyTraining1st]

next week

[@satyashivraut_ximb5198]

where is part 1, can you provide the link please

[@ITsEasyTraining1st]

I will put it in the playlist

[@honyarawa713]

❤