General IT training

---

Access 2010: building Access databases (CC1ACD)

Description: This 1.5 day course is suitable for those who want to gain hands-on experience of the basic "building blocks" involved in developing a simple Access database. The course concentrates on the development of a relational database including building new tables, linking tables to related tables, creating and modifying data entry forms, creating advanced queries and generating and modifying reports. Some relational theory is also included so as to contextualise the hands-on development.

Pre-requisites: You must have attended "Access 2010: an introduction" (ACC1IAC) before attending this course, or otherwise have experience of using Access, especially of developing Access queries. Without this prior experience it is likely that you will not benefit from attending this course.
Note that this course will be of little or no use to those using Access 2003 or earlier versions of Access. On the other hand, it can be useful to those with experience of earlier versions of Access who want to find out how to achieve common development tasks within the updated 2007/2010 interface.

Duration: 1.5 days

Return to top of this page

---

Introduction to Gmail (CC1IGM)

Description: From Wednesday 3rd April, all staff at the University will be using Google mail (Gmail).
This is a 1 hr session presenting a few tips, tricks and "extras" to help get you going when you switch over to Gmail. There will also be an opportunity to ask any questions you may have about using the various features of Gmail.

Pre-requisites: None

Duration: 0.1 of a day

Return to top of this page

---

Google Calendar: Getting Started (CC1GGC)

Description: From Easter 2013 the University is switching from Oracle to Google calendar.
This 2 hr training session covers how to create and manage events (eg meetings) in Google calendar, inviting others and booking resources such as rooms. You will also have a chance to discuss the guiding principles for using calendar at Bristol. Session objectives are:

• managing events in your own calendar and inviting guests
• creating public and private events
• letting others view or manage your calendar
• booking resources, such as rooms and equipment

Pre-requisites: None

Duration: 0.2 of a day

Return to top of this page

---

Capturing and optimising digital images for research (CC1SOP)

Description: This course covers the essential skills needed to optimise the visual quality of digital images obtained from a scanner or a digital camera. You will develop an understanding of the key concepts associated with digital imaging (e.g. image resolution, bit depth, colour management, file formats, etc) and learn how to best prepare your digital images both for screen and print output.
Target audience: Primarily academic and research staff using digital images for teaching or research purposes and wanting to ensure that they are getting the best from them.
Note that we use Serif PhotoPlus on this course, but the techniques used are transferable to other imaging packages such as Photoshop.

Pre-requisites: Confidence in using Windows, a keyboard and a mouse.

Duration: 0.5 of a day

Return to top of this page

---

Self-paced learning in Word, Excel or PowerPoint (CC1SPL)

Description: If you cannot make the date of a taught course, have attended a course and want to work through some of the notes again, or prefer to work at your own pace, then a self-paced session might be appropriate for you. This self-paced workshop will allow you to look at Email, Oracle Calendar, Word, Excel or PowerPoint. You can pick the topics that are most relevant to you and work at your own pace with a trainer present. Please note that this session is not suitable for people who require lengthy and structured tuition.

Pre-requisites: Before attending a self-paced session you must have at least basic computer skills. If you do not, please contact Amy Bryant for help with getting started. Tel: 0117 9546976.

Duration: 0.5 of a day

Return to top of this page

---

SPSS statistics package: Getting started (CC1STA)

Description: SPSS is a statistics package available for PC"s. During this taught course you will work through a sequence of tasks: from preparing an Excel spreadsheet for use in SPSS, simple data exploration, simple analysis and producing graphs, to exporting the output for use in a PowerPoint presentation.
During the afternoon session there will an opportunity to look at some data you have brought with you, and investigate statistical options more relevant to your needs. Please note that there is only one trainer and extra support will be shared equally among those who need it.

Pre-requisites: At least an elementary knowledge of simple statistics such as t-tests, chi squared tests, p values and confidence intervals (statistical theory is not taught on this course).

Duration: one day

Return to top of this page

---

Access 2010: An introduction (CC1IAC)

Description: This course provides an introduction to Access, giving delegates experience of data entry, using tables and data entry forms, filtering data, using queries, and creation of reports. The course is designed to act as a "taster" for those who want to see what Access can do or for those who have just "inherited" a pre-existing database. This course can also be useful for those who have recently converted to Access 2007 or Access 2010 and want to find out how to achieve common tasks within the updated 2007/2010 interface.

Pre-requisites: This course provides a general introduction to Access. Note that this course will be of little or no use to those using Access 2003 or earlier versions of Access. On the other hand, it could be of use to those who have experience of earlier versions and who have recently converted to Access 2007 or Access 2010 and want to find out how to achieve common tasks within the updated 2007/2010 interface.
Before attending you must be familiar with Windows and general Microsoft software, such as Word or similar - if you are not, please contact Amy Bryant, tel: 0117 9546976 for help with getting started

Duration: 0.5 of a day

Return to top of this page

---

Self-paced learning in Gmail/Calendar (CC1SPLG)

Description: This self-paced workshop provides you with hands-on experience of Google email (Gmail) and calendar and lets you work through various tasks at your own pace - you can either work through the course document(s) or pick and choose just those parts that are relevant to your particular requirements. A trainer will be present to answer your Gmail and Google calendar questions.

Pre-requisites: You must have a University of Bristol Google email/Google calendar account.

Duration: 0.5 of a day

Return to top of this page

---

If all courses are full or you cannot attend on any of the above dates, in order to assist us in future planning please click on the "Expression of interest" link.