Main window of database module

<< Click to Display Table of Contents >>

Main window of database module

TextMaker comes with an example database called addressbook.sqlite. On Windows, this file can be found in the SoftMaker folder below your user directory.

If you open the database with the command Edit database db_edit_icon (on the ribbon tab Mailings | group Database), you are presented with a database window.

This database module may look as follows:

db_modul_sample

The example database addressbook.sqlite (in the form view)

If you see a tabular list of records instead, you can always choose the ribbon command Form/list (in the group View) to switch between the list view and the form view shown above.

If you like, you can use the example database addressbook.sqlite as your personal address database. It contains all the database fields needed to store addresses:

On the screen, you can now see the first record of the database, which consists of several fields. A data field is an information unit, for example, the first name. All information that you enter for a person (salutation, name, address, etc.) constitutes a record.

Information in the status bar

In the status bar at the bottom of the program window, you can read the following information:

First, the number of the current record (the record number) and the total number of records in the database are displayed ("Record 1 of X").

To the right of it, the program displays the following status information: Selected if the record is selected.

For more information on selecting records, see Selecting data records.

On the far right in the form view, you can see the field type of the current field, which determines which entries are allowed in the field:

For SQLite:

Field type

Allowed entries

Text

Any entries

Real Number

Real numbers (with decimals)

Integer

Integers (no decimals)

Logical

Only Y for "Yes" or N for "No"

Date

Dates

Time

Times

Datetime

Combination of dates and times

Long text

Any entries for notes (long text)

Binary

Unstructured data objects, such as image files or programs

For dBASE:

Field type

Allowed entries

Character

Any

Numeric

Numbers

Date

Dates in the format MM/DD/YY (for example, "04/16/18")
or in the format MM/DD/YYYY (for example, "04/16/2018")

Logical

Only Y for "Yes" or N for "No"

Long text

Any input for notes

The maximum length of the field is displayed after the field type.

Which century? Note when filling in date fields for dBASE: If you enter a two-digit year between 0 and 29, TextMaker automatically prefixes "20...". For years between 30 and 99, TextMaker prefixes "19...".
The entry "01/01/29" is interpreted as 1/1/2029.
The entry "01/01/30", on the other hand, is interpreted as 1/1/1930.

Ribbon commands in the database module

ribbon_tab_database

The database module contains the following command groups for working with the database:

Command group

Description of commands

Edit

Use the commands known from Moving, deleting and copying to easily edit the contents of records (only available in the form view).

Navigation

Use the small toolbar to navigate between records (see Scrolling through records) or use the commands Search/Search again to find specific search terms in the database. For more information, see Searching a database.

Records

Append adds a new record, and Duplicate creates a duplicate of a record. For more information, see Adding and editing data records.

 

Delete: This button can be used to temporarily or permanently delete and restore records. For more information, see Deleting and restoring records.

 

Sort: This option allows you to rearrange the records of the database. For more information, see Sorting a database.

 

Select: Use this button to find commands to limit the records for mail merge printing. For more information, see Selecting records for a mail merge.

View

Form / list view: This option allows you to switch between form view (as shown in the figure above) and list view. For more information, see List and form view.

 

Show only selected data records: This option hides all records that are not selected (useful for mail merge printing).

 

Update: This option rereads the database in case it was changed by another application as a multi-user database.

Manage

Save as SQLite table: Use this command to convert the open database into SQLite format if the current database is in an inconvenient format.

 

Table settings (only available for SQLite): Here, specify which field type should be used for display: text, number, date, etc. For more information, see Changing the database structure.

 

Change structure: Here, you can change the structure of the existing database. For more information, see Changing the database structure.

Windows

Here, you can switch to full screen mode or between the windows.

Close database

Exit the database module. The database is saved automatically.