AScore: Art Visions Scoring System

Editing and Managing All School Data Help Table of Contents

Description This layout allows school data to be edited, added or deleted:
 
Fields
School Abbreviation The unique, capital-letter abbreviation for the school, which will be used as a key in finding and sorting student data. If this key is actually used in student data, the word "referenced" will appear in the empty box above it. In this case, this value should never be changed, nor should the record containing it be deleted. Otherwise, the referring data will become corrupt.
School Full Name The full name of the school. Since this data is not used as a sort or data key, it may be changed (within reason), even if the record is referenced.
Buttons
Menu Go back to the database main menu.
New Push this button to create a new school record. When the new blank record appears, choose new, unique school abbreviation and fill in the full name field.
Sort Pushing this will sort the records by school abbreviation.
Delete Pushing this button will delete a school record. If you really want everything about it gone, then edit the school abbreviation value list, as described above, to remove it there as well. Once again, be careful not to remove or change a referenced school abbreviation. The database actually contains interlocks which will prevent you from deleting an entire referenced school record. However, nothing has been implemented to prevent changing or deleting a value list item, regardless whether or not its associated data record is referenced elsewhere in the database.