archive-za.com » ZA » 2 » 2KO.CO.ZA

Total: 380

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Microsoft Access 2010 Training Course Cape Town
    SUBJECT TO A MINIMUM OF 3 DELEGATES ATTENDING THE COURSE Course Accreditation MS Access Advanced Unit Standard 258881 This course is currently accredited by MICT SETA and is Unit Standard is intended for people who need to plan produce and use small scale databases using a GUI based database application People credited with this unit standard are able to Demonstrating an understanding of relational database theory Analysing unstructured data not populated to a relational database model Creating queries using specific functions Creating different types of queries Creating parameter queries and adding calculated fields Creating basic select queries using simple SQL syntax Overview In this course students will design complex Access databases by structuring existing data writing advanced queries working with macros and performing database maintenance Duration 1 Day Pre requisites Read write communicate and comprehend at least at GET level Competent in mathematical fundamentals at least at NQF level 2 Use a Graphical User Interface GUI based database application to work with simple databases Use a Graphical User Interface GUI based database application to solve a given problem Mastering Access to create and modify an Access database At Course Completion Upon successful completion of this course students will be able to Restructure data into appropriate tables to ensure data dependency and minimize redundancy Write advanced queries to analyze and summarize data Create and revise Microsoft Office Access 2013 macros Customize reports by using various Microsoft Office Access 2013 features Maintain their databases using Microsoft Office Access 2013 tools Module Outline Module 1 Structuring Existing Data Restructure the Data in a Table Create a Junction Table Improve the Table Structure Module 2 Writing Advanced Queries Create SubQueries Create Unmatched and Duplicate Queries Group and Summarize Records Using Criteria Summarize Data Using a Crosstab Query Create a PivotTable and a PivotChart Module

    Original URL path: http://2ko.co.za/courses/microsoft/officeMSAccess2010.html (2015-12-05)
    Open archived version from archive

  • Microsoft Word 2010 training course Cape Town
    is intended for people who need to enhance document appearance using a GUI based word processor either as a user of computers or as basic knowledge for a career needing this competency like the ICT industry People credited with this unit standard are able to Inserting and deleting sections within a document while maintaining document integrity Inserting editing and deleting headers and footers within a document Facilitating online review of documents using comments and tracking changes Creating and using Styles in a document Creating editing and or deleting references in a document Creating editing and using electronic links in a document Overview In this course students will create manage revise and distribute long documents Duration 1 Day Pre requisites Students should be able to use Microsoft Office Word 2010 to create edit format save and print business documents that contain text tables and graphics Students should also be able to use a web browser and an email program A basic understanding of XML would also be helpful In order to understand how Word interacts with other applications in the Microsoft Office System students should have a basic understanding of how worksheets and presentations work Word 2010 basic skills Outline Module 1 Using Microsoft Office Word 2010 with other Programs Link a Word Document to Data in an Excel Worksheet Send a Document Outline to Microsoft Office PowerPoint Send a Document as an Email Message Module 2 Collaborating on Documents Modify User Information Save and Share a Document for Review Review a Document Compare Document Changes Merge Document Changes Review Track Changes and Comments Co author a Document Module 3 Managing Document Versions Create a New Version of a Document Compare Document Versions Merge Document Versions Module 4 Adding Reference Marks and Notes Insert Bookmarks Insert Footnotes and Endnotes Add Hyperlinks

    Original URL path: http://2ko.co.za/courses/microsoft/officeMSWord2010.html (2015-12-05)
    Open archived version from archive

  • Microsoft Excel 2010 Advanced Training Cape Town Course
    and offers online IT courses 24x7 via elearning enabling 2KO students the opportunity to study courses online world wide to ensure the best training possible PLEASE NOTE THAT ALL MICROSOFT OFFICE COURSES ARE SUBJECT TO A MINIMUM OF 3 DELEGATES ATTENDING THE COURSE Course Accreditation MS Excel Advanced Unit Standard 258876 This course is currently accredited by MICT SETA and is intended for people who need to have to work with spreadsheets in a variety of circumstances People credited with this unit standard are able to Importing and exporting text files Consolidating and linking data within spreadsheets Applying filters and use forms in a spreadsheet Creating and using macros Combining and comparing large sets of data in a spreadsheet Overview In this course students will automate sme common Excel tasks apply advanced analysis techniques to more complex data sets collaborate on worksheets with others and share Excel data with other applications Duration 1 Day Pre requisites Excel 2013 basic skills At Course Completion Upon successful completion of this course students will be able to Enhance productivity and efficiency by streamlining your workflow Collaborate with others using workbooks Audit worksheets Analyze data Work with multiple workbooks Import and export data Use Excel with the web Structure workbooks with XML Module Outline Module 1 Streamlining Workflow Create a Macro Edit a Macro Apply Conditional Formatting Add Data Validation Criteria Update a Workbook s Properties Module 2 Collaborating with Others Protect Files Share a Workbook Set Revision Tracking Review Tracked Revisions Merge Workbooks Administer Digital Signatures Restrict Document Access Module 3 Auditing Worksheets Trace Cells Troubleshoot Errors in Formulas Troubleshoot Invalid Data and Formulas Watch and Evaluate Formulas Create a Data List Outline Module 4 Analyzing Data Create a Trendline Create Scenarios Perform What If Analysis Perform Statistical Analysis with the Analysis ToolPak

    Original URL path: http://2ko.co.za/courses/microsoft/officeMSExcel2010.html (2015-12-05)
    Open archived version from archive

  • Microsoft PowerPoint 2010 training course Cape Town
    and or modify feature rich presentations for specific audience needs People credited with this unit standard are able to Creating and using templates in a GUI based presentation application Manipulating graphics images and drawn objects Using charts graphs to enhance presentations Using sound and video to enhance presentations Customising and controlling a slideshow Overview In this PowerPoint course students will enhance their presentation by using features that will transform it into a powerful means of communication They will customize the PowerPoint interface to suit the requirements and use features to create presentations Duration 1 Day Pre requisites PowerPoint 2013 basic skills At Course Completion Upon successful completion of this course students will be able to Customize the PowerPoint environment Customize a design template Add SmartArt graphics to a presentation Add special effects to a presentation Customize a slide show Collaborate on a presentation Secure and distribute a presentation Outline Module 1 Customizing the PowerPoint Environment Customize the PowerPoint Interface Set Options for Working with PowerPoint Module 2 Customizing a Design Template Set Up a Slide Master Create Custom Slide Layouts Add Headers and Footers Modify the Notes Master Modify the Handout Master Module 3 Adding Diagrams to a Presentation Insert

    Original URL path: http://2ko.co.za/courses/microsoft/officeMSPowerPoint2010.html (2015-12-05)
    Open archived version from archive

  • MCSE Server Infrastructure 2012 Training Cape Town South Africa
    Town We recommend that if you plan to pass exams whilst in Cape Town you allow an extra 2 weeks You can do the official exams at a centre in your hometown or at our centre which is authorised to deliver these exams Validate your skills in desktop virtualization remote desktop services and application virtualization Show that you can deploy and manage desktops and devices that provide access from anywhere while maintaining security and compliance Content The Microsoft Certified Solutions Expert MCSE Server Infrastructure certification validates that you have the skills needed to run a highly efficient and modern data center with expertise in identity management systems management virtualization storage and networking Course Modules Installing and Configuring Windows Server 2012 70 410 Administering Windows Server 2012 70 411 Configuring Advanced Windows Server 2012 Services 70 412 Designing and Implementing a Server Infrastructure 70 413 Implementing an Advanced Server Infrastructure 70 414 How to enrol Before enrolling you should have the following information ready Date you wish to attend the course Payment method how you will be paying You can book by email simply send us an email with your name the date and how you would like to pay We

    Original URL path: http://2ko.co.za/courses/microsoft/MCSE_ServerInfrastructure2012.html (2015-12-05)
    Open archived version from archive

  • MCSE Desktop Infrastructure 2012 Cape Town Training Course South Africa
    the best training possible About this course Microsoft s premier networking certification Three exams required Course can be done in four weeks only in Cape Town We recommend that if you plan to pass exams whilst in Cape Town you allow an extra 2 weeks You can do the official exams at a centre in your hometown or at our centre which is authorised to deliver these exams Validate your

    Original URL path: http://2ko.co.za/courses/microsoft/MCSE_DesktopInfrastructure2012.html (2015-12-05)
    Open archived version from archive

  • Private Cloud Certification 2012 Course Cape Town Training Courses South Africa
    enabling 2KO students the opportunity to study courses online world wide to ensure the best training possible Prove your expertise in managing and implementing Microsoft private cloud computing technologies With Windows Server and System Center you will build your Microsoft private cloud solution to optimize IT service delivery and gain the automation and flexibility you need for your IT infrastructure now and in the future Private Cloud Certification Course outline

    Original URL path: http://2ko.co.za/courses/microsoft/MCSE_PrivateCloudCertification2012.html (2015-12-05)
    Open archived version from archive

  • Oracle Courses Cape Town Training South Africa Certification OCA
    these course are also available online 2KO presents computer training on the African continent and offers online IT courses 24x7 via elearning enabling 2KO students the opportunity to study courses online world wide to ensure the best training possible Oracle Oracle Database 11g Administration course Oracle 11g SQL Fundamentals Oracle PL SQL Development Oracle PL SQL Programming Oracle PL SQL Development Oracle Database SQL Expert IT COURSES Special Offers Adobe

    Original URL path: http://2ko.co.za/courses/oracle/coursesoracle.html (2015-12-05)
    Open archived version from archive



  •