May 26

Invitation to Preview Version of Total Access Statistics for Microsoft Access 2010

We are pleased to announce the availability of the preview version of Total Access Statistics for Microsoft Access 2010. Total Access Statistics is the most popular data analysis program for Microsoft Access. It extends the data analysis capabilities of Access queries to let you perform advanced numerical analysis on your data. Use any Access table, linked table, or query to perform calculations such as percentiles, regressions, frequency distributions, t-Tests, correlations, non-parametrics, rankings, moving averages, etc. It can also perform data normalization and let you select random records. As you would expect in a query, you can specify Group By fields so analysis is performed on each set of records with identical group fields.

Microsoft Access 2010Total Access Statistics runs within Access with all output in Access tables. It supports MDB, ACCDB, and ADP databases.

In addition to supporting Access 2010, we’ve added financial calculations for cash flows. It now calculates net present value (NPV), present value (PV), future value (FV), internal rate of return (IRR), and modified internal rates of return (MIRR).

This FREE preview is available with support for both the 32 and 64 bit versions of Access 2010. It includes both the interactive wizard that runs as an add-in, plus the programmatic VBA library so you can embed statistical analysis in your applications.

The preview version is fully functional through September 1, 2010. Download it here:

May 11

Microsoft Access 2010’s New Feature to Web Enable Access Databases

Microsoft Access 2010

One of the most compelling features of Microsoft Access 2010 is its ability to post an Access database on a SharePoint 2010 site and have it run over the web. Some people hear this and think they'll be able to take their existing Access application, all its VBA code, etc., and make it web enabled. Unfortunately, that's not the case. What you can expose to the web is forms and reports that don't use VBA code. That's obviously a severe limitation, but on the plus side, what is possible is the deployment of databases that have automation through Access macros. The macros are automatically converted to JavaScript code. That's pretty cool.

An Access database that's hosted in this way can still be used locally on a desktop that has Access 2010 installed with all the rich functionality of Access, VBA, etc. The data is then hosted in SharePoint which exposes it to the web. So while it's not making it possible to publish an entire Access application with VBA to the web, at least a portion of it may be exposed with little to no additional effort. Letting people browse data, filter, and generate simple reports is all available and possible by non-programmers. It's a big step forward for the Access community.

Apr 13

Microsoft Access 2010 Preview Version of Total Access Admin

We are pleased to release a FREE preview version of Total Access Admin 2010 for your review. Total Access Admin lets you monitor Access databases in real time. Select any Access Jet database (MDB or ACCDB) across your network to view and log users as they enter and exit your database. It's particularly useful for documenting suspect connections that could be the source of database corruption. You can also perform a variety of tasks such as locking new users from opening your database, compacting the database after everyone has exited, etc. The existing version supports Access 2007 and earlier. This new version support Access 2010 for both 32 and 64 bit formats, along with databases from earlier version of MS Access. For more information and download instructions, visit Total Access Admin 2010 Preview.

Jul 27

Collapsing the Office 2007 Ribbon to get more space in your program

When moving from earlier versions of Microsoft Office programs (Access, Word, Excel, PowerPoint, Outlook) to Office 2007, the new Ribbon can be very difficult to get used to. One common complaint is that it takes up so much space. However, did you know that the ribbon can be easily collapsed to give you extra vertical space?