Category Archives: Microsoft Access Reports

Jun 24

Total Access Memo 2021 is Now Available!

Posted on by

We are excited to announce the release of Total Access Memo 2021! Total Access Memo lets you add rich text format (RTF) memos to Microsoft Access with sophisticated editing and spell checking. Our super-easy data binding means you can display rich text on your forms and reports and store it in your tables.

memoGive your users the ability to add text with different fonts, point sizes, fonts styles (bold, italics, underline, etc.), bullet points, tabs, paragraph margins, indentations, alignment, spacing between paragraphs, color, graphics, hyperlinks, etc .

Total Access Memo 2021 is an upgrade from the 2007 version and includes these enhancements:

  • Support for 64-bit Versions of Access/Office including 365
  • Backwards Compatibility
  • Improved Rich Text Editor
  • Enhanced Sample Database
  • Updated Manual and Help File
  • New Setup and Distribution Programs

Download the free trial to experience it for yourself.

Existing Total Access Memo owners are eligible to upgrade at a discounted price.

May 19

Total Access Detective Update for Microsoft Access 2016, 2013, 2010 and 2007

Posted on by

Total Access Detective finds differences between Microsoft Access databases and objects. Updates for Total Access Detective are available for Microsoft Access 2016, 2013, 2010 and 2007.

Enhancements:

  • Improved SQL string comparisons for saved queries and properties like RecordSource and RowSource.
  • Trailing blank spaces and extra blank lines are removed before comparing them, this avoids flagging SQL string differences that do not affect functionality.
  • Query comparison. Under Data Options, if the query option is set to First Field Unique, it was always treating them sequentially and stopped on the first difference. This is fixed and works correctly.
  • Table macro comparison supports table names with apostrophe (‘) in the them.
  • Text comparison. If the VBA option is not selected, the results do not show the the Procedure tabs.
  • Database comparison results: The database name goes across the entire top of the form rather than being truncated.
  • All other reported issues.

For more information, visit:

Existing Total Access Detective owners were notified to download the update.

Total Access Detective Updates

Feb 21

Microsoft Access Version Comparison Matrix

Posted on by

microsoftboxes2013Microsoft Access debuted in 1992 and recently celebrated its 25th Anniversary! Over the decades, Microsoft Access evolved with a large number of enhancements, database formats, features both new and old. and discontinued features.

It’s hard to remember all the changes. Fortunately, we created a comparison matrix that shows the different Microsoft Access versions and changes. See when versions were released, their latest service packs, database formats, linked tables, field types, security features, Windows Operating Systems, and many other features both new and old.

Visit our page: Microsoft Access Version Features and Differences Comparison Matrix

feature-matrix

 

Jul 03

Inspection Software for the National Archives and Records Administration (NARA)

Posted on by

National Archives and Records Administration (NARA)With the upcoming 4th of July celebrations, we at FMS are proud to have worked with the National Archives and Records Administration (NARA) over the past year to help them better maintain and preserve the important documents of our nation. Here’s what we did in our new case study, Inspection Software for the National Archives and Records Administration (NARA).

About the National Archives

The National Archives and Records Administration (NARA) is the record keeper for the United States. Of all documents and materials created in the course of business by the United States Federal government, only 1%-3% are important enough for legal or historical reasons that they are kept by NARA forever.

Natonal Archives Building in Washington DC

Background

To ensure the quality of work performed by their Facilities Management service providers, the National Archives and Records Administration performs both random and targeted inspections of completed work orders.

Problem

Inspection findings were documented on paper, which ironically, wasn’t efficient for the NARA. Reports were manually created to generate the service results. This manual process was time consuming and prone to human error.

Solution

FMS was selected to create a professional, multiuser system to collect the inspection results electronically and generate a variety of management reports.Within two months, we deployed our solution which offers data entry screens to replicate a variety of existing forms and many new management reports. An intuitive user interface made it easy for users without requiring extensive training. More importantly, we established a solid database foundation to improve NARA processes both today and into the future.

Operational Impact

  • Stores inspection results into a shared database
  • Increases efficiency and accuracy of the collection and reporting process
  • Gathers information and performs statistical analysis in ways that were previously not available
  • Eliminates the need to maintain paper files
May 24

Microsoft Access Crosstab Queries in Reports on the Microsoft Access Developer Blog

Posted on by

FMS developer Molly Pell is featured as a guest blogger on the Microsoft Access developer blog.

This post demonstrates how to use the Pivot statement to control column names returned by crosstab queries, allowing crosstabs to be used on reports.

Check out the full post, Using crosstab queries in reports.

For another paper with an example of Creating an Annual 12 Month Summary Report without VBA Code by Creatively Using a Microsoft Access Crosstab Query

Apr 23

Microsoft Access versus Microsoft Excel for Data Analysis and Reporting

Posted on by

Microsoft ExcelMicrosoft AccessChoosing Between
Spreadsheets and Databases

We are often asked by Microsoft Office power users whether, why, and when they should use Microsoft Access versus Microsoft Excel. Especially when they are very comfortable using MS Excel and don’t understand the reasons why anyone would use MS Access or databases. We’ve written a new paper that describes the issues in detail:

  • How Microsoft Access and Excel Empower Information Workers
  • Advantages of Microsoft Excel Spreadsheets
  • Disadvantages of Microsoft Excel Spreadsheets
  • Advantages of Microsoft Access and Databases
  • Disadvantages of Microsoft Access
  • How they Should Work Together

For more information, visit Microsoft Access versus Microsoft Excel for Data Analysis and Reporting (Spreadsheets vs. Databases).