How to Use SOIC |
|
The software and documentation were designed to be as easy to use as possible.
The software has an easy-use-interface created based on the U.S. standard death
certificate (the data entry form) and includes several data access features.
Microsoft conventions for Windows applications were used wherever possible. The
SOIC system was written using the Microsoft Visual Basic programming language
and the Microsoft Access database management system. SOIC data tables and data
files are stored as Access tables and files.How to open an Access table created in SOICAccess stores tables in database files that have the extension .mdb. Several tables can be stored in each file. Thus, before opening a table, the appropriate database file must be chosen. For files created using SOIC, the default file is Userdata.mdb. You can use the “Open” option to open an existing SOIC table so that it appears on the data entry form.
Caution: You cannot open the untitled table that appears when the SOIC system is open. If you enter data into this table and open another table, the data will be lost. Use the “Save As” option to save any information in the untitled table before you do anything that closes it. How to open a non-SOIC Access tableBecause SOIC was written using Microsoft Access, Access files not created in SOIC can also be open using the “Open” option. Unlike opening an SOIC table from the default file Userdata.mdb, you must choose the appropriate database file before opening a table.
NOTE: When the dialog box is open, the tab card Industry/Occupation is displayed. This tab card contains the four required fields that you must map to open the table (Occupation Title, Occupation Code, Industry Title, and Industry Code).
NOTE: Using the Identification, Personal Information, and General Information tab cards, optional fields can be mapped and displayed in the same way the required fields are mapped. How to open an Xbase fileIn addition to Access tables, the SOIC system can also open files created by dBase, FoxPro, and other database management systems (Xbase). One difference between Access and Xbase is that Xbase tables are always stored one table to a file.
NOTE: When the dialog box is open, the tab card Industry/Occupation is display. This tab card contains the four required fields that you must map to open the table (Occupation Title, Occupation Code, Industry Title, and Industry Code).
NOTE: Using the Identification, Personal Information, and General Information tab cards, optional fields can be mapped and displayed in the same way the required fields are mapped. Caution: Control over Xbase files is limited. Because Xbase records cannot be moved to the Trashcan, all deletions are final. Many of the features that are available for Access files are not available for files in Xbase format. How to suppress fieldsSOIC gives you the option to suppress the display of one or more fields that normally appear on the data entry form. The four required fields (“Industry Title,” Occupation Title,” “Industry Code,” and “Occupation Code”) cannot be suppressed.
How to find a recordBy using specific search criteria, you can find a record in the currently open table or file.
NOTE: The SOIC Find option supports “wild card” searches. The text that you type into the text entry box can contain an asterisk (*) that stands for any combination of characters. For example, if you type “farm*” into the box, the program will find “farm,” “farmer,” and “farming.” How to code a single recordThe SOIC system allows you to generate industry and occupation codes one record at a time.
NOTE: If codeable information exists, industry and occupation codes should be assigned almost immediately. Caution: Because “Code Record” saves the record as it is coded, the record cannot be restored to an earlier state with “Undo Field” or “Undo Record.” How to code a tableThe SOIC system allows you to generate industry and occupation codes in batch mode for all the records in a table at once. Because coding a large table can take some time, the program displays a “Coding Progress” bar on the left-hand side of the “Status” bar.
Caution: Because “Code Table” and “Code Rest of Table” saves each record as it is coded, records cannot be restored to an earlier state with “Undo Field” or “Undo Record.” How to sort dataRecords in an SOIC data table can be sorted using any of the fields on the Data Entry Form as criteria.
NOTE: Non-SOIC Access tables or Xbase files cannot be sorted. Caution: Because the sort option saves the active record,
records cannot be restored to an earlier state with “Undo Field” or
“Undo Record.”
How to show coding statisticsOnce a table or file has been coded, coding statistics for the records in the currently open table can be shown. The number of records that have industry codes assigned, the number that have occupation codes assigned, and the number that have both codes assigned are shown along with their corresponding percentages.
NOTE: These statistics also include the number of records coded ‘998.’ During software development, this code was selected to identify narratives with insufficient information to reliably assign a code. ‘998’ is assigned to either industry or occupation. Page last updated: July 10, 2007
Page last reviewed: May 13, 2008 Content Source: National Institute for Occupational Safety and Health (NIOSH) |
|
||||||||