Appendix A
Data Analysis: Building a Nonbinding Allocation of Responsibility: A Model Database
Structure with Exemplary NBAR Application File (NBAR.mdb): A MS Access©
Database for Superfund-Type Allocation Analysis; and Exemplary NBAR Transaction
Documents
For environmental paralegals, being able to design and set up a database to assist with the
waste-in analysis is important. The NBAR database application file (NBAR.mdb) included
with this Appendix A provides an example of a working NBAR database, with related tables,
queries, and reports for data analysis. It provides instructors and students with a working
package that we designed to be easy to use and understand. It is recommended that
instructors work with college technology administrators to have both the MS Access
database application files and the related waste-in documents (wastedoc.pdf) installed onto
the computer laboratory machines and/or school networks, so that all students will have to
do is to click on a few buttons to run the program and to view the related documents.
Once opening the database application, students will need to review and assess the included
waste-in documents (wastedoc.pdf) and input the appropriate information into the
application. The database reports can then be printed to receive credit for the assignment.
For more detailed information about the NBAR application, or to get some ideas for
instructing your class in the design and development of an NBAR database application, see
the following User’s Guide.
, CERCLA NBAR DATABASE APPLICATION
USER’S GUIDE:
A MS ACCESS© APPLICATION FOR ALLOCATION ANALYSIS
by
Craig B. Simonsen
Copyright © 2005 Craig B. Simonsen
, CONTENTS
Introduction
Add or Edit Waste-In Data
Manipulate the Waste-In Data
Print the Data
, Introduction
This NBAR database application has been developed in conjunction with the textbook on
the Essentials of Environmental Law, 3rd ed. Its purpose is to illustrate and exemplify a
Superfund-type nonbinding allocation of responsibility (NBAR) database. Its use is
intended strictly for classroom use and discussion. The application is developed in MS
Access©. The author and publisher, outside of the classroom context where this application
was designed to be used, offer no representations, warranties, or user support of any kind.
The NBAR database was developed to provide students with a hands-on use of and practice
with a computer laboratory for building a waste-in allocation database. The related
transaction documents (wastedoc.pdf) are provided to use in data entry for the project.
The database supports several basic functions:
• Add or Edit Waste-In Data
• Manipulate the Waste-In Data
• Print the Data
Add or Edit Waste-In Data
Select the “WasteIn” table from the Objects viewer window to add new records to or edit
the WasteIn table.
The WasteIn table has the following field structure:
Field Name Field Type
Generator Text
Data Analysis: Building a Nonbinding Allocation of Responsibility: A Model Database
Structure with Exemplary NBAR Application File (NBAR.mdb): A MS Access©
Database for Superfund-Type Allocation Analysis; and Exemplary NBAR Transaction
Documents
For environmental paralegals, being able to design and set up a database to assist with the
waste-in analysis is important. The NBAR database application file (NBAR.mdb) included
with this Appendix A provides an example of a working NBAR database, with related tables,
queries, and reports for data analysis. It provides instructors and students with a working
package that we designed to be easy to use and understand. It is recommended that
instructors work with college technology administrators to have both the MS Access
database application files and the related waste-in documents (wastedoc.pdf) installed onto
the computer laboratory machines and/or school networks, so that all students will have to
do is to click on a few buttons to run the program and to view the related documents.
Once opening the database application, students will need to review and assess the included
waste-in documents (wastedoc.pdf) and input the appropriate information into the
application. The database reports can then be printed to receive credit for the assignment.
For more detailed information about the NBAR application, or to get some ideas for
instructing your class in the design and development of an NBAR database application, see
the following User’s Guide.
, CERCLA NBAR DATABASE APPLICATION
USER’S GUIDE:
A MS ACCESS© APPLICATION FOR ALLOCATION ANALYSIS
by
Craig B. Simonsen
Copyright © 2005 Craig B. Simonsen
, CONTENTS
Introduction
Add or Edit Waste-In Data
Manipulate the Waste-In Data
Print the Data
, Introduction
This NBAR database application has been developed in conjunction with the textbook on
the Essentials of Environmental Law, 3rd ed. Its purpose is to illustrate and exemplify a
Superfund-type nonbinding allocation of responsibility (NBAR) database. Its use is
intended strictly for classroom use and discussion. The application is developed in MS
Access©. The author and publisher, outside of the classroom context where this application
was designed to be used, offer no representations, warranties, or user support of any kind.
The NBAR database was developed to provide students with a hands-on use of and practice
with a computer laboratory for building a waste-in allocation database. The related
transaction documents (wastedoc.pdf) are provided to use in data entry for the project.
The database supports several basic functions:
• Add or Edit Waste-In Data
• Manipulate the Waste-In Data
• Print the Data
Add or Edit Waste-In Data
Select the “WasteIn” table from the Objects viewer window to add new records to or edit
the WasteIn table.
The WasteIn table has the following field structure:
Field Name Field Type
Generator Text
