bursa escortadana escortantalya escortelazig escortmalatya escortistanbul escortusak escortbilecik escorttokat escortadiyaman escortkirikkale escortsanliurfa escortsanliurfa escortsinop escortzonguldak escorttrabzon escortvan escortyozgat escortaydin escortcorum escorterzurum escortkutahya escortgiresun escortmaras escortisparta escortmanisa escortordu escortmugla escortmardin escortosmaniye escortsanliurfa escortsivas escorttekirdag escorttokat escortyalova escortafyon escortbalikesir escortcanakkale escortedirne escortmanisa escortantalya escortizmit escortbalikesir escortmugla escortmugla escorttrabzon escorthatay escortkonya escortdenizli escorteskisehir escortcanakkale escortbursa escortaydin escorthatay escortcorlu escortcorum escortburgaz escortordu escorterzincan escortrize escortedirne escortigdir escortcankiri escortmardin escortardahan escortkutahya escortelazig escortcesme escortburdur escortaksaray escortaydin escortsanliurfa escortvan escortelazig escortmardin escortordu escortkahramanmaras escortcorum escorterzurum escortnigde escortyozgat escortgiresun escortrize escortkastamonu escrotartvin escortkarabuk escortkaraman escortkirsehir escortkusadasi escortcankiri escortkirklareli escortkirikkale escortsinop escorttekirdag escortgaziemir escortkarsiyaka escortyalova escortamasya escorttrabzon escortisparta escortcanakkale escortadapazari escortbolu escortduzce escortbitlis escortbatman escorttekirdag escortusak escortusak escortnevsehir escortamasya escortmus escortvan escortyalova escortkastamonu escorttunceli escortnigde escortsiirt escortbingol escortkars escortkarabuk escortbayburt escortkaraman escorosmaniye escorkahramanmaras escortagri escortadana escortkusadasi escorttrakya escorterzurum escortankara escortizmir escortizmir escorteskisehir escortsakarya escortkonya escortdenizli escortankara escortsamsun escortkayseri escorthatay escortdiyarbakir escortkocaeli escortgaziantep escortbatman escort
beylikduzu oto cekici medyum tavsiyeleri papaz büyüsü baglama büyüsü etkili medyum durust medyum gerçek medyum ask buyusu kuşadası escort Kuşadası eskort Kusadasi escort Kuşadası escort Kusadasi escort Kuşadası escort Davutlar escort Güzelçamlı escort Soğucak escort Kadınlar Denizi escort Konya escort muğla escort bayan muğla escort bodrum escort dalaman escort datça escort fethiye escort kavaklıdere escort köyceğiz escort marmaris escort menteşe escort milas escort ortaca escort ula escort yatağan escort seydikemer escort gümüşhane escort hakkari escort hatay escort iskenderun escort antakya escort dörtyol escort ığdır escort ısparta escort eğirdir escort yalvaç escort istanbul escort ataşehir escort avcılar escort bağcılar escort başakşehir escort beşiktaş escort beykoz escort beyoğlu escort büyükçekmece escort kağıthane escort şişli escort üsküdar escort arnavutköy escort beylikdüzü escort esenler escort esenyurt escort maltepe escort ümraniye escort tuzla escort silivri escort izmir escort bayraklı escort foça escort gaziemir escort güzelbahçe escort karabağlar escort karşıkaya escort konak escort menemen escort narlıdere escort ödememiş escort seferihisar escort tire escort urla escort balçova escort aliağa escort bornova escort buca escort torbalı escort çeşme escort çiğli escort maraş escort kahramanmaraş escort afşin escort elbistan escort karabük escort safranbolu escort karaman escort kars escort kastamonu escort cide escort kayseri escort talas escort develi escort kayseri melikgazi escort kilis escort kırıkkale escort kırklareli escort lüleburgaz escort kırşehir escort kocaeli escort izmit escort gebze escort konya escort meram escort selçuklu escort kütahya escort tavşanlı escort malatya escort malatya battalgazi escort manisa escort manisa akhisar escort turgutlu escort manisa salihli escort mardin escort kızıltepe escort midyat escort mersin escort tarsus escort toroslar escort muğla escort muş escort muş bulanık escort nevşehir escort avanos escort ürgüp escort niğde escort osmaniye escort rize escort rize ardeşen escort sakarya escort sakaraya adapazarı escort samsun escort samsun ilkadım escort samsun atakum escort samsun bafra escort samsun çarşamba escort urfa escort şanlıurfa escort eyyübiye escort siverek escort viranşehir escort siirt escort sinop escort sinop boyabat escort sivas escort şırnak escort şırnak cizre escort tekirdağ escort çerkezköy escort çorlu escort tokat escort erbaa escort zile escort trabzon escort akçaabat escort sürmene escort trabzon of escort maçka escort tunceli escort uşak escort banaz escort eşme escort van escort tuşba escort erciş escort ipekyolu escort yalova escort yalova termal escort yozgat escort zonguldak escort ereğli escort bartın escort amasra escort adana escort aladağ escort seyhan escort yüreğir escort ceyhan escort adıyaman escort afyon escort afyonkarahisar escort bolvadin escort sandıklı escort ağrı escort patnos escort doğubayazıt escort 68 aksaray escort aksaray escort amasya escort merzifon escort ankara escort çankaya escort mamak escort etimesgut escort sincan escort keçiören escort antalya escort akseki escort aksu escort döşemealtı escort elmalı escort kemer escort konyaaltı escort korkuteli escort serik escort muratpaşa escort alanya escort kepez escort kaş escort manavgat escort finike escort demre escort ardahan escort artvin escort hopa escort aydın escort efeler escort germencik escort didim escort nazilli escort söke escort kuşadası escort balıkesir escort edremit escort bandırma escort ayvalık escort batman escort bayburt escort bilecik escort bozüyük escort bingöl escort bitlis escort tatvan escort bolu escort mengen escort mudurnu escort burdur escort bucak escort gölhisar escort bursa escort gemlik escort inegöl escort iznik escort kestel escort yıldırım escort mudanya escort bursa nilüfer escort bursa osmangazi escort çanakkale escort ayvacık escort biga escort çan escort eceabat escort gelibolu escort lapseki escort bozcaada escort çankırı escort çorum escort çorum sungurlu escort denizli escort acıpayam escort buldan escort honaz escort pamukkale escort karahayıt escort diyarbakır escort bismil escort diyarbakır yenişehir escort diyarbakır ergani escort diyarbakır kayapınar escort düzce escort edirne escort keşan escort uzunköprü escort elazığ escort erzincan escort erzurum escort yakutiye escort oltu escort palandöken escort eskişehir escort gaziantep escort antep escort nizip escort antep şahinbey escort giresun escort davutlar escort güzelçamlı escort soğucak escort kadınlar denizi escort kuşadası escort elden ücret escort bayan elden ücret escort escort bayan elden ödeme eskort
Access Services in SharePoint 2013…More ‘No Code’ Solutions | SharePoint Lumberjack

Access Services in SharePoint 2013…More ‘No Code’ Solutions

If you are like me, the thought of using Microsoft Access for ‘No Code Solutions’ in SharePoint 2013 probably elicited an eye-roll of sorts. We are talking about Access, the same Office application that created the dreaded .MDB files that have cluttered hard drives for years and caused many IT headaches. However, I thought I would give it a closer look after seeing some pretty impressive presentations of its use at this year’s SharePoint Conference and because I’m looking for what has become of ‘No Code’ or Composite solutions in SharePoint 2013.

For reference, Composite Solutions in SharePoint have traditionally been business solutions in SharePoint that leverage InfoPath Forms, SharePoint Workflows, SharePoint Designer, Business Connectivity Services and Reporting without the need for custom code development.

Like Excel Services, Visio Services and Word Services in SharePoint Access Services allows you to deploy Access Databases to SharePoint and allow users to access and use them without the need for the Desktop Client. The fact that you can host and use access applications on SharePoint as opposed to having an MDB on your hard drive or shared drive reason enough to give Access another look. Oh by the way, the Access Services App in SharePoint 2013 actually creates a new SQL database for each Access Services App that is added which provides much better scalability. Still not convinced? That’s OK neither was I but when you add in the new form designer, ability to run macros and the ability to use reporting tools like Power BI this becomes a very interesting solution for no-code solutions in SharePoint.

Let’s take a quick look at how it works…

To create an Access Services (assuming your SharePoint Admin has configured Access Services) simply ‘Add an App’ in the site where you want to host the App. Note: All Access Services Apps will appear in the Access Maroon color.

Add an App

In this example, I’m going to create a new App from scratch and use a predefined template once I have open the new App in the Access Desktop, but you can also upload an App package as the basis for your new App. App Packages are a Save Option in the Access 2013 Desktop.

Add an App screen

Once my new Access App is created we need to start adding tables to the using Access 2013 Desktop

Open in Access 2013

I can add tables manually or from existing sources, in this case I’m going to use a template for Asset Tracking.

Add Tables in Access

In the Asset are 3 tables (Assets, Categories and Employees) and a number of different forms. We can easily modify the forms to add additional fields, new buttons and new views all within the interface and they will render as a webpage when we access it in SharePoint.

Access Form Cretion

Here’s the same form in our SharePoint Online site.

Access Form in Browser

The bonus here is that we can now connect to Access Databases as a data source in PowerPivot and create PowerView reports. You will need to enable the Read-Only Connection in the Info backstage with Access 2013 in order to connect Excel to the data.

PowerPivot with Access Data

As you can see, there are a number of compelling features in Access 2013 and Access Services in SharePoint 2013 that appeal to the ‘no-code’ solution crowd; in particular, those that have a lot of experience creating business solutions in Access. The fact that it creates and stores the data in SQL, provides web access to forms, an easy to use form design interface and the ability to connect to the BI tools within Excel and SharePoint are major improvements. The most notable downside here is it creates a fairly ‘silo-ed’ solution that doesn’t allow for easy interaction with SharePoint lists, libraries and workflows which makes it’s overall usefulness a bit limited.


Leave a Reply

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