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!
New Paper: Microsoft Access and Office 2010 Service Pack 2 (SP2) Enhnacements and Issues
Microsoft has released Service Pack 2 (SP2) for Microsoft Office 2010. It includes enhancements to Access, Excel, Groove, Office. Outlook, PowerPoint, Project, SharePoint, Visio, Word, and more.
Read our new paper listing:
- Links to the Download and List of Enhancements
- List of Updated Products
- Microsoft Access Enhancements and Fixes:
- Microsoft Access Object Issues
- Repair and Compact Issues
- Microsoft Excel Related Issues
- Access Web/SharePoint Issues
- Windows 8 64-bit Issue
- Runtime Version
- Known Issues from Microsoft
- A Confirmed Bug between MS Access 2010 and SharePoint 2013
- Additional Resources for Microsoft Office and Office 2010 SP1
FMS developer Molly Pell is a guest blogger on the Microsoft Access developer blog. This post demonstrates a neat trick that you can use to filter a Continuous or Split form while your users are typing in a Combo Box.
Check out the post here: Using a Combo Box to Search as you Type
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
Paper: Microsoft Access versus Microsoft Excel for Data Analysis and Reporting (Spreadsheets vs. Databases)
When working with ComboBoxes and ListBoxes, we often find the need to select the first item in the list by default. This can be done when the form loads, or when the rowsource values of the ListBox or ComboBox are changed.
We’ve written a new paper containing an explanation and sample database of how to do this with the ItemData(0) property.
Our example database contains a form with a ComboBox containing ProductCategoties, and a ListBox containing Products.
When the form loads, it selects the first Category in the list. When the Category is changed, the Products list is updated, and the first product is selected.
To learn more, read our tip on Microsoft Access Forms: Selecting the First Item in a ComboBox or ListBox and download our sample database.