Track and Manage Assets in Microsoft Access
In this Microsoft Access tutorial you will learn how to build a database to manage your assets. You will learn how to create grouped assets (with unlimited grouping levels), track locations, owners, values, and keep a complete log of changes to the asset's history.
Main Seminar Goals
This database covers all of the basics for tracking assets. We'll begin by creating our asset table and form where you can store all of the information you need about each asset: owner, location, condition, notes, serial number, acquired date and value, current date and value, and retired date and value, and more.
Then we will expand that and create a one-to-many relationship between assets themselves. This way, each asset can be a child of another asset. This allows you to create asset groups. Take, for example, a computer system. It may have a hard drive, processor, keyboard, memory, etc. Each of these are individual assets, and they all belong to the parent asset, which is the computer itself. The parent can have its own serial number, location, owner, etc.
You can double-click on any of the child assets in the subform to open up that specific asset's information. You can also double-click on either the owner or the location combo boxes to open up the details for those entities.
You will learn enough VBA code and SQL to be able to hide or recolor certain fields based on their values (for example, change an asset name to blue if it has a parent record, or hide the location if it doesn't exist). We will also build our own subroutine to log any changes to any fields we wish to track in our history log.
If you want to note when a change was made to, for example, the asset's location, you can track that in the history log.
If you want to be able to track assets in Microsoft Access, this is the perfect seminar for you. You will learn everything mentioned above. You will have access to the full database that we build in class with all of these features. If you have any question whether this seminar is right for you, please feel free to contact me.
I am using Access 2013 in this seminar, however the lessons are perfectly valid for all versions of Access from 2007 and up. It's currently 2022 and I just made sure everything works fine with Access 2019 and Office 365.
Enroll now so that you can watch these lessons, learn with us, post questions, and more.
Please feel free to post your questions or comments below. Thanks.
microsoft access asset management, asset tracking
You may want to read these articles from the 599CD News: