Office 2010 SP1 Released

The 370mb download includes the addition of integrated community content in the Access 2010 Application Part Gallery.

Ways to share an Access database

A good article from Office.com on how to deploy run-time and web-based Access applications.

Access 2010 Code Sample: Find the First and Last Day in a Given Week, Month, or Year

From the Microsoft Download Center Visual How-to Sample: How to Find the First and Last Day in a Given Week, Month, or Year in Access 2010

Streamline Reporting on Recurring Data Imports

The article from Microsoft walks you through the creation of an Access database that supports importing monthly sales data from a text file, and provides the sample data used to create the article, as well as the database file complete with all the data imported.

The scenario comprises the following tasks:

1. Set up an import specification to allow Access to import the same data in future months.
2. Use the built-in Table Analyzer tool to create a normalized structure for the data.
3. Create a set of append queries that will parse the incoming data into the normalized structure.
4. Write a macro that automates the data import process.

All Access Downloads/Add-Ins for Access 97 to Access 2010

Microsoft has finally re-organised all its Access downloads in one place. Just click on a column  to sort.

Access 2010: Sample Access Database for Streamline Reporting

This Microsoft download provides a sample data set to show how to automate a recurring import of data into a Microsoft Access 2010 database.

How To Build an Access 2010 Web Database

A detailed article from MS on building a web database in Access 2010.

New Access 2010 Resource Center on TechNet

TechNet has launched a new Access 2010 Resources portal with a focus on migrating, deploying and securing Access 2010 databases. Learn how to plan and implement an Access Services site, and get links to developer resources, training, videos, and how-to articles.

Free eBooks from Microsoft Press

• Free ebook: Moving to Microsoft Visual Studio 2010 (10 chapters by by Patrice Pelland, Pascal Paré, and Ken Haines)
• Free ebook: Introducing Microsoft SQL Server 2008 R2 (10 chapters by Ross Mistry and Stacia Misner)
• Free ebook: Programming Windows Phone 7 Series (DRAFT Preview) (6 chapters by Charles Petzold)
• Free ebook: Petzold’s Programming Windows Phone 7 (Special Excerpt 2) (newer than the ebook above; 11 chapters by Charles Petzold)
• Free ebook: Own Your Future: Update Your Skills with Resources and Career Ideas from Microsoft(8 chapters by Katherine Murray)
• Free ebook: Understanding Microsoft Virtualization Solutions (Second Edition) (6 chapters by Mitch Tulloch)
• Free ebook: First Look Microsoft Office 2010 (14 chapters by Katherine Murray)
• Free ebook: Windows 7 troubleshooting tips (short ebook by Mitch Tulloch)
• Free ebook: Introducing Windows Server 2008 R2 (9 chapters by Charlie Russel and Craig Zacker)
• Free ebook: Deploying Windows 7, Essential Guidance (10 chapters from the Windows 7 Resource Kit and 6 TechNet articles)

Latest Access 2010 and Office 2010 Resources and Guides

• Office 2010 Product Guides
• Office 2010 Developer References
• Office 2010 Add-In: Icons Gallery
• Office 2010 Help Files: Office Fluent User Interface Control Identifiers
• Office 2010 Product Guides
• Access 2010 Runtime
• Access 2010 Database Engine Redistributable

Access 2010: Download the Interactive Menu to Ribbon Guide

A visual, interactive reference guide to help you find the new location of commands in Access 2010. Download

Access 2010 Migration Guide

The Access 2010 Migration Guide walks you through new features such as the ribbon interface, the Navigation Pane, where to find Access Options, and so on. The other Office 2010 Migration Guides are also available from the above link. Essential for those upgrading from pre-Access 2007 versions.

Important Access Updates

Latest KB Articles courtesy of KB Alertz:


Access 2002

• 201279   Upsizing Wizard in Access 2002, Access 2003 or Access 2007 database results in message when attempting to upsize to SQL Server 2008

Access 2007

• 2276481   Description of the Office Access 2007 hotfix package (ace-x-none.msp, access-x-none.msp): August 31, 2010 
• 2396342   Office 2007 Cumulative Update for August 2010 

Operations guide for Microsoft Office 2010

This eBook provides information about how to maintain and manage an installation of Microsoft Office 2010.

Visual Studio LightSwitch BETA: The New MS Access Robot?

Check out this short video: Introduction to Visual Studio LightSwitch then read more here.  Access databases will be supported post-BETA!  The blurb:

"With LightSwitch, you can build custom applications that rival off-the-shelf solutions. Get a head start by using pre-configured screen templates that give your application a familiar look and feel. LightSwitch also provides prewritten code and other reusable components to handle routine application tasks, along with helpful step-by-step guidance. However, if you need to write custom code, you can use Visual Basic .NET or C#. You can deploy to the desktop, browser, or cloud (post-Beta) to share your application with others more easily without the cumbersome installation processes... Applications created with LightSwitch support exporting data to Microsoft Office Excel for fast and easy sharing and reporting. You can also attach your application to existing data sources, which makes it easy to collect, analyze, and reuse information from a variety of data sources including Microsoft SQL Server, Microsoft SQL Azure, SharePoint, Microsoft Office Access (post-Beta), and other third-party data sources."

Thanks to Alex Dybenko of Alex & Access for the heads-up.

New MSDN Articles on VBA In Office 2010

• Getting Started with VBA in Office 2010
• Working with VBA in Office 2010 (32-bit) and Office 2010 (64-bit)

Download the Office 2010 Developer Training Kit

Download the Office 2010 Developer Training Kit - "provides developers with collateral to get started quickly developing for Office 2010". 95.5mb

New Office Ribbon Developer Center Launches on MSDN

A new Office Fluent UI Developer Center has been launched on MSDN, where you can dind developer resources for customizing the Backstage view for Office 2010 and the Ribbon UI for Office 2010 and Office 2007.

Northwind 2010 Web Database is now available

A new version of the Northwind sample database has just been released. The best way to get to the template is to start up Access 2010, under Office.com Templates, click on Sample Templates, and then click on Northwind Web Database. You can also get the template here: Northwind Web Database. 

New Access 2010 Resources PDFs

Download:

• Microsoft Access 2010 Features and Benefits
• Microsoft Access 2010 Getting Started Guide
• Microsoft Access 2010 Product Guide
• Microsoft Access 2010 Reference Access 2003 to Access 2010