Using and Customizing Tables. How to...

Label Mix is a multi-purpose software. Tables created in "My Database" section of the program can be used to store and manage practically all types of information - over 1000 database solutions for business, office, school, and home.
There is no limit to the number of tables you can create and there is no limit to the amount of records you can store in the tables.

Before creating a table, you should determine three vital aspects:

You can now proceed to create your new table, using one of three methods:

Regardless of the method you use, a dialog box will pop-up.
Enter the name* of the new table in the box and then click "OK".
A new table will be created with one unique field (column) named "ID", an index field.
If necessary you can proceed to add more fields (columns) to the table.

* Name of the table should contain only Latin alphabets (A-Z) or combination of alphabets and numbers, without spaces or exotic characters. Table name must be unique in the database, i.e. you can not have two tables with the same name in a database.

By default, when you create a new table, you will be prompted with a dialog to add new fields (columns) to the new table. Nevertheless, you can add new fields (columns) to a table at any time - during creation or after you have created the table.

To add new fields (columns) to a table do the following:

1. From the menu or section workspace, locate the table

2. Invoke the Columns editor by double-clicking the columns editor icon  or choose "Columns..." from the main menu or context menu (context menu can be displayed by mouse right-click)

3. Wait for the columns editor list to appear. The available columns in the selected table will be listed in the editor list.

4. The order in which columns appear in the Columns editor is the same as the order the columns appear in the table

5. The number of boxes in the Columns editor corresponds to the number of columns available in the selected table. The checked boxes represent visible columns, while boxes representing hidden columns are not checked.

6. To hide a column, uncheck the appropriate checkbox in the columns list editor. Conversely, to make a column visible, check the corresponding box in the list.

7. Click "Apply" to save changes, "Default" to cancel and "Close" to exit.

Before changing columns visibility
After changing columns visibility

1. From the menu or section workspace, locate the table

2. Invoke the Columns editor by double-clicking the columns editor icon  or choose "Columns..." from the main menu or context menu (context menu can be displayed by mouse right-click)

3. Wait for the columns editor list to appear. The available columns in the selected table will be listed in the editor list.

4. The order in which columns appear in the Columns editor is the same as the order the columns appear in the table

5. The number of boxes in the Columns editor corresponds to the number of columns available in the selected table. The checked boxes represent visible columns, while boxes representing hidden columns are not checked

6. Select the column in the Columns list box

7.  Drag it to a new location in the list box

8. Click "Apply" to save changes, "Default" to cancel and "Close" to exit

 Note:
You can also change the column order by clicking on the column title and dragging the column to a new position (drag-and-drop)

Before changing columns order of appearance
After changing columns order of appearance

To resize the column width, focus your mouse cursor (or pointing device) on the gridline between the column titles. Your mouse cursor changes to HorizontalSplit. Drag the line to the new position (left or right).
 

CustNo field (column) Before column resize	After column resize

Focus your mouse cursor (or pointing device) on the necessary column title (your mouse cursor changes to HandPoint). Click the title. Records in the table can be sorted in numerical or/and alphabetical (0-9 or 9-0, A-Z or Z-A) order.

Company field (column) sorted A-Z

Company field (column) sorted Z-A

To add record, click the "Add..." item in the menu. A form will pop-up, where you can add necessary information. Alternatively, you can click the "Add..." button.

To edit record in the table, double-click on the table. A form will pop-up, where you can edit necessary information. Alternatively, you can click the "Edit..." button.

You can also edit information directly in the table by selecting the cell containing the information and then edit. The last method could be a bit inconvenient, is not recommended and should be avoided where possible.

Note:
Edits that are made directly in the table cell are not saved to the database until you have moved to a different record (another row) or exit from the program.

1. Select the row containing the record.

2. To delete multiple rows, press Ctrl key while you select the rows.

3. Click the "Delete" button. You will be prompted for confirmation. Choose "Ok"or "Yes", if you are certain you want to delete the selected records, otherwise click "No" or "Cancel" to abort the process.

4. To delete all records in the table, from the main menu or context menu click "Delete All". All records in the table will be deleted, i.e the table will be emptied.

Caution
When you empty a table, all records in the table are gone forever. The process is not reversible.

Label Mix uses flexible approach, which enables you to export records from tables directly to your office programs for further manipulation (including printing) OR generate labels for the data and export them as images or/and printout.

I. Exporting table records to your office programs (Text, Word, Excel, RTF, HTML)
From My DataBase section of the program you can export and save data into files of various formats such as:

HTML MS Word MS Excel Plain Text Rich Text Comma-separated Text Tab-separated Text Data Interchange Format SYLK Format	(a)
(b)	(c)

To export master table content as single table to your office programs, do the following:

1. From "My Database" section workspace, select the table. If necessary, carry out operations such as search, sort, edit, delete etc.

2. Use the Columns viewer (editor) to specify the columns, their appearance order and width - the way you want them appear in resulting table.

3. Adjust the columns width such that information in the columns is visible

4. Invoke the "Data Export Manager" dialog by clicking "Export / Print ..."

5. Select "Export as Table" and then click "Continue >>"

6. You will be prompted to confirm the table's present state as it will appear in the resulting table after export. Click "Ok". If you click "Cancel", you will be taken back to step 2.

7. Choose the export format from the drop-down list

8. Choose "view only" if you want the table to be exported directly into the corresponding client program, otherwise choose "export to file" to export and save the table content to file. In "view only" mode, Label Mix invokes (automatically opens) the corresponding client program and export the table directly into the program.  In "export to file" mode Label Mix will prompt you to give a name to the file into which the table content will exported and saved

Note:
You can also export the table's content to Clipboard and later paste into any other file. In step 6 above, choose "Clipboard"

II. Exporting table records as Labels
To export table records as labels for printing or/and saving as images do the following: