All about Microsoft Access 2013 and Access 365

Website design By BotEap.comMicrosoft Access 2013 is the software that has progressed over the years from Access 1.1 in 1992 till now.

Website design By BotEap.comOffice Professional 2013 software (which includes Word, Excel, PowerPoint, Outlook, and Access) will allow you to install and run Access 2013 as usual.

Website design By BotEap.comThe Office 365 version is paid for by monthly subscription and provides web services to Office 2013. It includes Office Professional 2013 software, as well as Access 365 and Access 2013.

Website design By BotEap.comAccess 365, other than the “Access” name, has little or nothing in common with Access 2013 or earlier versions of Access.

Website design By BotEap.comWhat is Access 365 all about?

Website design By BotEap.comAccess 365 is a tool for building web applications that run on SharePoint 2013. The old .ACCDB format has been abandoned. New apps should use the Access 365 model or stick with Access 2010.

Website design By BotEap.comAccess 365 enables the rapid creation of small applications using the standard web technologies of HTML5, CSS, and JavaScript in a simplified web development environment. One important feature is that Access Services can now store data in Microsoft SQL Server or in a SQL Azure database.

Website design By BotEap.comSQL Server usage exceeds the 2 Gigabyte size limit of older Access databases. SQL Server also provides all the essential security and functions for any strategic business system in the company.

Website design By BotEap.comAnd what about Access 2013?

Website design By BotEap.comThe desktop version of Access 2013 hasn’t changed much from previous versions: it still supports the front-end and back-end database model and Visual Basic for Applications (VBA).

Website design By BotEap.comBut Access 2013 no longer supports:

  • The Microsoft Access Project (ADP)
  • The Access 97.mdb database format
  • PivotCharts and PivotTables
  • The dBASE database
  • Smart tags (action tags)
  • Access to 2003 toolbars and menus
  • Microsoft SQL Server Database Convert Wizard
  • Developer source control
Website design By BotEap.comoffice applications

Website design By BotEap.comThere’s a new feature in Access 365: Apps for Office. This technology allows Office to be used as a Cloud or Web service. The web page can be hosted in an Office application, ie Excel, Word, Outlook, PowerPoint or Project.

Website design By BotEap.comTypically, an app is published to the Office Store for your use.

Website design By BotEap.comJavaScript API for Office

Website design By BotEap.comAccess 365 has a new JavaScript API that provides programmatic access to Microsoft Office documents. The API includes application-specific data types, objects, functions, and events.

Website design By BotEap.comThe JavaScript API is a vast improvement on the raw JavaScript layout capabilities within HTML.

Website design By BotEap.comSharePoint applications

Website design By BotEap.comAccess 365 provides an easy way for SharePoint to host the front end of an application and have the data management capabilities of SQL Server on the web. This simplifies web development.

Website design By BotEap.comNote that Visual Basic for Applications (VBA) code is not compatible with SharePoint Access applications.

Website design By BotEap.comAccess the 365 macro editor

Website design By BotEap.comTemplates can be used to create sophisticated-looking applications, without the need for code. However, business rules and data manipulation can be implemented with a new macro language. Macros don’t have the power of VBA, but they are adequate for simple logic.

Website design By BotEap.comMicrosoft Strategic Direction

Website design By BotEap.comMicrosoft Access was never intended for corporate business databases. Many companies have built Access database software into their central administration systems. But with the limitations of network traffic, peak loads, reliability, rollback recovery, security, etc., etc., these systems eventually hit a brick wall.

Website design By BotEap.comThe direction that Access 365 is now taking goes back to the original intent of Microsoft Access. That is, it provides a rapid development environment for small line-of-business (LOB) applications.

Website design By BotEap.comMicrosoft Access with VBA is at the end of the road. For mission critical management systems, the best development platform is Visual Basic.Net with SQL Server.

Leave a Reply

Your email address will not be published. Required fields are marked *