Database Advice pages for the Public Health Research Group (PHRG), School of Population and Health Sciences at the University of Newcastle upon Tyne, UK

The last improvements were made on 26th July 2005.

NB Some of the links on these pages are local access only.
Ruth Wood - Database Adviser

Contents

Caution - The accuracy of any information published on the WWW cannot be guaranteed, please verify the authenticity of the original source.


There have now been people accessing these pages since the last update. from www.digits.com


Database Adviser job description

If you are starting a new project, or have collected or acquired some data and are wondering what to do next, perhaps I can save you time and effort. I can provide help in the following areas, but please don't hesitate to ask me about any other data related issues or problems, however large or small.


You can contact me on extension 7252 or by email at

R.C.Wood@newcastle.ac.uk


You can also find me on the 4th Floor of the William Leech Building, in Room M4084.

Back to Contents


Data management advice and Reports

The document outlining Good Practice in the Collection and Storage of Data is available either as a Word document or click here
A short summary of the the above document entitled "Guidelines for effective data management in the Department of Epidemiology and Public Health" is available either as a Word document or HTML

The University Data Preparation Service provides software, services and systems for the collection,management and interpretation of data. DPS offers a complete, confidential and comprehensive data processing/management service. This service can be used for projects which collect large amounts of data, requiring major resources to enter the data.

Computer skills and training needs report (part1) and (part2) These are Word documents and can also be found in S:\ph\Computer Info\Dept Computing Survey\Computer Info\SURVEY1.DOC and SURVEY2.DOC
If Netscape/Explorer is not configured to recognise Word files then Click here for help

The presentation about Research Governance at the Department Meeting on 18th April 2002
Also available by opening S:\ph\intinfo\Research Governance.ppt

Back to Contents



Databases for School and PHRG administrative information

I have set up some databases which help manage various types of administrative information. These databases all use MS Access 2002. If you have difficulty opening any of these databases then please let me know. It is no longer possible to open these databases directly from your web browser, instead start MS Access and open databases from the location shown below. These databases are all read only, apart from those authorised to update them.
These databases initially open showing a menu system to guide users through the available functions.


Back to Contents



Database software packages

Microsoft Access is the database software usually recommended for setting up research and admin databases in the University .
Newcastle ISS database service gives specialist advice about software used for all kinds of data management for academic work.
Computer assisted Qualitative Data Analysis software Information on a number of software packages from the University of Surrey.
EPI Info has some database capability and is available free.

MS Access database Information

I have developed applications using various version of MS Access, from version 2 up to the current MS Access2003 for a number of research projects. This usually involves creating user friendly interfaces for colleagues to enter data, randomise patients and also produce up to date reports and updates.
When the data entry is complete and the data has been cleaned, it is usually exported to SPSS using the OBDC facility or via Excel, in order to carry out the required statistical analysis.
A useful source of information and contact with other Access users is the Usenet Newsgroup comp.databases.ms-access. The archives of this group are searchable using the link to Google below.

There is also a local Mailbase list dbinfo which can be used to ask for help with database problems. The volume of traffic of this list is very low.
Here are some links to more sites with information about MS Access.


Back to Contents or return to Database software packages



Statistics and SPSS Information

There are a number of useful Usenet newsgroups, including comp.soft-sys.stat.spss.

SPSS sites

Other sites for various statistics packages


Back to Contents



Data Protection Act Registration, Research Governance, Consent and data storage

All data containing personal identifiers such as name, address, date of birth, postcode etc. which is stored at the University MUST be appropriately registered under the Data Protection Act. For the School of Population and Health Sciences (Public Health Research Group) we have to register via the Faculty of Medicine.
New forms can be completed and existing forms viewed in the "list of departmental research data sets" database S:\ph\DATABASES\LIST OF DATASETS\RESEARCH DATA.MDB for both research data and other administrative data such as student or staff details.
When new forms have been completed please print out and sign them, then pass them on to me (Ruth Wood) and I will keep a copy and pass them on the the Faculty's Medical Student Office.
There are now a checklist and instructions available as html here or as a word document .

Other information about the Data Protection Act, research governance, consent and confidentiality of patient information can be found on the following links.

IMPORTANT: Please avoid storing any identifiable data on shared access directories on turret1.
In general the S: drive is available to share information. Project directories can be set up on the P drive. These project directories should have limited access to the members of that project team only.
Please check with Juliet or Fraser if you are unsure of the status of a particular directory or you want to restrict access to a specific group of people.
Please also be aware that any identifiable data stored on your hard drive (C:) is also accessible to anyone else using your computer unless pasword protected. More importantly it will NOT BE BACKED UP regularly unless you personally take steps to do so and in the event of the hard disk failing the data will be lost.

Back to Contents



Data sets and other information


Back to Contents



Information from the DoH, NHS and central government


Back to Contents return to Data sets and other information



Publicly available data

There is a vast amount of publicly accessible health related data and information, including


Back to Contents or return to Data sets and other information



Details of Assessment scales, Questionnaires and codings


Back to Contents or return to Data sets and other information


Various Epidemiology, Public health, Health services research and medically related sites


Back to Contents or return to Data sets and other information



General information

Useful general data and information available over the Internet, includes


Back to Contents



Home pages of some relevent journals

You may need to register for some of these, but the library pays for access to those who charge.
Go to the library pages for a full list of available journals.
Instructions to authors in Health Sciences may also be a useful site.


Back to Contents



Useful documentation from the University's Information systems and services

All ISS Documentation

Selected documents which may be useful


Back to Contents


Usenet news groups

comp.databases.ms-access is quite a high volume Newsgroup, with 200-300 posts per day but there are probably other people asking similar questions, so its worth lurking for a while or checking the archives with Google.

comp.soft-sys.spss only gets 20-30 posts per day, so its much easier to scan down the list of posts and spot any useful information.

Alternatively use the Google service to search the Usenet archives for old messages dealing with your query.
Please contact me if you need advice in accessing Usenet Newsgroups from Netscape/Explorer.
If you are not familiar with Usenet News and the Internet then please read the relevant sections of the UCS sheet Rules of Use

Back to Contents

Email discussion lists

To join the local Mailbase list dbinfo. Send the message:-
subscribe dbinfo firstname surname
to

mailbase@ncl.ac.uk

Leaving the subject line blank and including no other information in the body of the message.

Back to Contents


Help in Configuring Internet Explorer

If you have problems downloading or opening files you may need to change your browser settings, please ask Juliet or Fraser for help.

Back to Contents


You can contact me on extension 7252 or by email at

R.C.Wood@newcastle.ac.uk

alternatively find me on the 4th Floor of the William Leech Building, in Room M4084.

Please let me know if any of the above links are not working.
Here's a link to my personal home page

Go to SPaHS Internal information

Go to SPaHS Main Web pages