Feb 13

Transposing Data in Microsoft Access Tables and Data Normalization

Microsoft AccessMicrosoft SQL ServerData normalization is fundamental to database design. Properly normalized data makes it easy to support an application over time and simplifies the querying, displaying, and reporting features of an application. 

Unfortunately, we don’t always receive or have normalized data. Tables that require adding fields as the data changes over time are particularly problematic and violate the basic premise of database design where adding records is free, but adding fields is expensive:

Here are some updated resources detailing the value of data normalization, including a sample database and VBA code to transpose and normalize your existing data.

These and other related papers are part of our developer centers:

Hope these help you create more scalable, maintainable, and analyzable databases.

For advanced data analysis, check out our Total Access Statistics add-in product.

Feb 09

Free Preview of Total Access Analyzer for Microsoft Access 2010 Database Documentation

Microsoft Access 2010Microsoft Access Database DocumentationMicrosoft Access Database DocumentationMicrosoft Access Documenter

The Microsoft Access 2010 version of Total Access Analyzer is close to shipping and we are pleased to offer a FREE preview for you to try it.

Total Access Analyzer is the most popular Microsoft Access add-in and the winner of every Best Microsoft Access Add-in award ever. With Total Access Analyzer, you can truly understand what's going on in your database. Generate comprehensive documentation of all your database objects, get detailed table and field lists, module code printouts, form and report blueprints, and much more. Get detailed cross-references for how objects are linked to each other so you know exactly where each table, query, form, report, macro and module procedure is used. The Application Flow, Data Flow, and Object Flow Diagrams show how code and objects flow across your entire application. Over 300 professional quality and customizable reports are available.

Almost 300 types of issues are uncovered to pinpoint errors, suggest design improvement, and recommend performance tips. Find unused objects, missing field references, unused code and many other things that should be fixed before you deploy your applications. Many of the tips are recommended Best Practices for Access development, so you'll learn how the pros improve their design and development techniques.

We've added many new features to support Access 2010, generate more useful documentation, identify more errors, and suggest more design improvements and best practices. We've also improved the user experience with the ability to open a cross-referenced item in design mode while viewing the information, previewing multiple reports at once, and adding color to all reports. Here is a description of new features.

Take this opportunity to learn what Total Access Analyzer can do for you. See how it documents your databases and identifies errors and opportunities for improving them at the object and code levels. Discover why so many Access users and professionals rely on the program to deliver and create more robust solutions.

The preview version is available for immediate download and is fully functional. It expires on March 15, 2012.