Microsoft Office is a set of interrelated desktop applications, servers and services, collectively referred to as an office suite, for the Microsoft Windows and Mac OS X operating systems.
|Microsoft Access||Microsoft Outlook||Microsoft SharePoint Designer|
|Microsoft Excel||Microsoft PowerPoint||Microsoft SharePoint Foundation|
|Microsoft InfoPath||Microsoft Project||Microsoft Visio|
|Microsoft Lync||Microsoft Publisher||Microsoft Word|
Microsoft Access is a set of interrelated desktop applications, servers and services, collectively referred to as an office suite, for the Microsoft Windows and Mac OS X operating systems.
applications, Access is supported by Visual Basic for Applications, an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating-system functions.
Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager). It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the results back to the spreadsheet. It also has a variety of interactive features allowing user interfaces that can completely hide the spreadsheet from the user, so the spreadsheet presents itself as a so-called application, or decision support system (DSS), via a custom-designed user interface, for example, a stock analyzer, or in general, as a design tool that asks the user questions and provides answers and reports. In a more elaborate realization, an Excel application can automatically poll external databases and measuring instruments using an update schedule, analyze the results, make a Word report or PowerPoint slide show, and e-mail these presentations on a regular basis to a list of participants.
Microsoft Exchange uses a proprietary RPC protocol called MAPI/RPC, which was designed to be used by Microsoft Outlook. E-mail hosted on an Exchange Server can also be accessed using SMTP, POP3 and IMAP4 protocols, using clients such as Windows Live Mail, Mozilla Thunderbird, and Lotus Notes. These protocols must be enabled on the server. Exchange Server mailboxes can also be accessed through a web browser, using Outlook Web App (OWA).
Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. Microsoft initially released InfoPath as part of Microsoft Office 2003 family. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio Button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields.
Microsoft Lync or Skype for Business (formerly Microsoft Office Communicator and Microsoft Lync) and Microsoft Lync for Mac are instant messaging clients used with Skype for Business Server or Lync Online available with Microsoft Office 365. They are replacements for Windows Messenger, which was used with Microsoft Exchange Server.
Both Microsoft Lync and Microsoft Lync for Mac are enterprise software; compared to Windows Live Messenger and later Skype, they have a different feature set that is targeted toward corporate environments.
Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite.
Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note taking, journal, and web browsing.
It can be used as a stand-alone application, or can work with Microsoft Exchange Server and Microsoft SharePoint Server for multiple users in an organization, such as shared mailboxes and calendars, Exchange public folders, SharePoint lists, and meeting schedules. Microsoft has also released mobile applications for most mobile platforms, including iOS and Android. Developers can also create their own custom software that works with Outlook and Office components using Microsoft Visual Studio. In addition, mobile devices can synchronize almost all Outlook data to Outlook Mobile.
Microsoft OneNote is a computer program for free-form information gathering and multi-user collaboration. It gathers users' notes (handwritten or typed), drawings, screen clippings and audio commentaries. Notes can be shared with other OneNote users over the Internet or a network. OneNote is available as a part of Microsoft Office and Windows 10. It is also available as a free standalone application for Windows, OS X, Windows RT, Windows Phone, iOS and Android. A web-based version of OneNote is provided as part of OneDrive or Office Online and enables users to edit notes via a web browser.
Microsoft PowerPoint is the name of a proprietary commercial presentation program developed by Microsoft. It was officially launched on May 22, 1990 as a part of the Microsoft Office suite, and runs on Microsoft Windows and Apple's Mac OS X operating system.
PowerPoint presentations consist of a number of individual pages or "slides". The "slide" analogy is a reference to the slide projector. A better analogy would be the "foils" (or transparencies/plastic sheets) that are shown with an overhead projector, although they are in decline now. Slides may contain text, graphics, sound, movies, and other objects, which may be arranged freely. The presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. For larger audiences the computer display is often projected using a video projector. Slides can also form the basis of web-casts.
PowerPoint provides numerous features that offer flexibility and the ability to create a professional presentation. One of the features provides the ability to create a presentation that includes music which plays throughout the entire presentation or sound effects for particular slides. In addition to the ability to add sound files, the presentation can be designed to run, like a movie, on its own. PowerPoint allows the user to record the slide show with narration and a laser pointer. You may customize slide shows to show the slides in different order than originally design and to have slides appear multiple times. Microsoft also offers the ability to broadcast the presentation to specific users via a link and Windows Live.
Microsoft Project is a project management software program, developed and sold by Microsoft, that is designed to assist a project manager in developing a plan, assigning resources to tasks, tracking progress, managing the budget, and analyzing workloads.
Microsoft Project was the company's third Microsoft Windows-based application, and within a couple of years of its introduction it became the dominant PC-based project management software.
While part of the Microsoft Office family, it has never been included in any of the Office suites. It is available currently in two editions, Standard and Professional. Microsoft Project's proprietary file format is .mpp.
Microsoft Project and Microsoft Project Server are the cornerstones of the Microsoft Office enterprise project management (EPM) product.
Microsoft Publisher is an entry-level desktop publishing application from Microsoft, differing from Microsoft Word in that the emphasis is placed on page layout and design rather than text composition and proofing.
Publisher is included in higher-end editions of Microsoft Office, reflecting Microsoft's emphasis on the application as an easy-to-use and less expensive alternative to the "heavyweights" with a focus on the small business market where firms do not have dedicated design professionals available to make marketing materials and other documents.
Microsoft Visio (formerly Microsoft Office Visio) is a diagramming and vector graphics application and is part of the Microsoft Office suite.
Microsoft made Visio 2013 for Windows available in two editions: Standard and Professional. The Standard and Professional editions share the same interface, but the Premium edition has additional templates for more advanced diagrams and layouts, as well as capabilities intended to make it easy for users to connect their diagrams to data sources and to display their data graphically. The Premium edition features three additional diagram types, as well as intelligent rules, validation, and sub-process (diagram breakdown).
On 22 September 2015, alongside Microsoft Office 2016 Visio 2016 was released. A few new features have been added such as one-step connectivity with Excel data, information rights management (IRM) protection for Visio files, modernized shapes for office layout, detailed shapes for site plans, updated shapes for floor plans, modern shapes for home plans, IEEE compliant shapes for electrical diagrams, new range of starter diagrams, and new themes for the Visio interface.
Database modeling in Visio revolves around a Database Model Diagram (DMD).
Microsoft Word a full-featured word processing program for Windows and Mac OS X from Microsoft. Available stand-alone or as part of the Microsoft Office suite, Word contains rudimentary desktop publishing capabilities and is the most widely used word processing program on the market. Word files are commonly used as the format for sending text documents via e-mail because almost every user with a computer can read a Word document by using the Word application, a Word viewer or a word processor that imports the Word format.
Word 2010 allows more customization of the Ribbon, adds a Back-stage view for file management, has improved document navigation, allows creation and embedding of screenshots, and integrates with Word Web App.