5506 Productivity courses delivered Online

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers

Learn how to create a mail merge in Word to allow you to send personalized emails to groups of people. Course overview Duration: 2 hours This course looks at how you can create a list of contacts with emails and then build a document to email out to everyone. This ensures that everyone gets a personal email but no one else sees the recipients. Objectives  By the end of the course you will be able to: Create source data to use in a merge Create a document to email out Attach source data contacts Filter recipients Send out emails to all Content Creating source contact data Creating your source data in Excel Creating a Word mail merge document Starting a mail merge document Attaching your source contact data Building the document Emailing your document Previewing the results Running a test to a document Setting up any filters Sending your document to emails

Learn all the quick tips and tricks you didn’t know about in Word and how to properly setup new documents. Course overview Duration: 1 day (6.5 hours) Our Word Document Production (Part 1) course shows you how Word was designed to be used and demonstrates the powerful tools available. This course will enable you to originate professional documents with ease, ensuring that modifications are quick and uncomplicated. It looks at some of the common frustrations and how to avoid them. This course is aimed at existing Word users who want to get the best out of the package Objectives  By the end of the course you will be able to: Customise Word Use different Word views Use line, paragraph and page breaks correctly Set indents and tabs Use styles for easy formatting Work with section breaks Work with automatic correction features Insert and modify tables Content Word setup Using different views Customising the status bar Customising the Quick Access bar and Ribbon Document setup Using the Navigation Pane Using Show / Hide Line vs paragraph breaks Using page break Using the ruler Setting indents and tabs The different types of indent Using dot leader tab Bullets and numbering Working with simple numbered and bulleted lists Sorting lists Working with multi level lists Styles The importance of styles Creating, amending and applying Character Styles Amending and applying Paragraph Styles Setting bullet point styles Using the Style Inspector Reorganising a document Using Outline View Promoting and demoting headings Displaying Styles names in Draft and Outline views Page and number fomatting Section vs page breaks Setting page orientation Setting page margins Displaying page border Automatic corrections Working with Quick Parts Setting autocorrect options Autoformat while typing Creating simple tables Inserting or drawing a table Modifying table formatting Adding rows and columns Changing row heights and column widths

Get to grips with all the features of Teams, including calls and chats, Teams and Channels and Meetings Course overview Duration: 2 hours This session is aimed at those new or self-taught users of Teams to show them the features and how to setup and use it effectively. Objectives  By the end of the course you will be able to: Use the core functions of Microsoft Teams Set up Microsoft Teams Make Calls Send Chats to colleagues via teams Set up channels Run Teams meetings Content What is Teams Teams elements Setting up your Teams Setting up audio and video Using voicemail Setting voicemail language Calls and Chats Sending individual and group chats Making and receiving calls Missed call notification Searching Teams and Channels Creating channels Channel settings Setting channel notifications Emailing channels Creating private channels Posting to channels Alerting specific people in a channel Adding files to channels Sending links to channels Teams Meetings Setting up meetings Running meetings from channels Setting backgrounds Screen sharing in meetings Handing over control Creating meeting notes Adding files to teams or meetings Using the meeting chat

Learn the proper way to use PowerPoint and the background features that can make a real difference. Course overview Duration: 1 day (6.5 hours) Our PowerPoint – Professional Presentations course looks at creating professional, business focussed presentations quickly and easily. It ensures delegates are aware of the key concepts in using the tool such as slide masters and by the end of the day you will be able to create and run high quality presentations. This course is designed for new and existing users of PowerPoint who want to get the best out of the tool. Objectives  By the end of the course you will be able to: Create a new presentation Amend the slide master/template Create text slides Animate text on slides Insert pictures and objects Set object animation Insert and work with SmartArt Create charts Run a presentation Content Creating a new presentation Creating a new presentation from a template Using your company template Changing slide layouts Copying, deleting and inserting slides Using the slide master Modifying the Slide Master Using Slide layouts Multiple Slide Masters Slide dates, footers and numbers Creating text slides Working with bullet points Setting spacing Changing text and bullet styles Using Outline view Text animation on a slide Slide titles Bullet points Applying animation to the Slide Master Animating text Slide titles Bullet points Applying animation to Slide Master Drill Down vs Drill Through Review of drill down Creating drill through pages Using drill through Inserting and working with pictures Inserting pictures Inserting online pictures Formatting pictures Adding Drawings Inserting lines and shapes Using Quick Styles Selecting and grouping objects Aligning and positioning objects Add text to a shape Duplicating objects Object animation Simple object animations Working with SmartArt Inserting SmartArt Graphics SmartArt formatting Converting text to SmartArt Inserting charts Creating a slide with a graph Changing chart types Setting chart options Graph animations Presenting your presentation Slide show settings Using Presenter view Using the PowerPoint viewer Slide show presentation tips

There is so much more to this free tool than just creating PDFs. Learn what else you can do for free. Duration: 2 hours This Adobe Acrobat Reader course looks at the features of the Acrobat Reader tool. Learn how to create PDF and what options you have, complete and sign and mark up PDFs. Objectives  By the end of the course you will be able to: Create PDFs from other tools Complete and sign documents Mark up PDF documents Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Completing and signing documents Using fill and sign to complete forms Adding signatures Marking up documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio

Discover the amazing features this tool has to offer in combining, collating and editing documents and the forms, markups and redaction techniques available. Duration 1 day (6.5 hours) Overview This Adobe Acrobat course looks at the powerful features of the tool quite often overlooked.  The course requires the use of either the Standard or Professional versions of Acrobat as the free Acrobat Reader only has limited functionality. Learn how to combine documents into a single file, edit and mark up PDFs, compare documents, redact data from documents and create fillable forms. Objectives  By the end of the course you will be able to: Create PDFs from other tools Set security Collate and combine files into a single PDF Edit PDF files Complete and sign documents Create fillable forms Mark up PDF documents Compare files Redact data Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Setting PDF options for print, image quality and security Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Collating and Combining Files Combining multiple files into a single PDF Adding extra files Deleting pages and reorganising pages Editing Files Editing text and graphics Adding text and images Adding headers and footers, watermarks and backgrounds Adding Links Adding manual links Automatic links Completing and signing documents Using fill and sign to complete forms Adding signatures Creating Fillable and Signable Forms Prepare a form Autodetect fillable fields Add manual fillable fields Adding drop downs, check boxes, etc. Naming fields Setting field properties Previewing the form Marking Up Documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio Replying to comments Comparing Files Selecting settings Comparison report Reviewing differences Using the changes pane Redacting Data (Acrobat Professional only) Setting redaction options Redacting chosen text Searching and redacting words, phrases or patterns Redacting whole pages Applying redaction

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Process Architects, Business Process Owners/Team Leads/Power Users, Data Consultants/Managers, and Solution Architects. Overview Students will set up and deliver their own master data from SAP ERP to SAP SCM (APO), and make any necessary master data enhancements to ensure proper planning results in APO.Students will complete the modeling of their supply chain by creating APO master data that is necessary to activate a fully functional Supply Chain in APO. In this course, students learn how to set up and configure the standard interface between the SAP ERP system and SAP SCM with focus on SAP APO. Integration for Supply Chain Modeling Integrating SAP ERP and SAP SCM Configuring an Integration Model Using Monitoring and Error-Processing Tools Setting Up Incremental Data Transfers for Master Data Changes Organizing Integration Models Performing Routine Operations with Background Processing Supply Chain Locations Managing Locations Integrating Plant Data Integrating MRP Areas Managing Transportation Zones Integrating Customers as Locations Integrating Vendors as Locations Integrating Factory Calendars and Time Streams Supply Chain Products Integrating Products Maintaining Product Data External Procurements Relationships Integrating Purchasing Information Records Integrating Scheduling Agreements Network Modeling Creating Means of Transportation Creating Transportation Lanes Supply Chain Resources Integrating Production Resources Creating Supply Chain Management (SCM)-Specific Resources Integrating Capacity Variants Integrating Setup Groups and Matrices Manufacturing Process Modeling Preparing Integration of Master Data Mapping Bill of Materials (BOM) Fields Mapping the Routings Fields Integrating Production Master Data Transferring a Master Recipe to a Production Process Model (PPM) Transferring Characteristics and Classes Quota Arrangement Creating Quota Arrangements Supply Chain Modeling Creating an SAP liveCache Model Creating a Version in SAP SCM Using the Supply Chain Engineer (SCE) Transactional Data Integration Integrating Transactional Data Supply Chain Subcontracting Preparing Master Data for Subcontracting

Duration 5 Days 30 CPD hours This course is intended for Technical Administrator Java EE Developer System Administrator Overview Configure WebLogic Server's authentication provider Deploy applications to WebLogic Server Backup and restore a WebLogic Server domain Create a WebLogic Server domain Configure and monitor WebLogic Server Configure WebLogic Server database resources Create and configure a WebLogic Server cluster Install WebLogic Server 12c This Oracle WebLogic Server 12c: Administration I training teaches administrators to install and configure Oracle WebLogic Server 12c. It gives administrators an overview of the basic concepts and architecture of WebLogic Server. This Oracle WebLogic Server 12c: Administration I training teaches administrators to install and configure Oracle WebLogic Server 12c. It gives administrators an overview of the basic concepts and architecture of WebLogic Server.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Process Architects, and Business Process Owners/Team Leads/Power Users. Overview Participants learn how production orders are used, and which main system setting must be made for production order execution. In this course, students learn how production orders are used and which main system setting must be made for production order execution. Introduction to Production Orders Outlining SAP Supply Chain Management Outlining Production Orders Applying Production Orders in Supply Chain Management Order Processing and Order Structure Processing Production Orders Analyzing the Production Order Structure Order Creation Creating Production Orders Without Master Data Creating Production Orders Based on Planned Orders Creating Production Orders Without Planned Orders Defining Order Types Creating Production Orders with Master Data Scheduling Production Orders Costing of Production Orders Order Release Checking Material Availability Checking Capacity Availability Checking Production Resource/Tool Availability Planning Capacities Releasing Production Orders Order Documents Setting Up Order Print Control Printing Production Orders Material Staging Staging Material Withdrawing Material Confirmations Setting Parameters for Confirmations Executing Confirmations Good Receipt Preparing Goods Receipts Posting Goods Receipts Order Settlement, Archiving, & Deletion Settling Production Orders Archiving and Deleting Production Orders Information Systems and Automation Applying Information Systems Automating Production Orders and Mass Processing Applying Collective Orders Applying Trigger Points Extended Functionality and Enhancements Applying Order Split Applying Shift Reports and Shift Notes Applying Work-in-Process (WIP) Batches Applying SAP Execution Steps (XSteps) for Routings and Production Orders Outlining the Production Planning-Plant Data Collection (PP-PDC) Interface Outlining SAP Manufacturing Integration and Intelligence (SAP MII) in Shop Floor Control Applying Handling Units in Production