Microsoft Office

Showing 1–12 of 79 results

  • blue

    Microsoft Office 2013 RT on Windows 8 RT Mobile Devices

    Description

    This course is an introduction to Microsoft® Office 2013 RT on Windows® 8 RT Mobile Devices. Users are introduced to the Windows 8 RT tablet and its touch-screen interface. On the Windows 8 RT tablet, users have the familiar Microsoft Office applications: Word, PowerPoint, Excel, and OneNote. Users explore the common user interface features included in all of the Office 2013 RT applications and how the Office RT apps work with the cloud. For each individual Office 2013 RT application, selected new features are addressed. To take advantage of the tablet’s communication tools, users examine the built-in Mail, Calendar, and People apps. Users will also customize the settings of the Windows 8 RT tablet to suit their personal style.

    Additional Information
    Exam Number

    Course Code

    ELK91-124

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started with the Microsoft Windows 8 RT Tablet*Lesson 2: Getting Started with Microsoft Office 2013 RT*Lesson 3: Working with Microsoft Word 2013 RT*Lesson 4: Working with Microsoft Excel 2013 RT and PowerPoint 2013 RT*Lesson 5: Working with Microsoft OneNote 2013 RT*Lesson 6: Communicating with Windows 8 RT Apps*Appendix A: Windows 8 Navigation Summary

    Learning Objectives

    Navigate the Windows 8 Start screen, launch apps, and use the touch interface.*Use common Office 2013 RT features.*Work with Word 2013 RT.*Work with Excel 2013 RT and PowerPoint 2013 RT.*Create and edit notes in OneNote 2013 RT.*Collaborate and share information between apps.*Configure, secure, and maintain the Windows 8 tablet.

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/04/olELK91-124_rev1.1-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-124

    Course Time: 1.0 Day

    This course is an introduction to Microsoft® Office 2013 RT on Windows® 8 RT Mobile Devices. Users are introduced to the Windows 8 RT tablet and its touch-screen interface. On the Windows 8 RT tablet, users have the familiar Microsoft Office applications: Word, PowerPoint, Excel, and OneNote. Users explore the common user interface features included in all of the Office 2013 RT applications and how the Office RT apps work with the cloud. For each individual Office 2013 RT application, selected new features are addressed. To take advantage of the tablet's communication tools, users examine the built-in Mail, Calendar, and People apps. Users will also customize the settings of the Windows 8 RT tablet to suit their personal style.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office 2013: Transition from Office 2003

    Description

    You’ve used Office 2003 to create various types of business materials from documents in Microsoft® Word to spreadsheets in Excel® to presentations in PowerPoint®. Perhaps you use Outlook® to manage your calendar, contacts, and email or Access® to manage inventory and trouble tickets.*However you use Office, the fact is the Office suite of applications is the de-facto standard for business productivity software. Each new release of Office builds upon the successes of the previous generations.*This course builds upon the foundational Microsoft® Office 2003 knowledge and skills you’ve already acquired. It focuses on the enhanced features you’ll want to leverage to improve the way you manage, organize, present, and distribute your company’s data and information.*You’ll explore a variety of enhancements, from Word’s ability to edit PDF files, to the new Flash Fill functionality in Excel that dramatically increases the speed at which you can add data to a spreadsheet. You’ll discover how the cloud has been deeply integrated into your Office experience and how collaborating with colleagues has never been easier.*The Microsoft® Office 2013: Transition from Office 2003 course will help you bridge the gap from the version you already know and love to the latest release of Microsoft’s flagship productivity suite.

    Additional Information
    Exam Number

    Course Code

    ELK91-123

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started with Microsoft Office 2013*Lesson 2: Working with Microsoft Word 2013*Lesson 3: Working with Microsoft Excel 2013*Lesson 4: Working with Microsoft PowerPoint 2013*Lesson 5: Working with Microsoft Access 2013*Lesson 6: Working with Microsoft Outlook 2013

    Learning Objectives

    Identify new features in Microsoft Office 2013.*Work with Microsoft Word 2013.*Work with Microsoft Excel 2013.*Work with Microsoft PowerPoint 2013.*Work with Microsoft Access 2013.*Work with Microsoft Outlook 2013.

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/04/olELK91-123_rev1.0-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-123

    Course Time: 1.0 Day

    You’ve used Office 2003 to create various types of business materials from documents in Microsoft® Word to spreadsheets in Excel® to presentations in PowerPoint®. Perhaps you use Outlook® to manage your calendar, contacts, and email or Access® to manage inventory and trouble tickets.*However you use Office, the fact is the Office suite of applications is the de-facto standard for business productivity software. Each new release of Office builds upon the successes of the previous generations.*This course builds upon the foundational Microsoft® Office 2003 knowledge and skills you’ve already acquired. It focuses on the enhanced features you’ll want to leverage to improve the way you manage, organize, present, and distribute your company’s data and information.*You’ll explore a variety of enhancements, from Word’s ability to edit PDF files, to the new Flash Fill functionality in Excel that dramatically increases the speed at which you can add data to a spreadsheet. You’ll discover how the cloud has been deeply integrated into your Office experience and how collaborating with colleagues has never been easier.*The Microsoft® Office 2013: Transition from Office 2003 course will help you bridge the gap from the version you already know and love to the latest release of Microsoft’s flagship productivity suite.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office 2013: Transition from Office 2007/2010

    Description

    You’ve used Office 2007 or Office 2010 to create various types of business materials from documents in Microsoft® Word to spreadsheets in Excel® to presentations in PowerPoint®. Perhaps you use Outlook® to manage your calendar, contacts, and email or Access to manage inventory and trouble tickets.*However you use Office, the fact is the Office suite of applications is the de-facto standard for business productivity software. Each new release of Office builds upon the successes of the previous generations.*This course builds upon the foundational Microsoft® Office 2007/2010 knowledge and skills you’ve already acquired. It focuses on the enhanced features you’ll want to leverage to improve the way you manage, organize, present, and distribute your company’s data and information.*You’ll explore a variety of enhancements, from Word’s ability to edit PDF files to the new Flash Fill functionality in Excel that dramatically increases the speed at which you can add data to a spreadsheet. You’ll discover how the cloud has been deeply integrated into your Office experience and how collaborating with colleagues has never been easier.*This Microsoft Office 2013: Transition from Office 2007/2010 course will help you bridge the gap from the version you already know and love to the latest release of Microsoft’s flagship productivity suite.

    Additional Information
    Exam Number

    Course Code

    ELK91-105

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started with Microsoft Office 2013*Lesson 2: Working with Microsoft Word 2013*Lesson 3: Working with Microsoft Excel 2013*Lesson 4: Working with Microsoft PowerPoint 2013*Lesson 5: Working with Microsoft Access 2013*Lesson 6: Working with Microsoft Outlook 2013

    Learning Objectives

    Identify new and enhanced features that are common across all applications in Office 2013.*Modify documents using Microsoft Word 2013.*Enhance worksheet data using Microsoft Excel 2013.*Augment a presentation using Microsoft PowerPoint 2013.*Create a database using Microsoft Access 2013.*Navigate through mail, calendars, contacts, and tasks in Microsoft Outlook 2013.

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/04/olELK91-105_rev1.0-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-105

    Course Time: 1.0 Day

    You’ve used Office 2007 or Office 2010 to create various types of business materials from documents in Microsoft® Word to spreadsheets in Excel® to presentations in PowerPoint®. Perhaps you use Outlook® to manage your calendar, contacts, and email or Access to manage inventory and trouble tickets.*However you use Office, the fact is the Office suite of applications is the de-facto standard for business productivity software. Each new release of Office builds upon the successes of the previous generations.*This course builds upon the foundational Microsoft® Office 2007/2010 knowledge and skills you’ve already acquired. It focuses on the enhanced features you’ll want to leverage to improve the way you manage, organize, present, and distribute your company’s data and information.*You’ll explore a variety of enhancements, from Word’s ability to edit PDF files to the new Flash Fill functionality in Excel that dramatically increases the speed at which you can add data to a spreadsheet. You’ll discover how the cloud has been deeply integrated into your Office experience and how collaborating with colleagues has never been easier.*This Microsoft Office 2013: Transition from Office 2007/2010 course will help you bridge the gap from the version you already know and love to the latest release of Microsoft’s flagship productivity suite.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office 2016: Transition from Office 2007/2010

    Description

    You’ve used Microsoft® Office 2007 or Office 2010 to create various types of business materials, from documents in Word to spreadsheets in Excel® to presentations in PowerPoint®. Perhaps you use Outlook® to manage your calendar, contacts, and email; or Access® to manage inventory and trouble tickets.*However you use Office, the fact is the Office suite of applications is the de-facto standard for business productivity software. Each new release of Office builds upon the successes of the previous generations.*This course builds upon the foundational Microsoft Office 2007/2010 knowledge and skills you’ve already acquired. It focuses on the enhanced features you’ll want to leverage to improve the way you manage, organize, present, and distribute your company’s data and information.*You’ll explore a variety of enhancements, from Word’s ability to edit PDF files to the new Flash Fill functionality in Excel that dramatically increases the speed at which you can add data to a spreadsheet. You’ll discover how the cloud has been deeply integrated into your Office experience and how collaborating with colleagues has never been easier.*This Microsoft® Office 2016: Transition from Office 2007/2010 course will help you bridge the gap from the version you already know and love, to the latest release of Microsoft’s flagship productivity suite.

    Additional Information
    Exam Number

    Course Code

    ELK91-039

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started with Microsoft Office 2016*Lesson 2: Working with Microsoft Word 2016*Lesson 3: Working with Microsoft Excel 2016*Lesson 4: Working with Microsoft PowerPoint 2016*Lesson 5: Working with Microsoft Access 2016*Lesson 6: Working with Microsoft Outlook 2016

    Learning Objectives

    Identify new and enhanced features that are common across all applications in Office 2016.*Modify documents using Microsoft Word 2016.*Enhance worksheet data using Microsoft Excel 2016.*Augment a presentation using Microsoft PowerPoint 2016.*Create a database using Microsoft Access 2016.*Utilize mail, calendars, contacts, and tasks in Microsoft Outlook 2016.

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/05/olELK91-039_r1.1-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-039

    Course Time: 1.0 Day

    You've used Microsoft® Office 2007 or Office 2010 to create various types of business materials, from documents in Word to spreadsheets in Excel® to presentations in PowerPoint®. Perhaps you use Outlook® to manage your calendar, contacts, and email; or Access® to manage inventory and trouble tickets.*However you use Office, the fact is the Office suite of applications is the de-facto standard for business productivity software. Each new release of Office builds upon the successes of the previous generations.*This course builds upon the foundational Microsoft Office 2007/2010 knowledge and skills you’ve already acquired. It focuses on the enhanced features you’ll want to leverage to improve the way you manage, organize, present, and distribute your company’s data and information.*You’ll explore a variety of enhancements, from Word’s ability to edit PDF files to the new Flash Fill functionality in Excel that dramatically increases the speed at which you can add data to a spreadsheet. You’ll discover how the cloud has been deeply integrated into your Office experience and how collaborating with colleagues has never been easier.*This Microsoft® Office 2016: Transition from Office 2007/2010 course will help you bridge the gap from the version you already know and love, to the latest release of Microsoft’s flagship productivity suite.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office 365: Web Apps (with Skype for Business)

    Description

    This course is an introduction to the Microsoft® Office 365™ (with Skype® for Business) in a cloud-based environment. It can be used as an orientation to the full suite of Office 365 cloud-based tools, or the Skype for Business lessons can be presented separately in a seminar-length presentation with the remaining material available for later student reference.*Using Office 365, users can easily communicate with each other through Microsoft® Outlook® mail and Skype for Business instant messaging and online meetings. Additionally, the Microsoft® SharePoint® Team Site provides a central location for accessing and modifying shared documents. The Office Web Apps enable users to perform basic tasks, such as opening, editing, printing, and saving documents without requiring an installation of the full desktop version of Microsoft® Office 2013 or Office 2016 on a local computer.

    Additional Information
    Exam Number

    Course Code

    ELK91-029

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started*Lesson 2: Collaborating with Shared Files*Lesson 3: Using the Outlook Web Apps*Lesson 4: Communicating with Skype for Business*Lesson 5: Using Skype for Business Meetings*Lesson 6: Interacting with Mobile Devices

    Learning Objectives

    Sign in to and navigate in the Office 365 environment.*Create, edit, and share documents with team members using Office Web Apps and Microsoft SharePoint.*Use email and manage contacts with the Outlook Web Apps.*Use instant messaging and online meetings with Skype for Business.*Set up your mobile devices to work with Office 365.

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/05/olELK91-029_rev2.0-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-029

    Course Time: 1.0 Day

    This course is an introduction to the Microsoft® Office 365™ (with Skype® for Business) in a cloud-based environment. It can be used as an orientation to the full suite of Office 365 cloud-based tools, or the Skype for Business lessons can be presented separately in a seminar-length presentation with the remaining material available for later student reference.*Using Office 365, users can easily communicate with each other through Microsoft® Outlook® mail and Skype for Business instant messaging and online meetings. Additionally, the Microsoft® SharePoint® Team Site provides a central location for accessing and modifying shared documents. The Office Web Apps enable users to perform basic tasks, such as opening, editing, printing, and saving documents without requiring an installation of the full desktop version of Microsoft® Office 2013 or Office 2016 on a local computer.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office 365: Web Apps and Collaboration for Office 2013

    Description

    This course is an introduction to the Microsoft® Office 365™ for Office 2013 in a cloud-based environment. Using Office 365, users can easily communicate with each other through Microsoft® Outlook® mail and Skype for Business instant messaging and online meetings. Additionally, the Microsoft® SharePoint® Team Site provides a central location for accessing and modifying shared documents. The Office Web Apps enable users to perform basic tasks, such as opening, editing, printing, and saving documents without requiring an installation of the full desktop version of Microsoft® Office 2013 on the local computer.

    Additional Information
    Exam Number

    Course Code

    ELK91-100

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started*Lesson 2: Collaborating with Shared Files*Lesson 3: Using the Outlook Web Apps*Lesson 4: Communicating with Skype for Business*Lesson 5: Interacting with Mobile Devices

    Learning Objectives

    Sign in to and navigate in the Office 365 environment.*Create, edit, and share documents with team members using Office Web Apps and Microsoft SharePoint.*Use email and manage contacts with the Outlook Web Apps.*Use instant messaging and online meetings with Skype for Business.*Set up your mobile devices to work with Office 365.

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/05/olELK91-116_r2.2n-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-100

    Course Time: 1.0 Day

    This course is an introduction to the Microsoft® Office 365™ for Office 2013 in a cloud-based environment. Using Office 365, users can easily communicate with each other through Microsoft® Outlook® mail and Skype for Business instant messaging and online meetings. Additionally, the Microsoft® SharePoint® Team Site provides a central location for accessing and modifying shared documents. The Office Web Apps enable users to perform basic tasks, such as opening, editing, printing, and saving documents without requiring an installation of the full desktop version of Microsoft® Office 2013 on the local computer.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office 365™: Microsoft Office Web Apps and Collaboration

    Description

    This course is an introduction to the Microsoft® Office 365™: Microsoft Office Web Apps and Collaboration in a cloud-based environment. Using Office 365, users can easily communicate with each other through Microsoft® Outlook® mail and Lync® instant messaging and online meetings. Additionally, the Microsoft® SharePoint® Team Site provides a central location for accessing and modifying shared documents. The Office Web Apps enable users to perform basic tasks, such as opening, editing, printing, and saving documents without requiring an installation of the full desktop version of Microsoft® Office 2010 on the local computer.

    Additional Information
    Exam Number

    Course Code

    ELK91-100

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started*Lesson 2: Collaborating with Shared Files*Lesson 3: Using the Outlook Web App*Lesson 4: Communicating with Microsoft Lync*Lesson 5: Interacting with Mobile Devices

    Learning Objectives

    Log in to and navigate in the Office 365 environment*Create, edit, and share documents with team members using Office Web Apps and Microsoft SharePoint*Use email and manage contacts with the Outlook Web App*Use instant messaging and online meetings with Microsoft Lync*Set up your mobile devices to work with Office 365

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/05/olELK91-100_r2.1n-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-100

    Course Time: 1.0 Day

    This course is an introduction to the Microsoft® Office 365™: Microsoft Office Web Apps and Collaboration in a cloud-based environment. Using Office 365, users can easily communicate with each other through Microsoft® Outlook® mail and Lync® instant messaging and online meetings. Additionally, the Microsoft® SharePoint® Team Site provides a central location for accessing and modifying shared documents. The Office Web Apps enable users to perform basic tasks, such as opening, editing, printing, and saving documents without requiring an installation of the full desktop version of Microsoft® Office 2010 on the local computer.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office Access 2010: Part 1

    Description

    Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ball park, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.*Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility such as time reporting or recording a sale. But virtually everyone is affected in some way by the need to manage data.*A relational database application such as Microsoft® Office Access® 2010 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access 2010 to manage your data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.*You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2010.

    Additional Information
    Exam Number

    77-885

    Course Code

    ELK91-001

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started with Access*Lesson 2: Working with Table Data*Lesson 3: Querying a Database*Lesson 4: Creating Advanced Queries*Lesson 5: Generating Reports*Lesson 6: Customizing the Access Environment*Appendix A: Microsoft Office Access 2010 Exam 77-885*Appendix B: Microsoft Access 2010 Common Keyboard Shortcuts

    Learning Objectives

    Navigate within the Microsoft Access application environment and create a simple database.*Organize and manage data stored within Access tables.*Use queries to join, sort, and filter data from different tables.*Create advanced queries, including action queries, parameter queries, PivotTables, and PivotCharts.*Create and format custom reports.*Customize Access configuration options.

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/05/olELK91-001_rev2.2-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    77-885ELK91-001

    Course Time: 1.0 Day

    Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ball park, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.*Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility such as time reporting or recording a sale. But virtually everyone is affected in some way by the need to manage data.*A relational database application such as Microsoft® Office Access® 2010 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access 2010 to manage your data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.*You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2010.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office Access 2010: Part 2

    Description

    Your training and experience using Microsoft® Access® 2010 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2010 will result in a robust, functional database for your users.*You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft® Access® 2010.

    Additional Information
    Exam Number

    77-885

    Course Code

    ELK91-002

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Designing a Relational Database*Lesson 2: Joining Tables*Lesson 3: Organizing a Database for Efficiency*Lesson 4: Sharing Data Across Applications*Lesson 5: Advanced Reporting*Appendix A: Additional Reporting Options*Appendix B: Microsoft Office Access 2010 Exam 77-885*Appendix C: Microsoft Access 2010 Common Keyboard Shortcuts

    Learning Objectives

    Design a relational database.*Join tables to retrieve data from unrelated tables.*Organize a database for efficiency, performance, and to maintain data integrity.*Share data between Access and other applications.*Customize reports to organize the displayed information and produce specific print layouts.

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/05/olELK91-002_rev2.2-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    77-885ELK91-002

    Course Time: 1.0 Day

    Your training and experience using Microsoft® Access® 2010 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2010 will result in a robust, functional database for your users.*You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft® Access® 2010.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office Access 2013: Part 1

    Description

    Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.*Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility such as time reporting or recording a sale. But virtually everyone is affected in some way by the need to manage data.*A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access 2013 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.*You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2013.

    Additional Information
    Exam Number

    77-424

    Course Code

    ELK91-004

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started with Access*Lesson 2: Working with Table Data*Lesson 3: Querying a Database*Lesson 4: Creating Advanced Queries*Lesson 5: Generating Reports*Lesson 6: Customizing the Access Environment*Topic A: The Access Options Dialog Box*Appendix A: Microsoft Office Access 2013 Exam 77-424*Appendix B: Microsoft Access 2013 Common Keyboard Shortcuts

    Learning Objectives

    Navigate within the Microsoft Access application environment and create a simple database.*Organize and manage data stored within Access tables.*Use queries to join, sort, and filter data from different tables.*Create advanced queries, including action queries and parameter queries.*Create and format custom reports.*Customize Access configuration options.

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/04/olELK91-004_rev2.2-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    77-424ELK91-004

    Course Time: 1.0 Day

    Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.*Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility such as time reporting or recording a sale. But virtually everyone is affected in some way by the need to manage data.*A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access 2013 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.*You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2013.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office Access 2013: Part 2

    Description

    Your training and experience using Microsoft® Access® 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.*You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.

    Additional Information
    Exam Number

    77-424

    Course Code

    ELK91-005

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Designing a Relational Database*Lesson 2: Joining Tables*Lesson 3: Organizing a Database for Efficiency*Lesson 4: Sharing Data Across Applications*Lesson 5: Advanced Reporting*Appendix A: Additional Reporting Options*Appendix B: Microsoft Office Access 2013 Exam 77-424*Appendix C: Microsoft Access 2013 Common Keyboard Shortcuts

    Learning Objectives

    Design a relational database.*Join tables to retrieve data from unrelated tables.*Organize a database for efficiency and performance, and to maintain data integrity.*Share data among Access and other applications.*Customize reports to organize the displayed information and produce specific print layouts.

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/04/olELK91-005_rev2.2-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    77-424ELK91-005

    Course Time: 1.0 Day

    Your training and experience using Microsoft® Access® 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.*You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office Access 2013: Part 3

    Description

    You’ve covered many of the basic functions of Microsoft® Office Access® and now you’re ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today’s training, added to that which you’ve gained from the previous two days, rounds out your Access education and provides you with marketable job skills.*You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.

     

    Additional Information
    Exam Number

    77-424

    Course Code

    ELK91-006

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Implementing Advanced Form Design*Lesson 2: Using Data Validation*Lesson 3: Using Macros to Improve User Interface Design*Lesson 4: Using Advanced Database Management*Lesson 5: Distributing and Securing a Database*Lesson 6: Managing Switchboards*Appendix A: Microsoft Office Access 2013 Exam 77-424*Appendix B: Microsoft Access 2013 Common Keyboard Shortcuts

    Learning Objectives

    Customize a form layout to improve usability and efficiency of data entry.*Add user interface features to validate data entry.*Use macros to improve user interface design.*Organize data into appropriate tables to ensure data dependency and minimize redundancy.*Lock down and prepare a database for distribution to multiple users.*Create and modify a database switchboard and set the startup options.

    Download Course

    http://masterskill.co.za/edu_content/uploads/2017/04/olELK91-006_rev2.2-pdf.pdf

    Suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    77-424ELK91-006

    Course Time: 1.0 Day

    You've covered many of the basic functions of Microsoft® Office Access® and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today's training, added to that which you've gained from the previous two days, rounds out your Access education and provides you with marketable job skills.*You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.  

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

1 2 3 4 5 6 7