Courses in Twickenham

...slides Use formatting to create a consistent, sophisticated presentation Understand the elements of good slide design Combine information for other applications... Learn about: Microsoft Powerpoint, Drawing flowcharts, Ms PowerPoint...

...an Access database Adjusting Settings Changing between view modes in a table, form, report Displaying and hiding built-in toolbars Tables Creating... Learn about: Deleting a query, Database training, Running a query...

...a query using the operators , >=, = , AND, OR Editing a query by adding or removing criteria Editing a query by adding, removing, moving, hiding... Learn about: Sorting records, Preparing outputs, Running a query...

...the importance of setting rules to ensure relationships between tables are valid First Steps with Access 2010 Databases Opening and closing Access... Learn about: Sorting records, Deleting a query, Preparing outputs...

...field properties Understanding what a primary key is Understanding what an index is Understanding the purpose of relating tables in a database Understanding... Learn about: Microsoft Access, Deleting a query, Sorting records...

...the importance of setting rules to ensure relationships between tables are valid First Steps with Access 2016 Databases Opening and closing Access... Learn about: Sorting records, Deleting a query, Preparing outputs...

...layout controls Report design •Inserting a data field to appear within report header or on footers on the first page or all pages •Forcing page breaks... Learn about: Query Design, Microsoft Access, Report Design...

...This course aims to give delegates an insight into some of the more advanced features in MS Access 2003. On completion of the course delegates will... Learn about: Action Queries, Update Queries, Grouping to Reports...

...using the Journal Interact with the Internet Work offline and remotely Create a custom form Collaboration Connecting with colleagues via Outlook Social... Learn about: Group schedules, Social Connectors, Mail Merge...

...This course aims to give delegates an insight into some of the more advanced features in MS Access 2007. On completion of the course delegates will... Learn about: Split forms, Microsoft Access, Refining Queries...

...on a form Creating a subform and linking it to parent Modifying the subform to change records displayed Split forms Calculations in Reports Creating arithmetic... Learn about: Running A Macro, Data prompt, Creating arithmetic...

...average, max, min, concatenate Creating running summaries in a report Macros Recording a simple macro Running a macro Assigning or attaching a macro to a... Learn about: Unmatched values, Advanced Forms, NOT values...

...duplicates Showing unmatched values Showing the highest or lowest range of values in a query Parameter queries - allowing query input from a data prompt... Learn about: Query Types, Refining Queries, Microsoft Access...

...Microsoft Access is a Database Management System (DBMS) that you can use to store, query and report on your data. Using Access ‘out of the box’ can be... Learn about: Microsoft Access, Variable Scope, Data Types...

...This course aims to give delegates an introduction to the Microsoft Outlook 2003 application. On completion of the course delegates will have learnt... Learn about: Editing notes, Sorting mail, Filtering views...

...Using Search folders Printing messages and attachments Calendar Navigating within the Calendar Scheduling appointments and events Modifying appointments... Learn about: Managing Meetings, Reading messages, Managing junk e-mail...

...editing and deleting contacts Using contacts Using the People Pane Tasks Creating and updating one-time tasks Assigning tasks to others Accepting and declining tasks... Learn about: Reading messages, Managing Meetings, Outlook

...

...Reading pane, To-Do bar Help facilities E-mail What is e-mail? Opening e-mail messages - Quick Flag icon, Assigning colour categories to messages Replying... Learn about: Editing notes, Filtering views, Managing e-mail...

...Customising Outlook 2007 The Outlook 2007 environment Groups and shortcuts Address books Customising messages Customising the appearance of messages E-mail... Learn about: Setting rules, Personal folders, Public folders...

...Customise Outlook Share Outlook information Save and archive mail Customising Your Mail Use message stationery Creating custom stationery Modify message... Learn about: Assistant settings, Archiving Mail, Filter messages

...