Ezy Start Menu for Windows 8 New Version v1.1

Ezy Start Menu for Windows 8 has been updated to v1.1. Now with application search

Download Latest Version  (8April2012 v.1.1)

RegDllView - View all registered dll/ocx/exe files on ypur PC

RegDllView is a neat little utility for developers that displays the list of all registered dll/ocx/exe files (COM registration). For each registered file, you can view the last date/time that it was registered, and the list of all registration entries (CLSID/ProgID). Download from CNET

Ezy Start Menu for Windows 8

Frustrated by the retirement of the Desktop Start Menu in Windows 8.  Try my free applet Ezy Start Menu.  Fast loading and read-only.

Ezy Start Menu is added to your StartUp folder, resides in the same corner of the Windows Desktop as the classic Start Menu,  and appears as a small blue Windows Metro 8 icon at the extreme end of the Taskbar.  Just Click on the Taskbar icon to open Ezy Start Menu.

Download Latest Version (8April2012 v.1.1) Now with application search.

Microsoft Office for iPad expected soon...

Microsoft Office for iPad expected in coming weeks | Sources now say that the app will soon be submitted to Apple for approval -

New Look for aadconsulting.com

I have just launched the new look aadconsulting.com with a sleeker modern and easier to navigate design:  aadconsulting.com. Come over for a visit.

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

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).

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.

Download

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.

New MS Office Developer Portals

• Office VBA Developer Center
• Office Developer Center
• Developing Office Business Applications with Office 2010 and SharePoint Server 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

Access Switchboard to Ribbon Converter Wizard

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

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:

• Ezy Access RibbonX Builder & Editor for Access 2007/2010
• Easily Migrate Legacy Access Switchboards to the Access 2010 Navigation Form

Office 2010 Developer Atlas

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

Office 2010 Australian Retail Release Date is June 15

According to LifeHacker

Microsoft Says: Top 10 benefits of Access 2010

Office 2010 will have its corporate launch tomorrow.  So what does Microsoft  consider compelling in Access 2010: Top 10 benefits of Access 2010.

Office Still Top Business Suite: Google Apps Serious Not

New Forrester data, released on May 11, reports that 81% of the enterprises it surveyed are running Office 2007 and 78% supporting SharePoint, compared to only 4% using Google Apps. Forrester also says that one third of survey respondents are already planning an upgrade to Office 2010 within the next 12 months. The Forrester sample is 115 North American and European enterprise and SMB decision makers.

Source: Forrester: ZDNet: Google still a distant Office competitor

Microsoft Access 2010 Source Code Control

The Microsoft Access 2010 Source Code Control makes it easy to deploy and manage solutions built using Microsoft Access.