By James C. Elledge, IFMA Fellow, CFM, FMA, RPA, RIAQM
Published in the January 2011 issue of Today’s Facility Manager
Q I am looking for software that can handle tech scheduling, work order creation, and billing. Can you recommend a free solution?
Canyon Gate Real Estate Services
A There are many “free” work order applications out there, but this will mean limited use. You can try it for a little while, but you can’t save or print results. If you have an IT group, you may be able to tap into some of its resources. Spiceworks, for example, is a free IT management program which includes a work order system.
I am also a firm believer in user created databases. Microsoft Access comes with templates to create your own applications such as work order tracking, billing, and so on. Microsoft offers free templates online that are available to download.
What’s nice about Access is you can customize it to your requirements, including attaching photos, documents, and drawings to specific items. Access will export into SQL Server as the database grows, allowing further flexibility.
Access interfaces with Word, Excel, and Outlook, thus automating forms and invoices. It imports data from most ODBC compliant databases, which can help in retrieving information from areas such as accounting or human resources.
All questions have been submitted via the “Ask TheExpert” portion of the magazine’s Web site. To pose a question, visit this link.
You might like:
- Workplace Design: Four Trends
- Predictive Analytics For “Low-Tech” Facilities
- Employee Engagement: Impact Of Workplace Design
- Friday Funny: The Dirty Truth About Public Bathrooms
- Leadership Support Linked To Workplace Well-Being
- Five Safety Tips For Your Facility’s Construction Project
- Facility Management Critical To Infection Control
- Planned Investment In Energy Efficiency Hits All-time High
- Employee Engagement Linked To Workplace Satisfaction
- Healthcare Waiting Room Design
- New School Construction Focused On Building Envelope Performance
- 4 Ways To Avoid LED Lighting Failure
- Employees Are Leading Cause Of Data Breaches
- U.S. Employers Suffer Largest Talent Shortage In Skilled Trades
- Smart City 2.0: Next Step In Urban Innovation