Create A New Database From The Asset Tracking Template
Using this asset inventory tool wont be too difficult once you have read through the detailed instructions for filling out the spreadsheet provided in this article.
Create a new database from the asset tracking template. Your new web app opens in design view in access. Watch this video to learn more about this popular access template. Excel can be a useful tool for setting up very basic inventory equipment tracking and asset tracking systems. It is particularly useful for tracking computer hardware tools repair equipment and other fixed assets.
In infopath open the asset tracker form template file. In this article we cover the basic steps of using the asset tracking template. Since we started with the asset tracking app template youll see three pre built tables listed just below this tab. To prevent this form from displaying the next time you open the database clear the show welcome when this database is opened check box.
So in stead of to use asset tracking template i would welcome suggestions for its more improvements. Prepare the database for use. The web app is shown as a page with a tab containing its name. Press the tab key until you hear create button and press enter to create a new database using the selected template.
You can download a demo or purchase a copy of this microsoft access code example at. On the file menu click save as source files. When you first open the database access displays the welcome form. In the browse for folder dialog box select a folder or create a new folder where you want to store the schema file.
Keeping track of the assets is critical to avoid theft of and damage to the assets of a business. Access can be a helpful tool for building up very fundamental asset tracking and equipment tracking database systems. Extract the schema file from infopath. For this the excel asset tracking template included with this article will serve as an effective tool.
Depending on which template you are using continue with use the asset tracking template or use the students template. On the tools menu click design this form.