In this tutorial: Introduction > Getting Started > Your skills rating > What is a Database? > Start the Database Application > Creating Field Names > Entering Data > Create the Patient Table > Using Field Properties > Creating Lookup Tables > Relationships Between Tables > Types of Relationships > Create a Relationship > Use Queries to Extract Information > Produce Reports to Display the Data > Importing Data > Skills list > What Next and Summary
All Pages in this tutorial
In this tutorial you will learn how to use Microsoft Access 2010 to create and build a relational database. You will create some tables and enter data and use queries to extract information and create a report.
You should have attended the Introduction to Databases lecture that precedes this practical. If you missed this lecture, or would like to review the lecture notes, please refer to the handout.
By the end of this session you should be able to:
© 2012 Learning Technologies for Medical Sciences,
School of Medical Sciences Education Development,
Webmaster. Managed by Mrs Rebecca McCready.
Academic IT Skills tutorials and materials by Rebecca McCready (Newcastle University) is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
Permissions beyond the scope of this license may be available at MedIT.Exercises@ncl.ac.uk.