Add popular commands to your Office 2010 ribbons

The Office team has compiled customers’ favorite commands across all Office 2010 applications, which you can download to add as a Favorites tab in Access, Excel, InfoPath, OneNote, Outlook, PowerPoint, Project, Publisher, Visio, and Word. For example, the Favorites tab in Word puts Save, Send, Properties, Spelling & Grammar, Quick Print, Word Options and other…


Close Office application misfires while they load

Have you ever mistakenly launched the wrong Office application? I know I have – sometimes my mouse slips and I click the wrong icon locked on my Windows 7 taskbar, or I’m rushing and mix up the Outlook and PowerPoint icons. The good news is that, if this happens, Office 2010 users don’t have to…


Create a custom view of your data in Access on SharePoint

Awhile back, we shared how to publish your Access database to SharePoint. Once you and your team are working in it, you may find things a bit overwhelming. There may be different fields for different teams, and – unlike with Excel – you can’t lock the first column to keep your bearings. No worries, there’s…


Save time with overtype mode in Office

Depending on your editing style, you may prefer overtype mode – which lets you type over characters instead of always inserting new ones. This may be particularly helpful when working in a document that serves as a template, such as a Microsoft Word form or a frequently re-used Excel workbook. When Overtype Mode is available,…


Save time saving Office 2010 documents to SharePoint

If you frequently save documents to a team SharePoint site, you may be able to add a shortcut to your Office 2010 desktop applications. To see if this feature is enabled, go to your SharePoint document library and click the Library tab: Now click the Connect to Office button and select Add to SharePoint Sites:…


Publish your Access database to SharePoint

If you have an Access database sitting on your hard drive that you want to share with a larger team, one of the quickest and most flexible options is to publish it to a SharePoint site using Access Services. If you don’t already have a database, you can quickly create one from a template. In…


Office 2010 migration guides now available

Still getting the hang of Office 2010? The Office team has prepared a set of helpful migration guides that call out new features and important changes to help you dive right in and maximize your productivity. Each offers a visual introduction to the Ribbon, a “Things you might be looking for” section, customization tips, and…


Using validation rules in Access for better data integrity

Over the past few days, we’ve talked about how important it is that the data in your database be entered in a consistent manner. We’ve looked at how to use forms to limit the control others have over your data. We’ve talked about setting up field types so that people don’t enter text where the…