Introduction to MS Access for Medical Research
New graduates, GPs, nurses, allied health professionals, clinicians and medical researchers wishing to maximise their study results through using databases
Who offers the course?
- Level of assumed/required knowledge
- Course goals
- Course duration
- How is this course assessed?
- Can this course contribute to an academic degree?
- Course delivery
- Course cost
- Course dates
- Is this course accredited for CME points?
- Further information and enrolment
- Contact person/Course coordinator
- Last updated
This course is designed to assist researchers to design and construct a database for their research project and manipulate the data to respond to complex queries.
Small datasets (such as spreadsheets) can be constructed with little database knowledge, however if you need to draw large amounts of information together, you will require greater understanding of the power of relational databases that is presented in this course.
The collective research experience and database expertise of Elena Belousova and Dr Brett Toelle from the Respiratory & Environmental Epidemiological research team at the Woolcock, will lead you through the core concepts in relational databases. We assume that the researcher has some experience with collecting and storing research data using spreadsheet or statistical analysis software and is looking to progress to the next level of database management and development.
- Understand the concepts of relational data structure for your research
- Recognize key structures and practical applications of relational databases such as MS Access
- Source complex information through data linkage processes and data retrieval
- Establish clear guidelines for data management and quality
Some of the selected topics and themes to be covered include:
- Identify relational data base structures and concepts
- Learn how to design a database from scratch.
- Learn how to design a table – the major object of the database
- Learn how to establish Referential Integrity between different tables
- Conduct simple to advanced queries
- Import and export data for processing
- Learn how to handle medical research data effectively
- Avoid corrupting your data through referential integrity
- Develop quality control processes to avoid duplicating data
- Ability to import and export data into different applications
- Resources to guide you in setting up your research project database
Elena Belousova MSc(AppMath) – Database Manager at the Woolcock
Brett Toelle DipAppSc(Nursing) BA(Psych) PhD - Senior Research Fellow at the Woolcock
8:30am - 4:30pm
This course is delivered face-to-face at:
Woolcock Institute of Medical Research
Level 5, Education Centre
431 Glebe Point Road
Glebe NSW 2037
Course fees include course materials, participation certificates and full catering throughout the day.
Full cost of the course is $500.
Register before 17th September for the Early bird rate of $425.
There are limited student registration places available at $375.
Please supply your own laptop/notebook computer with MS Access 2010.
Registration costs include GST. Your registration is confirmed when payment has been completed and receipted.
Cancellations of registration must be made in writing or via email. A fee of $48 applies if we are notified after Tuesday 7th October 2014.
Wednesday, 29th October 2014
Your registration is confirmed upon completing registration on the http://www.eventbrite.com.au website.
If you have additional questions please email
Dr Brett Toelle
Senior Research Fellow