Monday, November 8, 2010

Microsoft Office 2010 - Removed features

The following features are removed from Microsoft Office 2010.

Removed from the entire suite
Microsoft Office Document Imaging application
Microsoft Office Document Scanning application
Office Diagnostics tool
Support for MSXML version 5
Research and Reference pane for Internet Explorer
Features removed from Microsoft Word
Smart Tag auto-recognition
Person Name smart tag
AutoSummary feature
Support for Word Add-in Libraries (WLL)
Features removed from Microsoft Access
Access Calendar ActiveX control
Replication Conflict Viewer
Data access pages
Features removed from Microsoft Outlook
ANSI offline Outlook data files (.ost) for Exchange synchronization
Calendar rebasing tool
DAV connectivity for HTTP account types
Exchange 2000 connectivity
Exchange Message Security feature support
Postmarks
Features removed from Microsoft PowerPoint
Macro recorder
Save as Web Page feature
Features removed from Microsoft Publisher
The ability to create new Web Publications

Microsoft Office 2010 - New features and Improvements

Office 2010 is more "role-based" than previous versions. There are features tailored to employees in "roles such as research and development professionals, sales persons, and human resources." In its Internet implementation, Office 2010 incorporates features of SharePoint Server and borrows from "Web 2.0" ideas.

Microsoft Office 2010 includes updated support for ISO/IEC 29500:2008, the International Standard version of Office Open XML (OOXML) file format. Office 2010 provides read support for ECMA-376, read/write support for ISO/IEC 29500 Transitional, and read support for ISO/IEC 29500 Strict. In its pre-release (beta) form, however, Office 2010 only supported the Transitional variant, and not the Strict. The intent of the ISO/IEC is to allow the removal of the Transitional variant from the ISO/IEC compliant version of the OOXML standard. Microsoft Office 2010 supports OpenDocument Format (ODF) 1.1, which is an OASIS standard.

New features also include a built-in screen capture tool, a background removal tool, a protected document mode, new SmartArt templates and author permissions. The 2007 "Office Button" was replaced with a menu button that leads to a full-window file menu, known as Backstage View, giving easy access to task-centered functions such as printing and sharing. A notable accessibility regression from 2007 is that the menu button scores worse with the Fitts's law accessibility calculation than previous versions. A modified Ribbon interface is present in all Office applications, including Office Outlook, Visio, OneNote, Project, and Publisher. Office applications also have functional jumplists in Windows 7, which would allow easy access to recent items and tasks relevant to the application. Features of Office 2010 include:

Ribbon interface and Backstage View across all applications
Background Removal Tool
Letter Styling
The Word 2007 Equation editor is common to all applications, replacing Microsoft Equation Editor 3.0
New SmartArt templates
New text and image editing effects
Screen Capturing and Clipping tools
Live collaboration functions
Jumplists in Windows 7
New animations in PowerPoint 2010
A new feature in Microsoft Office 2010 is Outlook Social Connector, which allows users connect to and receive updates from their social network inside Microsoft Outlook.

When users view their emails a name, picture, and title is available for the person they are contacting. Upcoming appointments can also be viewed with this new feature and users can request friends. Outlook Social Connector currently supports Facebook, LinkedIn, MySpace and Windows Live Messenger.

Microsoft Office 2010 Introduction

Microsoft Office 2010 (also called Office 2010 and Office 14) is a productivity suite for Microsoft Windows, and the successor to Microsoft Office 2007. Office 2010 includes extended file format support, user interface updates, and a changed user experience. With the introduction of Office 2010, a 64-bit version of Office is available, although not for Windows XP or Windows Server 2003. Office 2010 does not support Windows XP Professional x64 Edition.

On April 15, 2010, Office 2010 was released to manufacturing, with those Volume Licensing customers who have Software Assurance being able to download the software from April 27, 2010. The suite became available for retail as well as online purchase on June 15, 2010.

Office 2010 marks the debut of free online versions of Word, Excel, PowerPoint, and OneNote, which work in popular web browsers (Internet Explorer, Mozilla Firefox, Google Chrome and Safari, but not Opera). A new edition of Office, Office Starter 2010, replaced the low-end home productivity software, Microsoft Works.

Microsoft's update to its mobile productivity suite, Office Mobile 2010, will also be released for Windows Phones running Windows Mobile 6.5 and Windows Phone 7. In Office 2010, every application features the Ribbon, including Outlook, OneNote, Publisher, InfoPath, SharePoint Workspace (previously known as Groove), and the new Office Web Apps.

Procedures and Access Levels

Like a variable access, the access to a procedure can be controlled by an access level. A procedure can be made private or public. To specify the access level of a procedure, precede it with the Private or the Public keyword. Here is an example:-

Private Sub CreateCustomer()
Dim strFullName As String
strFullName = "Chidambaram Palaniappan"
End Sub

The rules that were applied to global variables are the same:

Private: If a procedure is made private, it can be called by other procedures of the same module. Procedures of outside modules cannot access such a procedure.

Also, when a procedure is private, its name does not appear in the Macros dialog box.

Public: A procedure created as public can be called by procedures of the same module and by procedures of other modules.

Also, if a procedure was created as public, when you access the Macros dialog box, its name appears and you can run it from there itself.

Calling a Sub Procedure

Once you have a procedure, whether you created it or it is part of the Visual Basic language, you can use it. Using a procedure is also referred to as calling it.

Before calling a procedure, you should first locate the section of code in which you want to use it. To call a simple procedure, type its name. Here is an example:

Sub CreateCustomer()
Dim strFullName As String
strFullName = "Chidambaram Palaniappan"
End Sub

Sub Exercise()
CreateCustomer
End Sub

Besides using the name of a procedure to call it, you can also precede it with the Call keyword. Here is an example:

Sub CreateCustomer()
Dim strFullName As String
strFullName = "Chidambaram Palaniappan"
End Sub

Sub Exercise()
Call CreateCustomer
End Sub

When calling a procedure, without or without the Call keyword, you can optionally type an opening and a closing parentheses on the right side of its name. Here is an example:

Sub CreateCustomer()
Dim strFullName As String
strFullName = "Chidambaram Palaniappan"
End Sub

Sub Exercise()
CreateCustomer()
End Sub

Introduction to Sub-Procedures

A sub procedure is an assignment that is carried but does not give back a result. To create a sub procedure, start with the Sub keyword followed by a name (like everything else, a procedure must have a name). The name of a procedure is always followed by parentheses. At the end of the sub procedure, you must type End Sub. Therefore, the primary formula to create a sub procedure is:

Sub ProcedureName()

End Sub

The name of a procedure should follow the same rules we learned to name the variables. In addition:

If the procedure performs an action that can be represented with a verb, you can use that verb to name it. Here are examples: show, display To make the name of a procedure stand, you should start it in uppercase. Examples are Show, Play, Dispose, Close. You should use explicit names that identify the purpose of the procedure. If a procedure would be used as a result of another procedure or a control's event, reflect it on the name of the sub procedure. Examples would be: afterupdate, longbefore.
If the name of a procedure is a combination of words, you should start each word in uppercase. An example is AfterUpdate
The section between the Sub and the End Sub lines is referred to as the body of the procedure. Here is an example:

Sub CreateCustomer()

End Sub

In the body of the procedure, you carry the assignment of the procedure. It is also said that you define the procedure or you implement the procedure.

One of the actions you can in the body of a procedure consists of declaring a variable. There is no restriction on the type of variable you can declare in a procedure. Here is an example:

Sub CreateCustomer()
Dim strFullName As String
End Sub

In the same way, you can declare as many variables as you need inside of a procedure. The actions you perform inside of a procedure depend on what you are trying to accomplish. For example, a procedure can simply be used to create a string. The above procedure can be changed as follows:

Sub CreateCustomer()
Dim strFullName As String
strFullName = "Chidambaram palaniappan"
End Sub

Introduction to Procedures

A procedure is a section of code created to carry an assignment, separate from a spreadsheet, whose action can be used to complement a spreasheet. You create the procedure by writing code. One of the advantages of a procedure is that, once it exists, you can access it when necessary and as many times as you want.

There are two categories of procedures you will use in your spreadsheets: those that are already installed with Microsoft Excel and those you will create.

In the Visual Basic language, like most other languages, there are two types of procedures: functions and sub procedures.