• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Technology
    • Development
    • Hardware
    • Intune
    • Microsoft
    • Office
    • Office 365
    • Security
    • SharePoint
    • Software
    • SQL server
  • Personal development
    • Blog
    • Career
    • Freelancer
    • Knowledge
    • NEWS
    • Private
    • Thoughts
  • Consulting services
  • Contact me

Not only IT

About life, IT and other things...

Home » Technology » Office 365 » SharePoint App without coding

SharePoint App without coding

June 24, 2014 By Tomasz Szulczewski 2 Comments

SharePoint App without coding? Is that even possible? If you are a SharePoint person I am sure that you heard about Apps. What are apps? Microsoft’s short explanation states that Apps are mini-applications that extend what you can do with the new version of Office and SharePoint 2013. For example, with apps you can use Wikipedia without leaving Word or get directions and maps right in Outlook. Apps are available for Word, Excel, Outlook, Project, PowerPoint, and SharePoint 2013.

I am not a big fan of them, as I prefer sandbox solutions, but I have to admit that If you want to create solutions for Microsoft cloud sooner or later you will use them. Anyway It will take some time to learn how to create them, but please let me show you how to create a powerful App for SharePoint without code. To do this we will use great possibilities of the new Access version. So let’s start.

At the first step we have to create Access App on our SharePoint site

Access APP
Access APP

Now it’s time to start the customization of our solution. When your Access application will be created select “Open this app in Access to start adding tables.”

Edit App in Access
Edit App in Access

When you provide your Office 365 credential you will see empty project in your local Access installation. You will have then a lot of options. You can build your app base on existing data sources.

Create a table from existing date source
Create a table from existing date source

And other great possibility are existing templates. Let’s check what we get when we enter “sell” word into search templates box.

Sell
Invoices

As you can see we get a lot of possible templates. Ok, let’s select “Invoices” template.  We have wait a few seconds when Access will make our configuration. and then we will see ready to use application – SharePoint App without coding! Let’s see. As you can see below Access created for us a couple of tables and forms. Everything is ready to use. Also, when you display for example “product” table, you will see that even relation between tables “product” and “supplier” has been set. Isn’t awesome?

SharePoint App
SharePoint App

Now just save and you can press button “Launch app”. You will be taken back into your SharePoint site and you can start using your SharePoint App without coding 🙂 . There’s also another great feature which I have to mention about. When you work with Access you can go to “File” menu and there is an option “Save as Package” in “Save as” menu.

App package
App package

With this simple option, you can easily move your SharePoint App to another site.

This example looks simple, but in many cases, it will be absolutely enough to meet all business requirements. Please note that this application is really fully functional and it will not require any developer skills! But of course, if you want you can make very easy some modifications to the app – I will show you this soon in my next post.

Do you like this you can check the post related to SharePoint or office 365 development:

  • Is it possible to pass parameter in url to Infopath form?
  • How to use CSOM to copy file into Office 365

Related

Filed Under: Office 365 Tagged With: Office 365, SharePoint

About Tomasz Szulczewski

I've got more than 20 years of IT experience. IT is my passion and I am still increasing my skills. I work as a SharePoint, Office 365 and Azure architect.

Reader Interactions

Comments

  1. Mohammad says

    July 4, 2014 at 11:14 am

    hi , i have a question: does it works just with SQL Server 2012 and later ? i got an error : No database servers are available for create (After image No.1 of your post). i searched for the reason and may be it’s because of SQL Server (mine is 2008 R2)

    Reply
  2. Tomasz Szulczewski says

    July 4, 2014 at 12:01 pm

    Hi,
    I guess that you want to run the app on premise SharePoint installation. Am I right? So first of all, do you have configured “Access Services” in your SharePoint installation? Please remember that you need Enterprise version to make this example or SharePoint online. Please check version comparison at http://technet.microsoft.com/en-us/library/jj819267.aspx

    Reply

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Join the Newsletter

Social media

  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

Search this site

Sign up for Wise accounts

Signup and earn $25

payoneer
payoneer

My latest achievement

Microsoft 365 Certified: Enterprise Administrator Expert
Microsoft 365 Certified: Enterprise Administrator Expert

Tags

Azure Azure Active Directory BizSpark Blog career Certification cloud conference edge freelance Freelancer Hardware home office InfoPath Intune Knowledge licensing Microsoft Microsoft 365 News Office Office 365 Personal development Power virtual agent Private security SharePoint SharePoint designer SharePoint online Software SQL server upwork Windows Windows 365 yammer

Footer

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2022 Tomasz Szulczewski