A table in SuperDB functions similarly to an Excel spreadsheet. A SuperDB table is great for storing information that may be entered multiple times, such as community service hours. For example, a student may fulfill community service hours over a period of time, and you can record each set of data within the SuperDB table. Also, you can filter and sort columns, and then save the filtered and sorted table as a View.
On the menu bar, click View > SuperDB.
In the SuperDB dialog box, click Create Table in the left pane.
- In the Define Table dialog box, enter a Table Name.
- Enter a Description of the data for this table.
- Optional: Select the Generic Table (Not linked to students) check box.
Generic SuperDB Table: A generic SuperDB table isn't linked to any students, and the information isn't populated with student demographic information. Generic tables can hold information such as a list of doctors in town, a list of all school lockers and combinations, or a list of departments in the school. A generic SuperDB table can act as a spreadsheet, or you can populate Demographic fields in Data Base with generic SuperDB fields. For information on linking a generic SuperDB field to a Demographic field, see Link Generic SuperDB Fields to Demographic Fields.
Click Small: 160 Characters, Medium: 410 Characters, or (Custom...) from the Length/Record drop-down list, depending on the desired record length.
A record length defines the maximum number of characters for each record in the table.
To create a custom student record length, click (Custom...) from the Length/Record drop-down list, and enter the custom record length in the Enter Record Length box.
Do either of the following:
Select the All Students or All Staff check box to create a single record with default values.
When you create one record with default values, records are added to the SuperDB table for any student or staff member who isn't already displayed.
Click to link the table to another table, click the existing table you wish to link the table to, and click Select.
Linking another table to your new SuperDB table adds the existing SuperDB table's fields to your new table.
- Enter a field name in the Item Name column.
- In the Type column, click Text, and click one of the following from the drop-down list:
- Text: Characters can be entered in any format.
- Integer: Whole numbers can be entered.
- Decimal: Numbers can be entered with a decimal point.
- Date: Dates in mm-dd-yyyy format, or any date format you've chosen for your AdminPlus, can be entered.
Note: Characters can be entered in any format.
Unlike the Text type, the Note type has no character length. You can also enter any text using the Note by clicking in the table.
Click the text field in the Length column, and enter the field length limit for the field.
As you assign lengths for each field, the number of Characters Remaining decreases in the upper-right corner.
Click Optional in the Required column, and click Optional or Mandatory from the drop-down list.
Optional fields can be left blank, whereas Mandatory fields require an entry in order to save the SuperDB record.
- Click Leave As Is in the Case column, and click one of the following from the drop-down list:
- Leave as Is: No formatting is applied to this entry.
- Sentence Case: The first word of the entry is capitalized, and the rest are left lower case.
- Lower Case: Entries are converted to lower case.
- Upper Case: Entries are converted to upper case.
- Title Case: The first letter of each word is capitalized.
Click Not Validated in the Validation column, and click Not Validated, Supervisor Only, or Anyone from the drop-down list, depending on whether or not the field needs to be validated and by whom.
When you allow field validation, the field becomes a drop-down menu that a user can add items to, if desired.
Enter a value in the Default Value column if you want each entry of this field to be the same.
- Click Save [F10].
- To add any new items, click Add [F2], and repeat steps 8–15.
- Click Done [F10].