Chapter 5 – Manager Main Menu
'Magnifying Glass' Button
![]()
Viewing Data Files
This button on the Main Menu allows the administrator to examine raw data in connected tables. When the button is pressed, the View Tables window appears. It will be blank, i.e., no tables will appear. The tables must be selected from the drop-down menu (
) field in the View Tables field. Before viewing a table, the database in which the table resides must be chosen.
The MainDB refers to the DBase.MDB database. If this is selected and the Refresh button pressed, the tables in DBase.MDB will be displayed.
The BaseDB is the work database. Selecting this displays the tables defined or linked in the work database. This includes most tables in the MainDB as well.
|
The fields may be edited. For example, in the lower table the supervisor may want to alter the Date data type in the Format field. These options, Date, Integer, Time, etc., appear in the Format field of the question record.
The current Date (mdy) descriptor is in the American format and may confuse a designer. It may need to be changed to Date (dmy) or Date (ymd) according to the user's convention.
ButtonsThe Refresh button refreshes the list that appears in the View Tables field after a delete or modification.
Use caution with the following button
The Delete button deletes a highlighted field. If no field is highlighted the entire table will be deleted. When pressed the user is asked, "Do you really wish to delete [field name] from BaseDB?" There is no way to respond 'no.' So if an item was selected, it will be deleted.If you delete a table and you need to restore it, use the MS Access menu.
| The Mod button brings up the Formats modification window shown to the right. This window allows the user to modify the display of the table currently selected. The fields in the modification window may be selected by highlighting them. Those that are selected, when the Show Selected Fields button is pressed, will be the only ones shown in the new display. |
|
The figure below displays the original Format table display in the upper half and the modified on in the lower half.
|