The Asset records form, in the free Assets Management sample database, affords ready access to all your business asset records, including the asset's previous and current tax depreciation information, and the asset's maintenance schedule and repair details, including repair costs. The asset record form doubles as the main menu for the database, allowing the user to quickly add or edit sundry information, such as vendors, employees, and departments. The integrated menu/asset record design ensures the Assets Management database is easy to learn and very user-friendly.
The Assets record / main menu form, in addition to recording repair details and tax depreciation information on each asset, provides access to a suite of built-in reports included to assist you better management those business assets. Why not download and try out the Assets Database sample. It is FREE and yours to use indefinitely.
The full depreciation history of each asset is easily calculated and recorded. Once all asset details has been entered select the depreciation method ( Single year, Prime cost (Straight Line), Diminishing Value, or Some of Year Totals) and then click the Calculate button. Print a depreciation report annually as required.
Assets Management Database - List of Assets
The Assets list form provides a list view of all the business assets in the database. Quickly sort the list of assets by clicking the column name at the top of the asset list form. Sorting the asset list lets you rapidly locate a specific asset. Once you have found the asset of interest, simply double click the Asset Number to return to the Asset Details records with the relevant asset loaded.
Assets Database Employee Records
The employee record form provides a place to store your employee's name and other details. The Employee records provide the information displayed in the employee drop-down list located on the main Asset Record form of the Assets Management database sample.
Assets Management Vendor Records
The Vendor records form records vendor details from whom assets were purchased. These records also provide the details displayed in the Vendors drop-down list located on the main Asset Record form of the Assets Management database sample. Storing the vendor record in this way not only retains the information for future reference, but it also eliminates the need to reenter a vendor's details the next time an asset any purchased from them and must be recored in the asset database.
Assets Management Database Reporting Options
The free Asset Management Database includes a suite of reports that assist with managing and maintaining your business assets. Everything from asset assignments, maintenance schedules, and repair work on assets right through to asset tax depreciation reports and more. Select the required asset management report in the list and click the 'open Report' button.