[Histonet] MS access and histology

[Becky Barnhart]

I built an access database to save my statistics.  We have Meditech as an 
LIS and I run monthly reports and enter the data into my access database. 
This way I can more easily see the specific information I want.  Also not 
everyone has access to the reports in Meditech and to get some of the 
information there are calculations and it is much easier just to put a date 
range in and let the computer do all the calculations. Our pathologist loves 
it.

I am at home right now so I can't look in to see all the reports I have but 
some are:
1.) Workload broken out into surgical blocks and slides, cytology blocks and 
slides, autopsy blocks and slides, recuts, special stains, conventional pap 
smears and liquid base paps (I think that is it).
2.) The amount of specimen we receive in just from those outside our regular 
service area.
3.) Cytotech for her annual and 6 month reviews
4.) Surgical service committee that shows how many cases (surgical, Non gyn, 
Gyn), how many frozen section, FNA and consults and if they all agree or 
disagree.
5.) Our turnaround times for each specimen type
6.) Amount we charge out each month

All of the reports prompt for a date range so I can get the amount of data I 
need.

If I can be of any help let me know.  You may contact me either at home or 
work (rbarnhart <@t> summithealth.org) is probably better so I can look at my 
database.

Becky Barnhart



----- Original Message ----- 
From: "Bonnie Whitaker" <bwhitaker <@t> brownpathology.com>
To: "'Jackie M O'Connor'" <Jackie.O'Connor <@t> abbott.com>; <WWmn916 <@t> aol.com>
Cc: <histonet-bounces <@t> lists.utsouthwestern.edu>; 
<histonet <@t> pathology.swmed.edu>
Sent: Tuesday, January 11, 2005 5:44 PM
Subject: RE: [Histonet] MS access and histology


> Maybe Tim Morken will speak up here..... He has used Access extensively, 
> and
> very successfully.
>
> Bonnie Whitaker
>
>
> -----Original Message-----
> From: histonet-bounces <@t> lists.utsouthwestern.edu
> [mailto:histonet-bounces <@t> lists.utsouthwestern.edu] On Behalf Of Jackie M
> O'Connor
> Sent: Tuesday, January 11, 2005 4:07 PM
> To: WWmn916 <@t> aol.com
> Cc: histonet-bounces <@t> lists.utsouthwestern.edu; 
> histonet <@t> pathology.swmed.edu
> Subject: Re: [Histonet] MS access and histology
>
>
> Access was a little too much for some of  the PhD's to comprehend here -
> so we went to a very simple program, FileMakerPro.  I use it to log
> virtually everything - Accession numbers, workload, IHC requests - you
> name it.  I designed the database to fit my needs, so of course I love it.
> My only gripe is that you don't have to hit a save key when you enter
> information - so if you make a mistake and accidentally hit the wrong key
> or enter data in the wrong file, you'd never know it - well, until it was
> found later.  Besides that - it's great.  It has a lock out function, too,
> so that other people cant enter data - we have it on our common drive so
> the info is accessible to everyone, but only a select few can enter
> selected data.
> Jackie
>
>
>
>
> WWmn916 <@t> aol.com
> Sent by: histonet-bounces <@t> lists.utsouthwestern.edu
> 01/11/2005 03:19 PM
>
>
>        To:     histonet <@t> pathology.swmed.edu
>        cc:
>        Subject:        [Histonet] MS access and histology
>
>
> Hello again
> I'm thinking of setting up a system for not only supplies and
> inventory....but to use access for logging request (levels, recuts, ipox
> request, special stains, etc.) I hoping to get rid of binders of manually
> logged paper tasks, print monthly tables, be able to extract information
> as I build my data base for use in statistics.
>
> There is a two day Access training seminar coming up soon.  I'm doing
> ebook instructionals beforehand.  I found myself wondering how extensively
> Access is being used in histology for logging request, special stains and
> ipox.
>
> Any suggestions are very welcomed.
>
> Deb King
> Sacramento, CA
>
> _______________________________________________
> Histonet mailing list
> Histonet <@t> lists.utsouthwestern.edu
> http://lists.utsouthwestern.edu/mailman/listinfo/histonet
>
>
> _______________________________________________
> Histonet mailing list
> Histonet <@t> lists.utsouthwestern.edu
> http://lists.utsouthwestern.edu/mailman/listinfo/histonet
>
>
> _______________________________________________
> Histonet mailing list
> Histonet <@t> lists.utsouthwestern.edu
> http://lists.utsouthwestern.edu/mailman/listinfo/histonet