The data pane displays the records of the selected table. To add a field, click Click to Add, and then click the that you want for the field. 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.