Creating  
an Access Database:  
A Primer for Resource Center Managers   

 by   
Laura C. Larsson


Sample ProCite Records

Comments:

When you look at these records below, what do you see? You can see that each of the records is organized into fields and that most of the fields have information (data) in them. And that the information in the fields looks vaguely the same. 

What you have to do is decide which fields go with which "subject" in order to design the database. 

Please be aware that just because I have included fields in my database doesn't mean that you have to also. Your database should reflect how you work with your journals. In fact, in the interests of keeping the database relatively simple, I have removed some of the fields I use to capture information in in my own database. 

Links to Samples 

Sample Record 1 
Sample Record 2 
Sample Record 3 
Sample Record 4 
Sample Record 5 
 

Sample Record 1 

Full journal name:  American Journal of Health Promotion 
Abbreviated title:  Am J Health Promot; AJHP 
Issues received
1997 11: 2 4 5 6 
1997 12: 1 2 
1998 12: 3 4 5 
Year Journal Started:  1986 
Frequency of Pub:  Bimonthly 
Issue Contents:  Contents are labelled "In Brief" and include: Publisher's Notes; Intervention Focus; Strategies; Applications; Research; Exchange (this section may include: Critical Issues and Trends, Practitioners' Forum, Innovative Programs, Applied Research Briefs, Conference Proceedings, Resource Reviews, Perspectives Beyond Health Promotion, Conference Calendar). Two sections not listed in the Table of Contents appear at the end of the journal. One is "Database" which critiques articles cited in the current issue. The other is "Abstracts" which represent the results of database searches performed by the Fitness Research Center at the University of Michigan, Ann Arbor 
Issues claimed: 
Peer Reviewed:  No 
Publisher's Name:  American Journal of Health Promotion, Inc. 
Publisher's Address:  1812 S. Rochester Road, Suite 200, Rochester Hills, MI 48307-3532 
Web:  no Web page
Goal of Journal:  "The editorial goals of the AJHP are to provide a forum for exchange between the many disciplines involved in health promotion and to provide an interface between researchers and practitioners. We define health promotion as the science and art of helping people change their lifestyle to move toward a state of optimal health. We define optimal health as a balance of physical, emotional, social, spiritual, and intellectual health. We believe lifestyle change can be facilitated through a combination of strategies to enhance awareness, change behavior, and create environments that support good health practices. Of the three strategies, supportive environments will probably have the greatest impact in producing lasting change." 
Notes:  We receive occasional copies in hsic 
Journal notes:  Refereed serial. All members of the Association for Worksite Health Promotion receive the Journal as a membership benefit. (Name of association changed in 1993 to above from the former name: Association for Fitness in Business.) 
As of 1997 some issues are accompanied by the newsletter "The Art of Health Promotion." (Listed in Serials as a separate title). 
As of 1998 some issues are also accompanied by the newsletter "Health Promotion: Global Perspectives" (Listed in Serials as a separate title). 
Call No & Location:  hsic, hsl 
Subject Headings:  Worksite Health Promotion / Health Promotion /Core Journal 
 

Sample Record 2 

Full journal name:  Hospitals & Health Networks 
  Formerly: Hospitals 
Abbreviated title: 
Issues received:  
1997  71: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21  22  23 24 
1998  72: 1 2 3 4 5 6 7 8 9 10 
Year Journal Started:  1993 (this title) 
Frequency of Pub:  Twice a month (the fifth and twentieth) 
Issue Contents:  Cover stories; Features; News at deadline; Data watch; CEO Poll; Trends; The Last Word; Index to Advertisers; Classified Ads; 
Issues claimed: 
Peer Reviewed:  No 
Publisher's Name:  American Hospital Publishing, Inc. 
Publisher's Address:  737 N. Michigan Ave., Chicago, IL 60611 
Web:  http://www.hhnmag.com/hhn-home.html 
Goal of Journal:  A news publication of the American Hospital Association aimed at the health care executive. 
Notes:  8/14/85: We have kept some special issues from back years.  Add volume and issue number to Table of Contents page.  Copy Data Watch for L2 
6/5/93 Title change: Hospitals & Health Networks. Former title: HOSPITALS 
Call No & Location:  hsic, hsl 
Subject Headings:  Organization and Administration / Marketing of Health Services / Statistics / Hospital Administration / Hospitals / Core Journal 
 

Sample Record 3 

Full journal name:  Inquiry 
Abbreviated title:  Inquiry 
Issues received:  
1994 31: 1 2 3 4 
1995 32: 1 2 3 4 
1996 33: 1 2 3 4 
1997 34: 1 2 3 4 
1998 35: 1 
Year Journal Started:  1963 
Frequency of Pub:  Quarterly: Spring, Summer, Fall, Winter 
Issue Contents:  The View from Here; Guest Editorial; Papers; Research Notes and Data Trends; Book Reviews; Publications Received 
Issues claimed: 
Peer Reviewed:  yes 
Publisher's Name:  Blue Cross and Blue Shield 
Publisher's Address:  Inquiry  P.O. Box 527 Glenview, IL  60025 
Web:  not available
Goal of Journal:  Inquiry seeks to contribute to the continued improvement in the nation's health care system by providing a thoughtful forum for the communication and discussion of relevant public policy issues, innovative concepts, and original research and demonstrations in the areas of health care organization, provision, and financing. 
Notes:  "The Journal of Health Care Organization, Provision, and Financing." 
Call No & Location:  hsic, hsl 
Subject Headings:  Insurance and Reimbursement / Costs and cost analysis / Health services research / Insurance, Hospitalization / Insurance, Health / Core Journal 
 

Sample Record 4

 Full journal name:  Journal of Ambulatory Care Management 
Abbreviated title:  J Ambulatory Care Manage 
Issues received:  
1995 18: 1 2 3 4 
1996 19: 1 2 3 4 
1997 20: 1 2 3 4 
1998 21: 1 
Year Journal Started:  1978 
Frequency of Pub:  Quarterly 
Issue Contents:  Foreword, From the Editor, Letters to the Editor, Articles, Notices (Conferences, Symposia, Continuing Education) 
Issues claimed: 
Peer Reviewed:  Peer reviewed 
Publisher's Name:  Aspen Publishers, Inc. 
Publisher's Address:  200 Orchard Ridge Dr., Gaithersburg, MD 20878 
Ordering Information:  Fulfillment, Aspen Publishers, Inc., 7201 McKinney Circle, Frederick, MD 21701 
1/26/93 PO# 255086 
Web:   http://www.aspenpub.com/jacm/
Goal of Journal:  JACM is a peer-reviewed journal that provides timely, applied information on the most important developments and issues in ambulatory care management 
Notes:  add unique issue titles to Upnni. 
Call No & Location:  hsic; hsl 
Subject Headings:  Ambulatory care / Organization and administration / Core Journal 

Sample Record 5 

Full journal name:  New England Journal of Medicine 
Abbreviated title:  N Engl J Med 
Issues received: 
1997  336:   2 3 4   6  9-16  18-20 22-25 
1997  337: 1-14   18 19 20  22-25 
1998  338:   2-10     13  15  16  18  19 
Year Journal Started:  1812 
Frequency of Pub:  Weekly 
Issue Contents:  Original Articles; Images in Clinical Medicine; Special Article; Review Article; Clinical Problem-solving; Case Records of the Massachusetts General Hospital; Editorials; Correspondence; Book Reviews; Books Received; Notices; Corrections 
Peer Reviewed: yes 
Publisher's Name:  Massachusetts Medical Society 
Publisher's Address:  10 Shattuck St., Boston, MA 02115-6094 
Ordering Information: as above 
Web:  http://www.nejm.org/
Goal of Journal:  "Presents original articles and interpretive reviews of a variety of developments in the major aspects of medicine, its science, its art and practice and its position in today's society." (Ulrich's 1992, p.3135) 
Notes: leading medical journal in the world 
Call No & Location:  hsl; Dean SPHCM, has subscription. 
Subject Headings:  Health Policy / Clinical Medicine / Clinical Trials / Ethics / Health Economics / International Health / Health Services Research / Public Health / Health Manpower / Insurance and Reimbursement / Community Health / Core Journal 
 

Next: Converting Excel to Access 

Back: Planning an Access Database 

Other: 


Table of Contents | References and Resources | Glossary
Page Updated: June 22, 1998

URL:  http://weber.u.washington.edu/~larsson/conf/aiha98/primer/samples.htm