Microsoft Office 2010 - The Best New Features in Access

If you have never used a relational database because you felt it was just too complicated, give a look at Access. Access 2010 has simplified database functions and added ready-to-go templates to get you started. Information stored in spreadsheets and documents can be easier to understand and less time consuming to manage in a relational database model. Not only can you save time, but you can make your data more meaningful and perform more meaningful analysis. And if you are using a product that uses Access to store your data, you will be able to better understand the tables, reports and relationships.

Fast, easy database creation
Ready-to-go Templates - Use the available templates to create a marketing list or sales pipeline without being a database expert. The templates are designed to give you the structure you need to get started and let you expand as you become more familiar with using Access.
Use modular components - These prebuild components allow you to build the most common tasks into your database. Go to Create - Application Parts after making your selection, the wizard will guide you through the setup and make your choices obvious. There are on-demand help videos that explain how to use Access. The videos are surprisingly easy to follow with clear language and demos that take you through the screens step-by-step.
Forms and reports with realistic, targeted analysis
Conditional formatting - Use data bars to manage your rules and create professional reports that are understandable and informative. Rather than trying to "crowbar" your data into available formats, you can customize the presentation and make your data mean more to organization. Stay focused at your sales and marketing meetings by using reports that everyone will recognize and appreciate.
Office themes - Choose themes with fonts, colors and designs that match your other Microsoft Office products that demonstrate consistency and branding.
Backstage - The Microsoft Office Backstage view replaces the traditional file menu with an ergonomic approach that uses In and Out features for efficiency. The improved Ribbon lets you access your favorite commands quickly and create custom tabs to personalize the way you work.
Developer quality without writing code
Expression Builder - Enhanced functionality with IntelliSense to greatly simplify formula and expression building. With these intuitive tools you will spend less time troubleshooting relationship errors and more time building a valuable database.
Macro Designer - Add basic logic to your database, quickly and easily even if you are not familiar with databases. If you're an experienced Access user, you'll find the enhancements allow you to use the complex logic move efficiently than ever. Extend your database application with increased performance and confidence.
Work from anywhere
Online - Post your database online and then access, view, and edit them from the Web. Users without an Access client can open Web forms and reports via a browser and their changes are automatically synchronized.
For organizations of all types and sizes, Access 2010 allows you to be more productive, flexible and cost-effective. You can combine tasks in Access that previously required several programs and labor intensive analysis to make better decisions for your business.
For more technical notes and information go to: www.lansystems.com/technotes.html

Ms. Hester is the CEO of LAN Systems which provides IT solutions in the Greater Metro Atlanta Area. LAN Systems is dedicated to providing business technology that works for people. In 2004, Mary founded Intelligent System Solutions, Inc. (ISS) which provides high-tech consulting, sales and service to utility customers. Mary brings extensive experience managing a support and service group renowned for its "Best in the Industry" rating and standards. She is an expert in customer loyalty and retention. She has designed and delivered numerous training courses and workshops on a variety of topics.
http://www.lansystems.com

Article Source: http://EzineArticles.com/?expert=Mary_Hester

Use AutoCorrect in Microsoft Word

AutoCorrect will:

· Correct common typing errors such as "teh" instead of "the"
· Capitalise the first letter of days of the week. So "Monday" is converted to "Monday"
· Capitalise the first letter of sentences
· Correct incorrect use of the Caps Lock key such as "sHOULD"
· Correct two initial capitals such as "SHould"
These options can be customised to fit you.
To open the AutoCorrect Options:
In Word 2003
Click Tools > AutoCorrect Options
In Word 2007
Click the Office Button > Word Options > Proofing > AutoCorrect Options
Check or uncheck the required options and click Ok
Add an AutoCorrect Entry
You can add an entry to the AutoCorrect dictionary. This is a fantastic feature to use to improve your productivity. It can greatly speed up data input and also help reduce spelling mistakes.
After adding an entry or changing the AutoCorrect options in Word, they are updated across all Microsoft Office applications improving your productivity when using Excel or Outlook also.
Let's say I want to add Microsoft Office training to the dictionary so that whenever I enter mso into a Word document or Excel spreadsheet it automatically replaces the text with Microsoft Office training.
1. Open the AutoCorrect Options as mentioned previously depending on the version of Microsoft Word you are using
2. Enter mso in the Replace: box
3. Enter Microsoft Office training in the With: box
4. Click Ok
5. Click Ok again
Now whenever you enter mso into an Office application the text is automatically replaced with Microsoft Office training.
Preventing Automatic Replacement of Text
When Word replaces the text, a blue line appears below the first letter of the first word entered. If you point the mouse to this blue line a smart tag will appear providing AutoCorrect Options.
This tag allows you to stop Word automatically changing mso. This is useful when you need to enter the text mso. It may be somebody's initials, an acronym, or the name of a project or company.
Click the AutoCorrect Options smart tag and select either Change back to "mso" or Stop Automatically Correcting "mso".

This is useful but not particularly efficient. A good trick of the trade when using AutoCorrect is to precede the word to be replaced with a symbol. For example, instead of mso we could have used /mso or ?mso.
By using a set prefix for all your custom AutoCorrect entries, it will prevent the possibility of using the word mso in the future and AutoCorrect incorrectly replacing the word with Microsoft Office training.
Removing an AutoCorrect Entry
To remove an entry:

1. Open AutoCorrect Options
2. Enter the first few letters of the word in the Replace: box and select the word in the list
3. Click Delete

Visit Microsoft Office training at Computergaga.com to further increase your software skillset.

Article Source: http://EzineArticles.com/?expert=Al_Murray

New Features of Microsoft Office 2010

According to an article published in InfoWorld in April 2006, Office 2010 will be more "role-based" than previous versions. The article cites Simon Witts, corporate vice president for Microsoft's Enterprise and Partner Group, as claiming that there would be features tailored to employees in "roles such as research and development professionals, sales persons, and human resources." Borrowing from ideas termed "Web 2.0" when implemented on the Internet, it is likely that Microsoft will incorporate features of SharePoint Server in Office 2010.

Microsoft indicated that Microsoft Office 2010 will include updated support for ISO/IEC 29500:2008, the International Standard version of Office Open XML (OOXML) file format. In its pre-release (beta) form, however, Office 2010 does not support the Strict variant of the format, but its Transitional variant. 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.[30] Microsoft Office 2010 will also support OpenDocument Format (ODF) 1.1, which is an OASIS standard.

New features are also said to 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" will be 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 no longer follows Fitt's law. A modified Ribbon interface will be present in all Office applications, including Office Outlook, Visio, OneNote, Project, and Publisher. Office applications will also have functional jumplists in Windows 7, which would allow easy access to recent items and tasks relevant to the application. Confirmed features of Office 2010 include:

Ribbon interface and Backstage View across all applications

Background Removal Tool

Letter Styling

The Word 2007 Equation editor will become common to all applications, replacing MS Equation 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 the Social Connector. This allows users to write emails while keeping track of their family, friends, and colleagues by viewing status updates and past communication history with the individual. When users view their emails a name, picture, and title will be available for the person they are contacting. Upcoming appointments can also be viewed with this new feature and users can request friends. The Social Connector does not work with Office x64 bit versions and Microsoft suggests to use the 32 bit products on their official forums and support. Sync features for Windows Mobile phones like email, contacts and other integration will also not work with x64 versions of Office 2010. There is no information if the final releases coming up in a few days will patch this feature as to date a lot of features and integrations are missing from the x64 version of Office 2010. (source : wikipedia.org)

Download Microsoft Office 2010 Beta

Download Free Microsoft Office Beta or Microsoft Office 2010 Trial

n

Microsoft Office 2010, codenamed Office 14, is a productivity suite for Microsoft Windows, and the successor to Microsoft Office 2007 for Microsoft Windows. Office 2010 includes extended file compatibility, user interface updates, and a refined user experience. It will be available for Windows XP SP3 (32-bit), Windows Vista SP1, and Windows 7. With the introduction of Office 2010, a 64-bit version of Office is available for the first time, although only for Windows Vista SP1, Windows Server 2008 SP1, Windows 7 and Windows Server 2008 R2. Neither the 32-bit edition of Office 2010 nor the 64-bit edition is supported on Windows XP Professional x64 Edition.

On April 15, 2010, Microsoft announced that Office 2010 had been released to manufacturing, with those Volume Licensing customers who have Software Assurance being able to download the software from April 27. It will be available in June in retail stores in the US.

Office 2010 marks the debut of free online versions of Word, Excel, PowerPoint, and OneNote, which will work in popular web browsers (Internet Explorer, Mozilla Firefox, Google Chrome, and Apple Safari). A new edition of Office, Office Starter 2010, will replace the current 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 has the Ribbon, including OneNote 2010, Publisher 2010, InfoPath 2010, SharePoint Workspace 2010 (the new name for Microsoft Office Groove 2007) and the new Office Web Apps. (source : wikipedia.org)

Download Microsoft Office 2010 Beta or Microsoft Office 2010 Trial Click Here