How to Create a Stock Management Database in MS Access (NO MUSIC VERSION) - with Free Download

This tutorial will explain how to use Microsoft Access to create a working stock control database with some basic features. Follow along with our free download of the basic stock database we created in this video: www.software-matters.co.uk/fre...
All you need to get started is a copy of Access and a beginner's knowledge of how it works.
Get more help and advice on Excel, Access or VBA projects:
www.software-matters.co.uk/you...
If you want to find out whether a bespoke database would be right for you, get in contact:
www.software-matters.co.uk/con...
Learn more about our work:
www.software-matters.co.uk/pro...
This is an amended no music version of our Stock Management tutorial video. For the original version:
• How to Create a Stock ...
---------------------------------------------
If you found this video helpful, please consider giving it a like, leaving a comment or sharing it.
More from the Software-Matters channel:
/ @software-matters
Visit the Software-Matters website:
www.software-matters.co.uk
Software-Matters is based in Gillingham, Dorset, in the south-west of the United Kingdom (UK), near Somerset, Wiltshire and Hampshire and the cities of Bournemouth, Poole, Southampton, Bristol, Bath and Salisbury.
----------------------------------------------
MORE INFORMATION:
To follow this tutorial you will need a full copy of Microsoft Access. The video was made using Access 2010, however the process is very similar in Access 2013, Access 2016, Access 2019 and Access 365 (as well as Access 2007).
We'll be going as far as setting up the database tables, which traditionally would be stored in a so-called 'back end' database file, while forms, queries and report, which are not covered in any details by this tutorial, would be stored in a separate 'front end' database file. The tables from the back end are then 'linked' to the front end, so that it behaved as if all the objects were in one file.
In some places we have made the design deliberately simple in order to keep our relationships clean and the number of tables low. This helps those new to Access to get their heads around how to create the database, but for actual use, might cause problems. We recommend that you learn more about database design from other sources before beginning your project if you intend to use it for a real business.
Key topics to consider are: database normalisation theory; Inner, Left, Right and Outer Joins; Basic SQL (structured query language) use; Software Development Methodologies; UX (user experience) enhancement techniques; and of course, the very specific needs of your business, project or client.
All together, a broad knowledge of these topics will allow you to design your tables with enough foresight to make the setting up of the queries, forms and reports you'll need later as easy as possible. Plus it should make the system easy to use and less likely to be corrupted or crash.
Keep in mind that even if your stock database needs don't fit very well with our example parts database, or if you need an entirely different kind of system like an accounts database or CRM database, the lessons in this tutorial can still apply.
0:00 Introduction
0:55 Make a Plan
2:07 Define the tables required
3:57 Invent Fields within the Tables
8:05 Making the Tables in Access
10:37 Set Up Relationships
16:28 Create a Reorder Query
21:03 Forms
22:08 Reports
22:48 Security
24:13 Automation
25:00 Outro

[@lindalubbe]

this was the best i watched on this topic. thank you. i really really appreciated the no music.

[@jobazooka8634]

Excellent... love the 'no music' version! :D

[@SuperHanme]

Thank you very much. It's helpful for us.

[@OnlinePresident]

My ears are at peace now... Thanks

[@user-xy4nl8pi4y]

was very thoughtful of you to include a no music version. :)

[@darioamir2577]

I guess I am kind of off topic but do anybody know of a good place to watch new series online?

[@kevinkylo9297]

@Dario Amir lately I have been using FlixZone. You can find it by googling :)

[@israelalvin6210]

@Kevin Kylo yea, have been watching on Flixzone for since april myself :)

[@darioamir2577]

@Kevin Kylo thanks, I signed up and it seems to work =) Appreciate it !

[@kevinkylo9297]

@Dario Amir No problem xD

[@colinmorgan8208]

Excellent tutorial, no faffing about, straight to the important points. Thanks.

[@Software-Matters]

Thank you! That's the kind of comment we like to hear.

[@Software-Matters]

That's exactly our approach when working too. With best wishes

[@duckyputter]

Great video. I have zero knowledge of access and just need to create something simple for my wife’s at-home clothing retail business. This video makes it look fairly easy. Wish me luck!

[@Software-Matters]

Good luck, Ben! With best wishes from the Software-Matters team

[@abigailamoako8783]

I won't to watch the video

[@gerher9416]

Thx for no music version

[@kennykahyata1576]

Powerful tutorial

[@AbdurRahim-ot5gp]

A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control. How to fix.

[@bentontramell]

I opened this up looking to manage my stock portfolio. Ha!

[@Software-Matters]

Oh, the joy of the English language! As you worked out, this is about stock as in inventory, and not about stock as in shares. Sorry!

[@WillieRas]

The email with the link to the sample is not being sent after the form is completed and submitted.

[@Software-Matters]

We have checked this facility and it is working. Please check your spam or junk folder to see if it has gone in there. If you still can't find it, please email us at [e-mail] and we will send you another copy.

[@hengchankreusna9750]

Hello Sir Can i ask any questions

[@Software-Matters]

Hello Heng - We will certainly try and answer any brief questions. With best wishes Software-Matters