Introduction to MS Access for Medical Research

Who is this course for?

New graduates, GPs, nurses, allied health professionals, clinicians and medical researchers wishing to maximise their study results through using databases

Who offers the course?

Woolcock Institute of Medical Research, Respiratory & Environmental Epidemiology (REE) research group

Level of assumed/required knowledge

None

Course overview

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.

Key outcomes:

  • 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

Course outline:
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

Key benefits:

  • 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

Course facilitators:

Elena Belousova MSc(AppMath) – Database Manager at the Woolcock

Brett Toelle DipAppSc(Nursing) BA(Psych) PhD - Senior Research Fellow at the Woolcock

Course duration

One day
8:30am - 4:30pm

How is the course assessed?

Not applicable

Can this course contribute to an academic degree?

No

Course delivery

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 cost

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.

Course dates

Wednesday, 29th October 2014

Is this course accredited for CME points?

No

Further information and registration

Your registration is confirmed upon completing registration on the http://www.eventbrite.com.au website.

If you have additional questions please email

Contact person/Course coordinator

Dr Brett Toelle
Senior Research Fellow
E:

Last updated

August 2014