To activate the 'Database Setup' window, choose Database Setup from the Tools menu. The main part of this window is occupied by a page control with two tabs: Tables and Fields.

The list on the Tables tab gives you an overview of all tables in the database (the Video table is selected by default). This list has three columns. The first column displays the default table name, the second column the actual table name, and the last column indicates whether the table is in use or not. You can change the sort order by clicking the heading of one of the columns. The properties list to the right includes the properties of the selected table. Context sensitive help is available for each property.

To edit the fields in the selected table, click the Fields tab. The list on the Fields tab gives you an overview of all fields in the selected table. This list has four columns. The first column displays the default field name, the second column the actual field name, the third column the name of the group the field is linked to, and the last column indicates whether the field is in use or not. And just as with the table list, you can change the sort order by clicking the heading of one of the columns, and use the properties list to the right to change the properties (field name, default value, field group, etc.) of the selected field.

When you want to modify a field, it is important that you select the correct table before you activate the Fields tab. For example, to modify the Awards field, first select the Contents table on the Tables tab, then click the Fields tab to display the fields in the Contents table.

The field group is used in lists where you choose a field, for example when creating a report or a sort order, and makes it easier to locate a specific field. By default, the group corresponds to the tab the field is located on in the data entry window.

To only show the tables and fields that are actually in use, check the Show only tables/fields in use option at the bottom of the window.

You can save the database setup as a database template. This template can then be used when creating a new database. This is useful if you want to share the database setup with others. For more information, see Save the database setup as a template.