| Creating
an Access Database: A Primer for Resource Center Managers by
|
Sample ProCite RecordsComments: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 SamplesSample Record 1Sample Record 2 Sample Record 3 Sample Record 4 Sample Record 5 Sample Record 1Full journal name: American Journal of Health PromotionAbbreviated 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 2Full journal name: Hospitals & Health NetworksFormerly: 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 3Full journal name: InquiryAbbreviated 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 4Full journal name: Journal of Ambulatory Care ManagementAbbreviated 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 5Full journal name: New England Journal of MedicineAbbreviated 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: |