@CloudExpo Authors: Zakia Bouachraoui, Pat Romanski, Yeshim Deniz, Elizabeth White, Liz McMillan

Related Topics: @CloudExpo, Microsoft Cloud, Containers Expo Blog

@CloudExpo: Article

Microsoft Office Access and Cloud Computing

Business productivity thick client cloud applications

Microsoft Office Access is one of the  most  popular thick client / client server application development tool  that is prevalent in the enterprises today.  Its simplicity to use, fitment for quick departmental applications and ability to be home grown by the business users without dependency  on IT and  still a  poor man's adhoc  reporting tool,  all makes MS Access a  permanent place in most enterprises.

The latest incarnation of this application development and reporting tool has the following  benefits:

  • Build a relational database for small applications much faster using wizards
  • User interface forms and reports using a common look and feel of Microsoft Office
  • Automation features to avoid manual coding
  • Ability to act as Information Integration Engine which can connect disparate data sources

Mostly Microsoft Access is used as  a desktop thick client application and with increased usage of the Cloud Platform it would be helpful to analyze the options for Microsoft Office in Cloud.

Microsoft Access In Office 365
From older version of Microsoft Access we can  move the data to Microsoft Access 2010, and then publishing the database to Access Services on Office 365, you can make your data accessible to all of your colleagues wherever they are. Perhaps more importantly, your database will be better able to grow as your needs change.

We can use Access 2010 and Access Services, a new component of SharePoint, to build web database applications. Access 2010 and Access Services provide a platform for you to create databases that you can use on the Web. You design and publish a web database by using Access 2010 and SharePoint, and people who have SharePoint accounts use the web database in a web browser.

When you publish a web database, Access Services creates a SharePoint site that contains the database. All of the database objects and data move to SharePoint lists in that site.

SSMA to SQL Azure
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure. SSMA 2008 for Access also supports migrating to SQL Azure.

SSMA provides a Wizard-like interface that allows us to:

  • Create a Migration Project in SSMA with SQL Azure as the destination
  • Allows us to choose the target schema for migration
  • Migrate the tables and data with the convert , Load and Migrate command
  • Provides ability to verify the migration

This tool provides an out-of-the-box solution for migration of Microsoft Access databases to Cloud.

Microsoft Access As Thick Client Cloud Consumer
If the  data resides in SQL Azure, then Microsoft Access can continue to be a thick client and connect to a Cloud database using the linked tables option.

With Microsoft Access 2010, You can create an external data connection to a Web Service. For example, you can create a Web Service data connection to your enterprise Business Data Catalog and get business data. After you create a Web Service data connection, you can link to it as you would any other external data source. If the Web Service accepts parameters, you can change the parameters when you create a linked table by using the Web Service data connection.

The following are the general steps  in  making Microsoft Access  consume Cloud Web Services as a thick client.

  • Obtain a Web Service data connection file
  • Install the web service data connection by using the connection file
  • Create a linked table by using the installed web service data connection

Microsoft Office Access continues to be  most productive end user reporting tool and in the past decade numerous enterprise class applications have been written using that tool.

We cannot discount the immense value Microsoft Access applications brought to end user analytics, adhoc reporting and complex client side calculations. The biggest draw back  for the Microsoft Access applications  have been hither to its storage where by the Jet engines which is the underlying database have historically known for space limitation.

While over the period the limitations have been reduced to a great extent, the above mentioned Cloud Migration options makes Microsoft Access continuously play a role in the enterprise end user productivity applications.

With the support for  Microsoft Office mobile  applications  , having  Microsoft Access as a thick client which can consume  cloud data may be a  worth while option for future productivity applications.

More Stories By Srinivasan Sundara Rajan

Highly passionate about utilizing Digital Technologies to enable next generation enterprise. Believes in enterprise transformation through the Natives (Cloud Native & Mobile Native).

CloudEXPO Stories
Automation is turning manual or repetitive IT tasks into a thing of the past-including in the datacenter. Nutanix not only provides a world-class user interface, but also a comprehensive set of APIs to allow the automation of provisioning, data collection, and other tasks. In this session, you'll explore Nutanix APIs-from provisioning to other Day 0, Day 1 operations. Come learn about how you can easily leverage Nutanix APIs for orchestration and automation of infrastructure, VMs, networking, and even backup/DR. We'll review available APIs and conduct live demonstrations of integrations and the automating common IT tasks.
Digital Transformation (DX) is a major focus with the introduction of DXWorldEXPO within the program. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throughout enterprises of all sizes. We are offering early bird savings on all ticket types where you can save significant amount of money by purchasing your conference tickets today.
It cannot be overseen or regulated by any one administrator, like a government or bank. Currently, there is no government regulation on them which also means there is no government safeguards over them. Although many are looking at Bitcoin to put money into, it would be wise to proceed with caution. Regular central banks are watching it and deciding whether or not to make them illegal (Criminalize them) and therefore make them worthless and eliminate them as competition. ICOs (Initial Coin Offerings) are something most have no idea as to what it means and how you utilize it. Where is the "Stamp of Approval" or "Stamp of Legitimacy" on some of these Bitcoin websites (how do you know you are not dealing with a scammer?)
René Bostic is the Technical VP of the IBM Cloud Unit in North America. Enjoying her career with IBM during the modern millennial technological era, she is an expert in cloud computing, DevOps and emerging cloud technologies such as Blockchain. Her strengths and core competencies include a proven record of accomplishments in consensus building at all levels to assess, plan, and implement enterprise and cloud computing solutions. René is a member of the Society of Women Engineers (SWE) and a member of the Society of Information Management (SIM) Atlanta Chapter. She received a Business and Economics degree with a minor in Computer Science from St. Andrews Presbyterian University (Laurinburg, North Carolina). She resides in metro-Atlanta (Georgia).
Organize your corporate travel faster, at lower cost. Hotailors is a next-gen AI-powered travel platform. What is Hotailors? Hotailors is a platform for organising business travels that grants access to the best real-time offers from 2.000.000+ hotels and 700+ airlines in the whole world. Thanks to our solution you can plan, book & expense business trips in less than 5 minutes. Accordingly to your travel policy, budget limits and cashless for your employees. With our reporting, integrations and real-time analytics, you can easily control your travel policy, reduce spendings and increase the efficiency of your company. Hotailors ia an artificial intelligence powered marketplace for business travels. Friendly to use technology based on artificial intelligence to plan, book and expense business travel in 5 minutes. Within one login on one dashboard, user has access to almos...