Sunday, October 24, 2010

Free eBooks from Microsoft Press

Tuesday, October 12, 2010

Latest Access 2010 and Office 2010 Resources and Guides







Tuesday, September 28, 2010

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

Tuesday, September 07, 2010

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.

Friday, September 03, 2010

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 

Thursday, September 02, 2010

Operations guide for Microsoft Office 2010

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

Wednesday, September 01, 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.

Thursday, August 19, 2010

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

Monday, August 02, 2010

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.

Monday, July 19, 2010

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

Thursday, July 15, 2010

New Access 2010 Resources PDFs

  • 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

Wednesday, July 14, 2010

Free Corporate Event Manager for Access 2007 and Access 2010

I have just uploaded a cool new Access application that streamlines the process of managing corporate events. No other free database application offers the degree of functionality offered by the The Event Manager application. Download ( 210kb Zipped ACCDE file for Access 2007/2010).


Friday, July 02, 2010

Office 2010 Office Environment Assessment Tool

An environment scanning tools to assist in the assessment phase of deployment. It identifies the following:

  • Currently installed applications and installation environment.
  • Add-ins currently in use by Office clients.
  • Programs that are not registered as add-ins but still interact with Office programs.
  • Report: Environmental assessment (potential upgrade issues).
  • Report: Add-ins assessment—list of third party programs and information about the compatibility of those programs with Microsoft Office 2010.

Wednesday, June 30, 2010

Office 2010 Compatibility Inspector

The Microsoft Office 2010 Compatibility Inspector compares existing (legacy) code against the Office 2010 object model by using a text search for known properties and methods that have changed. You can run the tool against specific projects. You also have the option to mark those areas in the code where text search has identified a possible object model match. The comment will include description of what was found along with possible remediation link to online content or help.

The tool integrates with both Microsoft Visual Basic for Applications 7.0 (VBA 7) and Microsoft Visual Studio 2008. It includes a basic scanner where definitions and remediation links are updated from a central online location. It also generates a summary report and a details report. The summary includes the total lines of code scanned as well as total lines identified as potential candidates for object model changes. The details report includes the module name, line number, and links to remediation for each identified issue along with color-coded flags for impact guidance.

Sunday, June 13, 2010

Latest Access KB Alerts

Courtesy of KbAlertz.com:

Access 2002
977896   MS10-003: Description of the security update for Office XP: February 9, 2010
978214   MS10-003: Vulnerability in Microsoft Office (MSO) could allow remote code execution


Access 2003
977645   Description of the Office Access 2003 hotfix package (Msaccess.msp): December 15, 2009
983235   MS10-036: Vulnerability in COM validation in Microsoft Office could allow remote code execution
982311   MS10-036: Description of the security update for Office 2003: June 8, 2010


Access 2007
978402   Description of the Office Access 2007 hotfix package (Access-x-none.msp, Ace-x-none.msp): February 23, 2010
981049 Description of the Access 2007 hotfix package (Access-x-none.msp, Ace-x-none.msp): April 27, 2010
201284 When you create a Pivot Chart or a Pivot Table in Microsoft Office Access 2007, the Field List is not visible
201284   When you create a Pivot Chart or a Pivot Table in Microsoft Office Access 2007, the Field List is not visible
982312   MS10-036: Description of the security update for the 2007 Office system: June 8, 2010

Monday, May 24, 2010

Access Switchboard to Ribbon Converter Wizard

Exclusive to readers of Access Extra!
A new free Wizard for Access 2007 and Access 2010






















This Wizard has been retired and replaced by The Access Instant Ribbon Wizard. The Wizard will automatically create an Access 2007/2010/2013 Ribbon Switchboard based on the native Switchboard Items table in your database built using the native Access Switchboard Manager.

Download


The Access Switchboard to Ribbon Converter Wizard in just two mouse-clicks turns your legacy Access Switchboard (as built by the native Access Switchboard Manager) into a fully functional Ribbon Switchboard!

Download now! Only 155kb (v1.0.1 updated 27 May 2010)

Also check-out these free new Access 2007/2010 tools:

Friday, May 21, 2010

Office 2010 Developer Atlas

A new interactive portal for Office developers where you can explore the new features of of Office 2010.

Wednesday, May 12, 2010