How end-users migrate from Excel to Access, then learn how to code
Why people are hesitant to purchase third party products and how FMS overcomes that by showcasing the value we offer
Using tools like Total Access Analyzer to catch errors before shipping and learning best practice
Using the module code in Total Visual SourceBook to address problems we’ve already solved so you can focus on the unique issues in your applications
The value of creating consistent, quality code
How to improve code for developers of all backgrounds
Being in constant “growth” mode to look for ways to become a better developer
FMS Inc. is proud of the quality of products we have produced for the past 30 years. We are honored to continuously be regarded as a leading expert in the Access community. Thank you for supporting us and we hope you enjoy the 20 minute interview!
You can quickly create surveys with Excel and make them available online with all results saved in the spreadsheet hosted in Office365. Just create an Excel spreadsheet in Office365 and choose the Survey item on the ribbon to design it.
A link is provided to share with people to respond. They don’t need to have Excel or Office365. Just a web browser. Try our sample by clicking the image below:
Shorten the URL
Excel provides a very long URL to share your survey. By using a site like bit.ly, you can create a shorter one to email to your contacts. This is important to avoid problems when URLs get word wrapped in emails. For instance, this survey is shortened to: http://bit.ly/2mfv56r
Results in Your Spreadsheet
The results go directly into your spreadsheet with each submission as a separate row:
Having the ability to create a survey and see the results in a spreadsheet in minutes, is a terrific tool to help your projects!
We are pleased to introduce new versions of Total Access Statistics for Microsoft Access 2007 and 2003; versions 12.9 and 11.9 respectively. They include the many features we introduced with the latest Access 2016 version.
Total Access Statistics is an add-in that is the most powerful data analysis program for Microsoft Access. It extends the power of Access queries to analyze the data in your local or linked tables. It generates results in tables you can view or include in other queries, forms, and reports. It offers a wide range of statistical functions such as:
Financial Cash Flow Calculations
Running Totals and Moving Averages
Group Analysis (t-Tests and ANOVA)
Record Analysis and Rankings
Additional percentile types can be assigned to a field in your table
Enhanced data formatting
Improved financial calculations for IRR and XIRR
Updated user manual
Support for Windows 8 and 10
New Add-in and Runtime Library Files
Version 12.9 and 11.9 include new files for the Access add-in. It also has new runtime library files.
A digitally signed MDE library for MDB databases that support users of Access 2016, 2013, 2010, 2007 and 2003.
The Access 2007 version includes an ACCDE runtime library for ACCDB databases for Access 2016, 2013, 2010 and 2007 users
The Access 2003 version includes a runtime library for Access 2000 and 2002 users
Total Access Statistics is now available for Microsoft Access 2016 (32 and 64-bit versions). Running as an Access add-in Wizard, Total Access Statistics generates a wide range of numerical analysis beyond the power of queries. All results are in Access tables that you can add to your queries, forms and reports.
Total Access Statistics includes a VBA programmatic interface with a royalty-free runtime distribution library so you can add the advanced analysis into your Access applications for distribution to others.
Download the Free Trial to experience it yourself.
Owners of Total Access Statistics for earlier versions of Microsoft Access can upgrade at a discounted price.
Total Access Statistics is the most advanced data analysis program for Microsoft Access. It extends the power of Microsoft Access queries with a wide range of statistical calculations including percentiles, frequency distributions, correlations, regressions, rankings, running totals, financial cash flow analysis, data normalization, crosstabs with Chi-Square, t-Tests, ANOVA, non-parametrics, probabilities, and more.
Total Access Statistics is now available for Microsoft Access 2013. Total Access Statistics 2013 includes many enhancements since the prior release of Total Access Statistics 2010:
Support for the 32 and 64 bit versions of Access 2013 with separate add-ins for each
New redistributable runtime libraries to support Access 2013, 2010, 2007, and 2003
Support for Windows 8 (and all Windows versions supported by Access)
Improved performance when analyzing large data sets
For Percentiles, when assigning percentile values to a field in your table, you can specify calculations such as quartiles, quintiles, octiles, deciles, etc. rather than just percentile
Field format is set to Percent for percentage fields in the Frequency, Crosstab (when percentages are in columns), and Chi-Square details tables
When tables are generated from the add-in, the field column widths are resized to show the entire field name and data