The AssetCAT database

Previous pageReturn to chapter overviewNext page

All information in AssetCAT is stored in a database. A database is a file on your hard disk, with the extension .MDB, that contains all the information you have entered into the database.

A database consists of several tables. Each table contains related information. For example, there is one table with information about each asset item, one with information about each category, one with information about each location and so on. Each table contains a various number of fields.

AssetCAT lets you change the name of all tables and all fields. You can specify a default value for most fields. You can hide the fields you don't want to use. They will then disappear from all windows, menus, lists etc. You only use the fields you want.

AssetCAT lets you work with an unlimited number of databases. This means that you can split your items into different catalogs and organize it to meet your needs. You can later merge existing databases.

AssetCAT uses a relational database model. This means that you register most information only once. For example, you only need to type the name of a category the first time you add an item in this category. Later, you simply select the category from a list. AssetCAT then automatically creates a link between the item and the category. When you modify an entry in a lookup table, for example, to fix a typing error, the change will be reflected in all fields that are linked to the lookup table.

The use of lookup tables to store information has two significant advantages: it saves time and conserves valuable disk space on your computer. It also makes it easier to search for exactly the information you are looking for, or create a group based report.




Do you have question? E-mail us at support@fnprg.com.