The data pane displays the records of the selected table. To add a field, click Click to Add, and then click the data type that you want for the field.
|
When you click a cell in the Click to Add column, enter data, and then press Enter , Data Builder automatically tries to determine the data type for the field based on your input. For example, when you enter only numbers, Data Builder creates a field that has a Numeric data type.
|
To add table data or edit existing table data, click the table cell that you want, and then add the new content. You can edit the properties for a field by selecting the field that you want and then modifying the property on the Fields tab.
When you use the secondary mouse button to click an existing field name, the following options are available:
-
Rename: Renames the selected field.
-
Delete: Deletes the selected field.
-
Sort Ascending: Sorts the database records by ascending order (A-Z, 0-9) based on the data in the selected field.
-
Sort Descending: Sorts the database records by descending order (Z-A, 9-0) based on the data in the selected field.