Mar 14

Create Surveys with Excel Online hosted in Office365

excel-icon-lgYou 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:

survey

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:

response

Having the ability to create a survey and see the results in a spreadsheet in minutes, is a terrific tool to help your projects!

 

Mar 07

Total Access Statistics 2003 11.9 and 2007 12.9 Released

Total Access StatisticsWe 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:

  • Field Descriptives
  • Financial Cash Flow Calculations
  • Percentiles
  • Running Totals and Moving Averages
  • Field Comparison
  • Frequency Distributions
  • Regressions
  • Advanced Cross-Tabulations
  • Group Analysis (t-Tests and ANOVA)
  • Record Analysis and Rankings
  • Non-Parametric Analysis
  • Probability Calculator

New Features

  • 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

For more information, visit New Version X.9 Features.

Try out the new enhancements with our
download-trial-blue

Feb 15

Total Access Admin 2016 Released

real-time-monitortotal-access-adminadmin-icondownload-trial-blue

We are excited to announce our release of Total Access Admin 2016! Total Access Admin is our administrator tool to help you monitor the users going in and out of your Microsoft Access databases (ACCDB and MDB formats) in real-time:

  • adminSee who is currently connected to your Microsoft Access database (you can manage multiple databases from one screen)
  • Monitor up to 150 databases at one time
  • Keep a log of users entering and exiting each database
  • Identify workstations or users disconnecting in a suspect manner which may be the source of database corruption
  • Compact your database when all users exit it
  • Prevent new users from logging into your database
  • Log off idle users
  • Communicate with your users in real-time

New Features

Total Access Admin 2016 is an update from the 2013 version and includes these enhancements:

  • Monitors ACCDB and MDB format databases created by Microsoft Access 2016 (32 or 64-bit version) and earlier versions of Access
  • Works in environments where Access 32 or 64-bit versions is installed, including installations from Microsoft Office365
  • Does not require Microsoft Access to be installed on the machine
  • Up to 150 databases can be monitored at one time (up from 100)
  • Setup program supports Windows 8 and 10, Server 2012 and later, with an option to launch the program after its installed

database-monitor

Download the free trial version today!

Existing customers can upgrade at a discounted price.

Oct 28

FMS Inc. Joins Microsoft Enterprise Cloud Alliance

FMS Inc., a leader in software database development and design, is proud to announce it is joining the Microsoft Enterprise Cloud Alliance.

Celebrating 30 years in software development, FMS has a long track record of building mission-critical solutions for a wide range of organizations around the world. From desktop to web and mobile solutions, FMS serves tens of thousands of customers in over 100 countries ranging from small to large commercial organizations, non-profits, educational institutions, and government agencies.

The Microsoft Enterprise Cloud Alliance offers an innovative way for FMS Inc. to integrate its innovative products and services with Microsoft Corp.

“We’ve helped many organizations create and deploy database applications on the Microsoft Azure cloud,” said Luke Chung, President and Founder of FMS, Inc. “With Microsoft’s cloud center, our solutions are hosted on an enterprise quality infrastructure platform that’s highly scalable and reliable.  It eliminates the headaches of managing our own hardware and connectivity, and best of all, it’s a fraction of the cost compared to doing it ourselves. That translates to quicker time to market and lower costs for our customers.”

To learn more about the Microsoft Enterprise Cloud Alliance, please visit https://msdn.microsoft.com/en-us/mt438667.aspx

About FMS Inc.

Since 1986, FMS has created innovative software solutions for commercial and government organizations. A Microsoft partner since 1992, FMS is a leading provider of products for Microsoft Access and Microsoft Office. Our Professional Solutions Group offers custom solutions on Windows, web and mobile platforms. Our Advanced Systems Group created Sentinel Visualizer, an advanced link analysis and data visualization product for the intelligence, defense and law enforcement communities. For 30 years, FMS has helped over 50,000 customers in more than 100 countries make better data-driven decisions.

Aug 24

Total Visual Agent Available for Microsoft Access 2016

topbannertotal-visual-agent-60scheduler

Total Visual Agent, the world’s most popular maintenance scheduling tool for Microsoft Access/Office and Visual Basic 6 (VB6) is now available for Microsoft Access 2016 (and earlier). This is the ninth major release of Total Visual Agent and introduces many enhancements to automate maintenance chores easier than ever.

To keep your Microsoft Access databases healthy, you need to regularly compact them. For disaster recovery, you should also be making backup copies of your database regularly. You may also have regular tasks such as printing reports that are performed regularly. Total Visual Agent does this and much more on a schedule you specify. Run tasks hourly, daily, weekly, monthly or just one time. Perform database chores, run Access macros or Windows command lines. A complete audit trail is maintained, and you can even be notified by email if something goes wrong. Total Visual Agent can also be run as a Windows service to restart if the machine reboots and for added security since a user doesn’t need to be logged in.

Total Visual Agent 2016 leverages our vast expertise, and offers the best database management solution with many new features:

Total Visual Agent

  • Supports Microsoft Access 2016
  • Supports Windows 8 and 10
  • Does Not Require Access to be Installed on your PC
  • Database Lock Error Identifies Offending Machines
  • Activity Log is Separated from Settings Database
  • Activity Log Shows Duration of Each Activity
  • Email Notifications Support TLS and Office365 SMTP
  • Tasks are Not Run at the End of an Event Interval
  • Enabled/Disabled Status Shown on the Event Form
  • More Robust Windows Service Feature
  • Improved Monitor Settings Tab
  • Default Location of Archive and Extract Folders Moved
  • Improved Setup Program
  • New user manual and help file
  • download-trial-blueand More…

Download the free trial version today!

Easily Define and Manage Events, Tasks, Databases and Folders

manager_2016