Select the following field types for the table:

Next to that, there is a Field Type column where you should select a suitable type of field from the drop-down lists. There you input the above database fields in the Field Name column. To set up the first table with these fields, select Create Table in Design View to open the window below. So long as you input the full software title including the specific version number, such as Opera 12.6, the software title is a unique identifier (otherwise the primary key) for the database records. The most essential field in this table is the software title.

Software Suite – Is the software a suite of packages?.

Freeware – Whether the software is freeware or otherwise.

Type – The type of software such as office, photo editing, games etc.

Software Title – The title of the software package, and primary key for the database.

The first table will include the following database fields: Databases with multiple tables are relational databases which reduce the amount of duplicated data you might find in a single table (flat-file) alternative. Now you should input the software database fields, or table columns, in a couple of tables. Type in the title of the database file, and click Save to open the Base software window. Select the Open the database for editing option, and then Finish to save a new database. Then click Next and the No, do not register the database check-box option. When you open Base, select the Create a new database option from the Database Wizard window. Check out the OpenOffice website to add it to your software library. It is also a multiplatform software package compatible with Windows XP, Vista, 7, 8, 8.1, Mac OS X and Linux platforms. The software suite includes the Base application which has all the options required to set up databases. You can set up a software database with the freeware OpenOffice suite. Would it not be great to have a database which you can open to find the location of all your installed software? The database could also include other details such as the size of the software packages.

Those who add software to their PC or Mac willy-nilly might lose track of some of the software they have installed.

A table as a field in openoffice base