This is a very frequently discussed issue. But before I get into the methods, you need to understand one of the principles of relational databases. That principle is that data should exist in one place only. Having the same data in multiple tables is a violation of normalization. Related records are indicated by a Foreign Key within the record that .. more »

In VBA, a common way to refer to the pages of a tab control is to use the Value property. However, Luke Chung, President of FMS Inc., recommends using the PageIndex property instead. Click here to find out why! Send your Power Tips to Mike and Chris at accpower@microsoft.com... more »

the range A1:D4 is entered as A1|D4 The Excel Services REST API provides a means to change values in the workbook. These changes only affect the values, HTML rendering info or charts returned by the REST API for that particular request. These changes are NOT saved back to the workbook, nor do they affect other REST API or Excel Web Access browser .. more »

Thanks to Christian Stich for putting together this series on the REST API. Beginning our journey on all things Excel Services 2010, I thought Id start off with a feature thats been getting a lot of buzz lately since its introduction at the SharePoint Conference. API is a new programmability framework that allows for easy discovery of and access to .. more »

Albert D. Kallal (Access MVP) has published a great video demo of an application that he build for tracking meetings rooms. He even has built a fancy calendar control that renders in the web using data macros and bound controls. it is a good example of the types of things you can do in the browser with Access + Access Services. Here is my .. more »

Johanna and I were invited to do an interview for the MSNZ podcast at the SharePoint Conference. It just got posted, hope you enjoy it :).. more »

Before delving into Excel Services 2010, I want to recap a point that some readers may not be aware of. The Excel team is delivering two browser-based solutions as part of the Office 2010 wave of products. The quick synopsis - here are the two solutions: Version two of our real-time, interactive, Excel-based reporting and dashboard capabilities .. more »

Whats the next best thing to getting someone to critique your PowerPoint presentation for design and effectiveness for free? Well, watching someone else get that advice may come in as a fairly close second. This video will re-introduce you to Julie Terberg of A Picture + 1000 Words where we spotlighted the amazing and beautiful sample shape and .. more »

In Excel 2007, the ability to directly resize or reposition points on the chart was deprecated. This feature was sometimes referred to as "Graphical Goal Seek." For example, in Excel 2003 a user could click on a data point in a column chart twice which would surface handles that could be used to resize the columns. Over the last couple of years we .. more »

This week, the Outlook product team hosted a .pst file format interoperability event here on the Microsoft campus in Redmond. As we announced on the , our team plans to release a specification of the .pst file format to the public. This weeks interoperability event is part of a series of steps that we are taking to gather feedback from industry .. more »

Check out this great video - Access 2010 and Outlook style calendar running in a browser by Albert D. Kallal, Access MVP. Application was developed in Access and running in web browser using SharePoint Access services. Well done, Albert! .. more »

When you run relink procedure at application startup, and backend file is located on the network – the process can be much slower then relinking local file, even with very fast network. The trick is to open backend file before relink process and close it after. Sample code: Dim dbData  As DAO.Database Set dbData = DBE.. more »

John Durant from the Office Developer marketing team is blogging about why VBA still makes sense. I expect the Access community is interested in what he has to say. Here is a little taste of the article: Not infrequently I am asked, “So, should I use VBA? Is it going to be around in Office 2010? Is it supported? Should I migrate away from VBA no.. more »

This article continues the series on to PowerPivot for Excel 2010. Well now focus on the support PowerPivot provides for collaboration. Frequently, business users need to share applications they create on their desktops with a workgroup. As it turns out, SharePoint provides a great platform that is critical for realizing the overarching goal of .. more »

Microsoft Office Outlook 2007 delivered the first version of our Unified Messaging (UM) experience from the Microsoft Exchange and Outlook teams. UM enables you to receive voice mails and FAXs in your Outlook Inbox. You can listen to voice mail messages while in Outlook or on your phone. In Outlook 2010, weve added some cool new features to Unified .. more »

Today's guest blogger is Michael Merlin, Lead Software Developer at I recently wasted an hour trying to set a field's Back Color property to the hex code generated by the color picker. I figured it out after some searching, but still nobody online had the exact correct answer. I wrote a function that lets you easily use the hex color in code. The .. more »

Over the last couple of months, we've posted about many of the exciting new features of Word 2010 . This week, at SharePoint Conference 2009, we announced one more (and one that I'm especially excited about): framing the Word 2010 release , one of the pillars described is "Word Power in New Contexts". Word Automation Services is a big part of that .. more »

Now it is official - Access Services for Sharepoint 2010. Ryan McMinn and Clint Covington opens curtain. .. more »

In this blog article, well step through using PowerPivot for Excel 2010 for building a rich application in Excel. , Gemini will be released under the PowerPivot brand. After installation, Gemini appears on the Excel 2010 ribbon: Selecting the Load & Prepare Data button launches the PowerPivot client window: As you would expect from any modern tool, .. more »

More info and a fun video here: http://powerpivot.com/.. more »