Browse by Tags

Related Posts
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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,...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...