noterudley

Note

To: Rudley Young

From: David Holoman

CC:

Date: 05/10/00

Re: Entering MARAMA PM2.5 data from hardcopy forms

Hi Rudley,

Here is what you need to do:

1) Working from the Main Menu, enter the site information for each monitor.

2) Enter the monitor information for each monitor.

3) On the Main Menu of Access, Select View/Design.

4) Find the Form Design Toolbar in Access. It may be docked to the top of the Access window; if it is, it will not have a title bar identifying it as the Form Design toolbar. Find in particular the Database Window icon. It looks like 3 forms stacked on each other in a staggered way.

5) In the database window find the tables tab and open the Filter table. You will want to enter your data directly into this table:

VA DEQ data name	MARAMA data name
Station Number, Sampler Number, Site Name	Monitor ID
Filter Type	"Sample"
Filter Number	Filter ID
Volume Sampled	Sampled Volume
Max Temp Difference	Max Temp Diff
Max Temp Difference Date	Date Max Temp Diff
Max Temp Difference Time	Time Max Temp Diff
Cassette #:	Cassette ID
Sample Run Date	Actual Start Date
%CV	Flow Coef (%)
Flow Rate Min, Avg, Max	Min, Average, Max Flow
Filter Temperature Min, Avg, Max	Min, Avg, Max Filter Temp
Ambient Temperature Min, Avg, Max	Min, Avg, Max Amb Temp
Ambient Pressure Min, Avg, Max	Min, Avg, Max Amb Pressure
Sample Receipt Date, Time	RetrievedDate

6) Regarding the remaining Lab data, select the Lab data form from the main menu form in the MARAMA PM 2.5 database. There you can enter the initial and final filter weight and the final weigh date.

In order to store information on a batch of filters, such as a group that was transported from field to office, select the Filter Events data form. You can add a batch to depict the movement from place to place, and associated the max temperature and technician associated with these events. While not required, these steps will allow you to QA the data more effectively in the Filter Data form.

Let me know if this doesn't answer your question.