The purpose of this post is to create a computer inventory using FileAmigo .Whether you manage a handful of computers or a hundred, this post can help you have better control over them.
FileAmigo is a free (free for one person use only) data management tool that helps you manage critical data like equipment inventories, project planning, customers, issues, schedules etc. One of the attractive features in FileAmigo is the ability to create databases and detail reports without the technical skills that sometimes comes with it. In other words, is very easy to use.
When you install FileAmigo and execute it for the first time, you are welcomed by a wizard window like in the picture below.
From this wizard you have the option to use a custom template to create a database; which has the fields pre-configured. You also have the option to create a new file from scratch, or import the data from a text file, or open an exiting file you already have created on FileAmigo.
For the sake of this post, I will use the option to create a file from scratch. Select “Create a new file from scratch” second from top to bottom, and click next.. In the second screen which looks like the picture below.
As a Filename type “Computer Inventory” type any meaningful description for your database. On the “Field Name” we will have to type the fields we will need to properly keep the equipment records. Type these names on the Field Name box and hit the right arrow after you type each one.
Name Assigned
Computer Model
Service Tag
Purchase Date
Location
Department
After you finish typing all the fields, it should look like the picture below.
Click next after you finish typing all the fields. on the following screens; choose “Text” for all of them but “Purchase Dates” which should be set to “Date”. by now your database should be created, and with the fields ready to accept data.
Now when you add records to the database it should like this picture below.
Click Save. And your entire record should look like the image below.
Of course you can expand those fields as you like; I shrunk them to fit on the screenshot.
Once you populate your database with sufficient records you can start doing reporting with some good features like using filters for getting records only from a specific computer model, or by the year the equipment was purchased, or equipment by department etc. this reporting features become handy when you need to plan the budget for the following year, and need to have an accurate report on how many computers will need to get replaced.
Be The First To Comment
Please Leave Your Comments Below