JMD Training and Consultancy courses

...They will be able to: Link multiple workbooks Print workbooks Use one and two-way data tables Audit a worksheet Create and use PivotTables and reports Use Solver... Learn about: Data Analysis Tools, MS Excel, Microsoft Excel...

...Queries Multi-table Queries Adding Calculated Fields to Queries Access Forms Form Sections Form Controls Layout of Form Controls Properties of Form Controls... Learn about: Form Controls,
Relationship Types, Database training...

...Report design Inserting a data field to appear within report header or on footers on the first page or all pages Forcing page breaks for groups on reports Importing... Learn about: Query Design, Form Design, Report Design...

...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: Microsoft Access, Query Design, Report Design...

...skills in using Microsoft PowerPoint 2010. They will be able to: Create and edit slides using a variety of layouts and styles Add additional objects... Learn about: Automatic slide shows, Ms PowerPoint, Multimedia

...

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

...Reports Creating and saving a report based on a table or query Changing arrangement of data fields and headings within a report layout Grouping data under... Learn about: Sorting records, Preparing outputs, Table
...

...footers Deleting a form Saving and closing a form Searching and filtering Using the search command for a specific word, number, date in a field Applying... Learn about: Microsoft Access, Database training, Sorting records...

...minimum, maximum, average, count, at appropriate break points Adding and modifying text in report headers and footers Deleting a report Saving and closing... Learn about: Sorting records, Database training, Preparing outputs...

...within a report layout Grouping data under a specific field in a report in ascending or descending order Presenting specific fields in a grouped report by... Learn about: Preparing outputs, Database training, Deleting a query...

...Navigating to next record, previous record, first record, last record, specific record using form display Adding and modifying text in form headers... Learn about: Running a query, Preparing outputs, Microsoft Access...

...records •Adding fields to tables •Field templates Microsoft Access Query design •Grouping information in a query •Using a crosstab query •Using wildcards... Learn about: Report Design, Option groups


, Database training...

...Exporting Datasheet views to HTML Data Access Pages Advanced Microsoft Access Queries Filtering Query results Parameter Queries Summary Queries Formatting... Learn about: Microsoft Access, Parameter queries, Update Queries...

...Managing your Calendar Group schedules Managing contacts Mail merge Performing mail merges Templates and Forms Working with templates Creating a custom... Learn about: Social Connectors, Group schedules, Modify a journal entry...

...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: Parameter queries, Refining Queries, Query Types...

...records in a table Creating and using a query to save the selected information as a table Appending records to a table using a query Refining Queries Showing... Learn about: Creating arithmetic, Running A Macro, Microsoft Access...

...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: NOT values, Microsoft Access, Forms features...

...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: Advanced Forms, Query Types, Microsoft

...

...the Value of Expressions Handling Errors Understanding Error Handling Understanding VBA’s Error Trapping Options Trapping Errors with the On Error Statement... Learn about: Data Types, Microsoft Access, Variable Scope...

...use Microsoft Outlook 2003. They will be able to: Send and receive mail Schedule appointments, events and meetings Create and manage tasks Organise contacts... Learn about: Creating notes, Outlook


, Filtering views...