JMD Training and Consultancy courses

...PivotTables and Reports Creating a PivotTable report Creating a PivotChart report Resetting a summary function in a PivotTable report Creating a PivotTable... Learn about: Goal seek, MS Excel, SmartArt graphics...

...using Microsoft Access 2003. They will be able to: Use field properties for protection Understand table relationships and referential integrity Create... Learn about: Relationships Defined, Control Wizards, Form Sections...

...Using arithmetic and logical expressions in a query Form design Using bound and unbound controls Creating and editing a combo box, list... Learn about: Table design, Microsoft Access, Database training...

...and editing a lookup in a field Creating and editing a validation rule in a field Creating and editing an input mask in a field Applying and modifying... Learn about: Report Design, Form Design, Multiple values



...

...This course aims to give delegates a greater understanding of Microsoft PowerPoint 2010. On completion of the course delegates will have improved their... Learn about: Action buttons, Multimedia

, Ms PowerPoint...

...Merging slides and presentations Merging a word-processed outline into a presentation Applying background effects to slides Exporting slides in... Learn about: Managing presentations, Drawn objects, Microsoft Powerpoint...

...a specific field in a report in ascending or descending order Presenting specific fields in a grouped report by sum, minimum, maximum, average... Learn about: Running a query, Database training, Preparing outputs...

...They should also be able to create and use tables and forms, and be able to retrieve information from a database using queries and reports. MS Access Database... Learn about: Microsoft Access, Preparing outputs, Database training...

...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, Deleting a query, Preparing outputs...

...specific record Deleting a table Saving and closing a table Defining a primary key Indexing a field with and without duplicates Changing field format attributes such... Learn about: Running a query, Deleting a query, Microsoft Access...

...descending, numeric and alphabetical order Reports Creating and saving a report based on a table or query Changing arrangement of data fields and headings... Learn about: Database training, Sorting records, Microsoft Access...

...outer and self joins •Applying and using referential integrity •Applying automatic deletion of related records •Relating or joining data when designing... Learn about: Table design, Query Design, Table Relationships...

...Exporting Datasheet views to HTML Data Access Pages Advanced Microsoft Access Queries Filtering Query results Parameter Queries Summary Queries Formatting... Learn about: Grouping to Reports, Join Types, Microsoft Access...

...This course aims to give delegates advanced skills in using the Microsoft Outlook 2010 application. On completion of the course delegates will have learnt... Learn about: Group schedules, Modify a journal entry, Mail Merge...

...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: Refining Queries, Query Types, Split forms...

...queries Produce reports Record and assign macros Query Types Creating and using a query to update data in a table Creating and using a query to delete... Learn about: Creating arithmetic, Refining Queries, Logical expression...

...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: Microsoft Access, Advanced Forms, Assign macros...

...Refining queries using Null and NOT values Advanced Forms Creating arithmetic and logical expression controls on a form Setting sequential order of controls... Learn about: Query Types, Microsoft

, Microsoft Access...

...a programming language which can be used to build your own applications. Within this Integrated Development Environment (VBA is part of the Microsoft Office... Learn about: Trapping Errors



, Visual Basic, Handling Errors...

...and declining tasks Changing the view for tasks Creating tasks from other Outlook components Organising tasks into categories Notes Creating notes Editing... Learn about: Setting reminders, Declining tasks, Creating notes...