Records Manager is a feature designed to enabling users to directly manage the data. In this feature, you can directly edit the selected record(row), and insert/delete any rows or columns what ever you like.
Relevant information: What is rows and columns:Rows = Records. Each row in a table represents a set of related data, and every row has the same structure.
Columns = Fields. The columns provide the structure according to which the rows are composed. Each row would provide a data value for each column and would then be understood as a single structured data value. For example, one column might require a unique id, another might require text representing a person's name
And Here is a sample database structure:
| ID (Column 1) | Name (Column 2) |
---|
Row 1 | 10001 | John Doe |
---|
Row 2 | 10002 | Jane Doe |
---|
Row 3 | 10003 | Jane Roe |
---|
Add A new Row(Record): A New Row window will appear. filling up the data in to the form and click OK button, and the new record will be added into database instantly.
Edit a row: double click a row in the data table. and a edit row will appear. filling up the data in to the form and click OK button, and the new record will be added into database instantly.
Delete the selected row(record). delete the row which you selected in the data table.
Add a new column: A New Column will show up, enter the name of the column and select the type of the column. and click OK button, the new column will be added into database instantly.
Delete Column: A delete column window will show up, you can select which of column that you want to delete.