Access

The McKinstry Tool Tracker App: Using Access 2013 and Office 365 to manage critical assets

McKinstry, a builder and manager of energy-efficient commercial buildings, needed an efficient and accurate way to track tools. Microsoft worked with the company to create an app using Access 2013 (and hosted on Office 365) showing current location, availability, usage history, and storage locations. A barcode scanner sends keystrokes through a USB connection, and Access uses built-in search to instantly identify the tool based on the code in the record for that tool. A data macro checks…

Excel

New server release: Spreadsheet controls in Office 2013

In April, we released 2 important new spreadsheet management server-based applications to complement the desktop spreadsheet management features we introduced with the release of Office 2013. Now available are Audit and Control Management Server (ACM), and Discovery and Risk Assessment, which are both designed to help you manage the use of spreadsheets and Access databases.  Read on to learn more.