Searches & Reports - Part 3
This course is designed especially for Vision users who
are able to run complex searches and reports, but would like
to learn flexible and powerful methods of interrogating
their results.
A typical Vision system holds a huge amount of clinical
data, but many practices don't know how to translate this
data into useful information.
This course will show Vision users how to identify
invaluable information that can help to prioritise patient
care, highlight problems with their data or spot trends and
weaknesses at an early stage. It will even enable delegates
to identify invalid or miscoded data or items entered in
free text.
The course will also explain how to use Microsoft Excel to
view information in easily understood graphical and table
formats.
Aims and Objectives
- Learn how to run complex
clinical searches and attach appropriate Report
selections
- Understand the export and
import process
- Discover the power of
Microsoft Excel and learn how to translate vast amounts
of data into meaningful information
- Learn how to interrogate
data to identify items stored in free text
Who Should Attend?
Members of staff who are currently responsible and capable
of running complex Vision searches. Ideally, they should
also have a basic understanding of Microsoft Excel.
Course Content
- Brief recap of Advanced
Searches
- Complex Vision Searches
- Batches
- Schedule
- Group input\output
- Using Clinical Audit
Groups
Exporting Data from Vision
- The export process
- Protecting existing files
- DBF or CSV
Importing & Analysing Data in Excel
- The import process
- Tidy up functions
- Sorting Data
- Autofilter
- Running Pivot Tables
Setting up MSQuery
- Installing a driver (if
required)
- Overview of process
- Purposes for using MS
Query
- Set up Options
Running MSQuery
- Running a query
- Choosing fields
- Linking Databases
Course Duration - 5 hours
Course Type - Hands on (Computer Systems supplied
by INPS on the day)
Please note: Maximum of 2
delegates per PC
Lunch: A light sandwich lunch will be provided
Please call or e-mail to book
Click here to view the booking form
Susan Knox
02476 422077
susan.knox@inps.co.uk
or
Sarah Deeley
02476 422367
sarah.deeley@inps.co.uk |
