@CloudExpo Authors: Carmen Gonzalez, Yeshim Deniz, Zakia Bouachraoui, Chander Damodaran, Elizabeth White

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
Moving to Azure is the path to digital transformation, but not every journey is effective. Organizations that start with a cohesive, well-planned migration strategy can avoid common mistakes and stay a step ahead of the competition. Learn from Atmosera CEO, Jon Thomsen about the opportunities and challenges found in three pivotal phases of the journey to the cloud: Evaluation and Architecting, Migration and Management, and Optimization & Innovation. In each phase, there are distinct insights that can give a company the edge and make sure cloud adoption is closely aligned to core business goals. Keeping these in mind will make your migration to the Azure simpler and more effective.
CloudEXPO has been the M&A capital for Cloud companies for more than a decade with memorable acquisition news stories which came out of CloudEXPO expo floor. DevOpsSUMMIT New York faculty member Greg Bledsoe shared his views on IBM's Red Hat acquisition live from NASDAQ floor. Acquisition news was announced during CloudEXPO New York which took place November 12-13, 2019 in New York City. Our Silicon Valley 2019 schedule will showcase 200 keynotes, sessions, general sessions, power panels, and hands on tutorials presented by 150 rockstar speakers in 10 hottest conference tracks of 2019:
Cloud is the motor for innovation and digital transformation. CIOs will run 25% of total application workloads in the cloud by the end of 2018, based on recent Morgan Stanley report. Having the right enterprise cloud strategy in place, often in a multi cloud environment, also helps companies become a more intelligent business. Companies that master this path have something in common: they create a culture of continuous innovation. In his presentation, Dilipkumar Khandelwal outlined the latest research and steps companies can take to make innovation a daily work habit by using enterprise cloud computing. He shared examples from companies that have benefited from enterprise cloud computing and took a look into the future of how the cloud helps companies become a more intelligent business.
Data center, on-premise, public-cloud, private-cloud, multi-cloud, hybrid-cloud, IoT, AI, edge, SaaS, PaaS... it's an availability, security, performance and integration nightmare even for the best of the best IT experts. Organizations realize the tremendous benefits of everything the digital transformation has to offer. Cloud adoption rates are increasing significantly, and IT budgets are morphing to follow suit. But distributing applications and infrastructure around increases risk, introduces complexity and challenges availability at every turn. To embrace DX and to come out on top, there are four underlying principles that should guide you. Understanding these four essentials along with their relevance and impact will elevate you to DX Hero status now. Jonathan will provide a high-level overview of these principles and how some of his organization's clients have embraced them w...
DevOps has long focused on reinventing the SDLC (e.g. with CI/CD, ARA, pipeline automation etc.), while reinvention of IT Ops has lagged. However, new approaches like Site Reliability Engineering, Observability, Containerization, Operations Analytics, and ML/AI are driving a resurgence of IT Ops. In this session our expert panel will focus on how these new ideas are [putting the Ops back in DevOps orbringing modern IT Ops to DevOps].