Categories

Database Management

Database Management is a feature designed to enable users to directly manage the data inside the database. In this feature, you can directly edit record(rows), and insert/delete rows or columns .

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/Delete column: Edit Column will show up, you may edit the column structure on this dialog.