Asset Management Seminar

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. Topics include:

Click here to watch the first full lesson of the Seminar in our Online Theater:

Here's What You'll Learn

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.

Based on user demand, I may record a Part 2 to this seminar. Some optional topics may include:

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.

Access Asset Management Seminar