The StampCAT database

Previous pageReturn to chapter overviewNext page

All information in StampCAT 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 stamp, one with information about each country, one with information about each catalog and so on. Each table contains a various number of fields. For example, the Catalog table has a field for the name of the catalog, one field for the currency, and one field for the exchange rate.

StampCAT 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.

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

StampCAT 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 country the first time you add a stamp from this country. Later, you simply choose the name from a list. StampCAT then automatically creates a link between the stamp and the country. 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.