Tuesday, June 28, 2011

Office 2010 SP1 Released

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

Tuesday, June 07, 2011

Ways to share an Access database

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

Friday, May 06, 2011

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

Tuesday, April 26, 2011

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.

Tuesday, March 29, 2011

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.