My new series of YouTube videos is an introduction to Microsoft Access for absolute beginners who have never used Access before. If you are in the position of needing to learn Access fast or are curious about what you can do with Microsoft’s desktop database software, this series will provide you with a great introduction to organization of data into related tables, creating user-friendly data entry forms and designing reports to present your data as needed.
The idea behind this series is to demonstrate Microsoft Access by showing the design of a new database application from start to finish. This includes the occasional mistakes and bugs that happen from time to time and need to be resolved. In these videos, you’ll get to see the thought process behind the design of an order entry application and learn about the different questions that need to be asked when planning a new solution that will be used by other people.
The first four videos are now online and there will be more in the next week or so. The first four videos introduce Microsoft Access and detail what it can be used for. There’s also a look at the completed JobSearch Plus application which I designed in Microsoft Access 2007 several years ago. This application is available on Github and demonstrates some of the incredible potential of Access as a Rapid Application Development tool. Then, in Parts III and IV, I demonstrate how an order entry system initially designed in Microsoft Excel can be converted into a system of Access tables which will reduce redundant data and help prevent data entry errors.
The last few videos will demonstrate how to create forms and reports in Access using the order entry system developed so far. There will also be a look at the use of macros and Visual Basic for Applications (VBA) to create custom actions and functions within an Access application.
I hope you’ll take some time to check out the videos along with previous videos on my YouTube channel. If you find them useful, please let me know with upvotes and comments. You can even subscribe to the channel and see upcoming videos on Access and other technologies.