A record displays a row of information from the database. When a user inserts, updates, or deletes a record, that action causes a corresponding row in the database to be automatically inserted, updated, or deleted when the transaction is saved. A field is an area on the screen that can display a value or accept an input value. A field represents a column from a database table and is easily identified by its long rectangular shape. Table A table is an object in the database where information pertaining to an object or entity is stored.
Tables consist of columns containing field information and rows containing record information.
MIDS has approximately 112 tables which contain information about Midshipmen, Grades, Majors , etc. Query A query is a request for information from the database. Web Module Web modules are the fundamental building blocks of the MIDS system. A query form is a web page that allows a user to request information from the database. It returns a Record List.