Microsoft Access

Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. In mid-May 2010, the current version of Microsoft Access 2010 was released by Microsoft in Office 2010; Microsoft Office Access 2007 was the prior version. Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases. Software developers and data architects can use Microsoft Access to develop application software, and "power users" can use it to build simple applications. Like other Office 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's first attempt to sell a relational database product was during the mid 1980s, when Microsoft obtained license to sell R:Base. In the late 1980s Microsoft developed its own solution codenamed Omega^]. It was confirmed in 1988 that a database product for Windows and OS/2 was in development. The project was going to supplement Microsoft's lineup of Windows applications. It was going to include "EB" Embedded Basic language, which was going to be the language for writing macros in all Microsoft's application, but the unification of macro languages did not happen until the introduction of VBA. Omega was also expected to provide a front end to the Microsoft SQL Server. The application was very resource demanding and there were reports that it was working slow on then-available 386 processors. It was scheduled to be released in the 1st quarter of 1990, but in 1989 the development of the product was reset and it was rescheduled to be delivered no sooner than in January 1991. Parts of the project were later used for other Microsoft projects: Cirrus (codename for Access) and Thunder (codename for Visual Basic, where the Embedded Basic engine was used). After Access's premiere, the Omega project was demonstrated in 1992 to several journalists and included features, that were not available in Access.

PowerPoint

Microsoft PowerPoint, usually just called PowerPoint, is a closed source commercial presentation program developed by Microsoft. It is part of the Microsoft Office suite, and runs on Microsoft Windows and Apple's Mac OS X operating system. The current versions are Microsoft PowerPoint 2010 for Windows and 2011 for Mac.

PowerPoint presentations consist of a number of individual pages or "slides". The "slide" analogy is a reference to the slide projector, a device that can be seen as obsolete, within the context of widespread use of PowerPoint and other presentation software. Slides may contain text, graphics, movies, and other objects, which may be arranged freely. PowerPoint, however, facilitates the use of a consistent style in a presentation using a template or "Slide Master".

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 webcasts.

PowerPoint provides three types of movements:

1. Entrance, emphasis, and exit of elements on a slide itself are controlled by what PowerPoint calls Custom Animations
2. Transitions, on the other hand are movements between slides. These can be animated in a variety of ways
3. Custom animation can be used to create small story boards by animating pictures to enter, exit or move

Microsoft Word

Microsoft Word is a non-free commercial word processor designed by Microsoft. It was first released in 1983 under the name Multi-Tool Word for Xenix systems. Subsequent versions were later written for several other platforms including IBM PCs running DOS (1983), the Apple Macintosh (1984), the AT&T Unix PC (1985), Atari ST (1986), SCO UNIX, OS/2, and Microsoft Windows (1989). It is a component of the Microsoft Office system; it is also sold as a standalone product and included in Microsoft Works Suite. The current versions are Microsoft Word 2010 for Windows and 2011 for Mac.

Microsoft announced Multi-Tool Word for Xenix and MS-DOS in 1983. Its name was soon simplified to Microsoft Word. Free demonstration copies of the application were bundled with the November 1983 issue of PC World, making it the first program to be distributed on-disk with a magazine. Unlike most MS-DOS programs at the time, Microsoft Word was designed to be used with a mouse, and it was able to display some formatting, such as bold, italic, and underlined text, although it could not render fonts. It was not initially popular, since its user interface was different from the leading word processor at the time, Word Perfect. However, Microsoft steadily improved the product, releasing versions 2.0 through 5.0 over the next six years.

In 1985, Microsoft ported Word to the Macintosh. This was made easier by the fact that Word for DOS has been designed for use with high-resolution displays and laser printers, even though none were yet available to the general public. Following the precedents of LisaWrite and MacWrite, Word for Mac added true WYSIWYG features. After its release, Word for Mac's sales were higher than its MS-DOS counterpart for at least four years.

The second release of Word for Macintosh, shipped in 1987, was named Word 3.0 to synchronize its version number with Word for DOS; this was Microsoft's first attempt to synchronize version numbers across platforms. Word 3.0 included numerous internal enhancements and new features, including the first implementation of the Rich Text Format (RTF) specification, but was plagued with bugs. Within a few months Word 3.0 was superseded by a more stable Word 3.01, which was mailed free to all registered users of 3.0. After Mac Write, Word for Mac never had any serious rivals on the Mac. Word 5.1 for the Macintosh, released in 1992, was a very popular word processor owing to its elegance, relative ease of use and feature set. Many users say its the best version of Word for Mac ever created.

In 1986, an agreement between Atari and Microsoft brought Word to the Atari ST under the name Microsoft Write. The Atari ST version was a port of Word 1.05 for the Apple Macintosh^[ and was never updated.

The first version of Word for Windows was released in 1989. With the release of Windows 3.0 the following year, sales began to pick up and Microsoft soon became the market leader for word processors for IBM PC-compatible computers. In 1991, Microsoft capitalized on Word for Windows' increasing popularity by releasing a version of Word for DOS, version 5.5, that replaced its unique user interface with an interface similar to a Windows application. When Microsoft became aware of the Year 2000 problem, it made Microsoft Word 5.5 for DOS available for download free. As of November 2010, it is still available for download from Microsoft's web site.

In 1991, Microsoft embarked on a project code-named Pyramid to completely rewrite Microsoft Word from the ground up. Both the Windows and Mac versions would start from the same code base. It was abandoned when it was determined that it would take the development team too long to rewrite and then catch up with all the new capabilities that could have been added in the same time without a rewrite. Instead, the next versions of Word for Windows and Mac, dubbed version 6.0, both started from the code base of Word for Windows 2.0.

With the release of Word 6.0 in 1993, Microsoft again attempted to synchronize the version numbers and coordinate product naming across platforms, this time across DOS, Macintosh, and Windows (this was the last version of Word for DOS). It introduced AutoCorrect, which automatically fixed certain typing errors, and AutoFormat, which could reformat many parts of a document at once. While the Windows version received favorable reviews (e.g.), the Macintosh version was widely derided. Many accused it of being slow, clumsy and memory intensive, and its user interface differed significantly from Word 5.1. In response to user requests, Microsoft was forced to offer Word 5 again, after it had been discontinued. Subsequent versions of Word for Macintosh are no longer ported versions of Word for Windows.

Microsoft Excel

Is a commercial spreadsheet application written and distributed 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. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993. Excel forms part of Microsoft Office. The current versions are 2010 for Windows and 2011 for Mac.

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columnsto 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 from different perspectives (using pivot tables and the scenario manager). And 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. Finally, it 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 Power Point slide show, and e-mail these presentations on a regular basis to a list of participants.

Microsoft allows for a number of optional command-line switches to control the manner in which Excel starts.

Is a proprietary commercial office suite of inter-related desktop applications, servers and services for the Microsoft Windows and Mac OS X operating systems, introduced by Microsoft in 1989. Initially a marketing term for a bundled set of applications, the first version of Office contained Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, OLE data integration and Microsoft Visual Basic for Applications scripting language. Microsoft also positions Office as a development platform for line-of-business software under the Office Business Applications brand. According to Forrester Research, as of June 2009, some version of Microsoft Office is used in 80% of enterprises, with 64% of enterprises using Office 2007.

The current versions are Office 2010 for Windows, released on June 15, 2010; and Office 2011 for Mac OS X, released October 26, 2010.