See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
The Productivity Hub
Office for Mac 2011
Browse by Tags
The Productivity Hub
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 Access 2010...
8 Nov 2010
Excelling at Excel - Use Filters to home in on the data you need
If you have a lot of data in an Excel worksheet, you should generally activate filters to make it more manageable to use. To do so, simply select any cell in the worksheet that contains data, click over to the Data tab, and click the Filter button. Your top row (usually a header row) will now have some...
23 Mar 2010
New Year's resolutions you can resolve with Office and Windows
It's 2011, and if you're like me, you know there are some things you should have mastered last year that you didn't get to - so you resolve to tackle them when the calendar rolls over. Here are 65 popular tasks we frequently hear that customers want to learn - and which Productivity Hub can help you...
4 Jan 2011
Where should I put my data, Excel or Access?
When you have a lot of data and it needs to be organized, do you use Excel or Access? I get this question a lot when talking to people and I wish I could give you a short answer. Well, I guess I can: It depends. I understand why people are confused. In Access, you can specify the types of information...
15 Jan 2010
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...
20 Jun 2011
Setting up your Access database for success
I recently shared some guidance on when to use Microsoft Access vs. Excel for storing your data . Regardless of which tool you use, the quality of your data is critically important. So it’s vital that everyone who enters data does it in the same way. If they don’t, you won’t be able to do any meaningful...
26 Jan 2010
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...
13 Sep 2010
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 wait...
5 May 2011
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,...
21 Feb 2011
Ensuring the right data goes into Access
A Microsoft Access database is a great place to store and organize information since it gives you an unlimited number of ways to look at that data later. But what you can do with that data is limited by the quality of your data entry. This can be a challenge, especially if you’re going to have a lot...
27 Jan 2010
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...
4 Feb 2011
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...
15 Nov 2010
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 date is...
28 Jan 2010
© 2014 Microsoft Corporation.
Privacy & Cookies