5 Computer Skills courses in Dronfield

Face to face One to one.

This is an essential programme for any member of staff whose role requires a high level of attention to detail. The focus is specifically on the handling of text and data, whether at the input stage or when collating information into reports and documents for use by others. The session looks at both prevention and cure. For 'prevention', it focuses on understanding how common errors occur and on developing an awareness of the factors which influence our level of attentiveness. It introduces key psychological theories around attentiveness including the 'capacity' and 'bottleneck filter' models. And it looks at how working styles can affect attention to detail. For 'cure', the programme looks at how to minimise the effect of stress on concentration as well as introducing a number of tools and techniques for promoting accuracy - at both the input and the checking stages. Particular attention is paid to proof-reading techniques. By the end of the session, participants will: * Appreciate why errors occur * Understand how stress and other factors can affect focus and accuracy * Know how to improve accuracy and reduce errors when handling text and data * Be able to proof-read text and number-based documents more accurately 1 THE IMPORTANCE OF ACCURACY * The impact of mistakes * Why accuracy is so important * Main reasons why errors occur 2 ATTENTIVENESS THEORY * The 'capacity' and 'bottleneck filter' models * Selective attention * Chunking - big picture / little picture 3 PREPARING FOR ACCURACY * Working styles - how they affect detail-orientation * Identifying and minimising the impact of stress on concentration 4 PRACTICAL STRATEGIES * How to improve accuracy and reduce errors when inputting text * Managing interruptions and distractions * Proofing text and numbers

£ 10 per session (when doing this with others, in a small group). £50 for all 6 sessions * A series of hourly small group sessions where we look at different aspects of Publisher * In each session, we'll be covering a different aspect of Publisher * Would you like us to cover anything specific? Contact us! Alternatively, we can do you one-to-one sessions, either via virtual classroom or in person at our training course. These are £25 per hour, or £100 for 5-hour blocks.

This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists. This course will help participants: * Create and manage the layout of paragraphs * Create and manage multi-level numbered paragraphs * Effectively insert, use and manage section breaks * Create and manage columns * Find, create and apply styles * Create and update a table of contents from styles * Work with styles to manage formatting * Work with sums in tables and use table headings * Input and edit text using AutoText * Work with SmartArt graphics * Link to other files using paste special 1 MANAGING PARAGRAPH LAYOUT * Controlling paragraph layouts with indents * Creating and managing paragraph hanging indents 2 NUMBERING PARAGRAPHS * Creating a new multi-level numbered paragraph * Managing existing multi-level numbered paragraphs 3 INSERTING COLUMNS * Creating columns from existing paragraphs * Setting up columns * Managing columns 4 DOCUMENT SECTION BREAKS * Controlling document layout using section breaks * Managing page orientation using section breaks * Managing page numbering using section breaks 5 USING STYLES * Applying quick styles * Finding existing styles * Creating and saving styles * Modifying styles * Creating a table of contents from styles * Updating a table of contents 6 USING QUICK PARTS * Saving content to quick parts * Modifying saved quick parts * Inserting content using AutoText * Editing AutoText entries * Inputting text using AutoCorrect 7 ADVANCED TABLE FEATURES * Sorting table columns * Running sums in tables * Repeating table headings at top of page * Importing Excel content in tables * Using table properties 8 CREATING A MAIL MERGE * Creating letters, labels and emails * Merging addresses from external files * Using Outlook's address book to merge * Merging to email 9 SMARTART GRAPHIC * Visually communicate content with SmartArt * Choosing a SmartArt graphic * Inputting into SmartArt * Modifying and formatting SmartArt graphics 10 LINKING TO OTHER FILES * Linking to files using paste special * Linking an Excel chart to a document * Managing linked content from Word

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: * Ensure the integrity of their databases * Manage field properties * Use the query functions effectively * Save time with the query expression builder * Create different types of query more quickly * Design better forms * Link expressions in forms * Create better and more useful reports * Import and export tables more easily 1 TABLE RELATIONSHIP INTEGRITY * Identifying relationships * Identifying criteria for data integrity * Applying referential integrity * Managing relationship join types 2 TABLE FIELD PROPERTIES * Field properties overview * Using input mask field * Using default value fields * Using field validation rules 3 QUERY FUNCTIONS * Running aggregate function calculations * Running sum, average, count, max and min functions * Grouping calculated data 4 QUERY CALCULATIONS * Using query operators and expressions * Adding calculated fields to a query * Using the query expression builder 5 ACTION QUERIES * Creating make table queries * Creating append queries * Creating update queries * Creating delete queries 6 DESIGNING FORMS * Adding form controls * Aligning and arranging form controls * Adding pictures and labels to forms * Adding new fields to a form * Controlling tab order * Adding command buttons * Adding a combo box control * Formatting data using conditional formatting 7 FORM EXPRESSIONS (CALCULATIONS) * Using the form expression builder * Working with a property sheet within a form * Linking expressions within a form 8 WORKING WITH REPORTS * Creating reports with the report wizard * Inserting report fields * Formatting fields * Inserting report headers and footers * Working with a property sheet within a report 9 GROUPED REPORTS * Creating groups with the report wizard * Sorting grouped data * Grouping alphabetically * Grouping on date intervals * Creating sub reports * Adding calculations to groups 10 IMPORTING AND EXPORTING TABLES * Importing tables into Access * Exporting tables from Access * Importing and linking data in Access