Watch the video and explore the code as you learn to create a nested IIf function call when you design a query using the new Access 2010 Expression Builder. Author: Ken Getz (MVP)
Read more from the original source:
Using the New Expression Builder to Build If-Then Statements in Access 2010 Applications (Visual How To)
In a previously post I wrote about how we can retrieve data from a SQL Server Compact Edition (SSCE) database with ADO and Excel.
Here is the original post:
Create SQL Server Compact Edition Database with VBA
LightSwitch has a really nice feature on data grids that allow you to export them to Excel if running out of browser (full trust). This gives you a basic way of getting data out of the system to create reports or do further analysis on the data using Excel. However, in business applications you typically want to provide some client-side reporting that also formats the data in a certain way so it can be printed easily.
More:
Using Microsoft Word to Create Reports For LightSwitch (or Silverlight)
Explore the code in this visual how-to article as you learn to use Open XML file formats to retrieve information about hidden rows and columns in an Excel worksheet. Author: Ken Getz (MVP)
Here is the original:
Sample: Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0
Explore the code as you learn how to create a BCS for Office 2010 based on a Windows Communication Foundation (WCF) service.
See the rest here:
Sample: Connecting to a WCF Service Using Business Connectivity Services in Office 2010
Explore the code in this visual how-to article as you learn to deploy an Office solution that uses ClickOnce deployment.
See more here:
Sample: Deploying Multiple Office 2010 Projects in One Package
In Visual Studio 2010, you can use the ClickOnce and Windows Installer deployment technologies to deploy Office solutions that target both Microsoft Office 2007 and Microsoft Office 2010.
View original here:
Deploying Microsoft Office Solutions by Using Visual Studio 2010 and Windows Installer (Mary Lee, Saurabh Bhatia)
This is the twenty-sixth in a series of blog posts I’m doing on the VS 2010 and .NET 4 release.
Read more:
Debugging Tips with Visual Studio 2010
Explore the code in this visual how-to article as you learn to build solutions that target both .NET Framework 3.5 and .NET Framework 4.
Read more from the original source:
Sample: Deploying an Office 2007 .NET 3.5 project and an Office 2010 NET 4.0 Project
To continue the theme of landing external data in Office 2010, I’ve taken a demo excerpt from a session I presented at a conference last week to show how easy it is to land OData information in an add-in. In this sample I simply use the Northwind Database which is a publicly available OData producer .
Original post:
Accessing an OData Producer using an Office 2010 Add-in