UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Access In A Sharepoint World, Any Version    
 
   
ghubbell
post Dec 11 2011, 04:45 PM
Post #1

UA Administrator
Posts: 3,712



December 11, 2011
e’re pleased to announce publication of a new, first-of-its-kind, book on Access 2010 and SharePoint 2010.
UtterAccess members and administrators Ben Clothier and George Hepworth have teamed with Tim Runcie, a former Access MVP and current Project MVP, to write “Microsoft Access in a SharePoint World”. Tim’s company, Advisicon, is publishing the book.
MASW covers the essentials of working with Access 2010 and SharePoint 2010 to create data-driven, web-enabled databases that run in the browser from a SharePoint Site. The goal was to place Access in context within the SharePoint world, so the book includes additional discussions about the other wonderful tools SharePoint brings to the table: project management, document management, and team collaboration.
MASW assesses the suitability of Access as a web or client solution in a SharePoint world and shows how they are a natural fit.
MASW also addresses design considerations that may challenge experienced developers designing a Access web application for the first time.
MASW discusses using Access as a client to SharePoint data, which offers several advantages, such as working offline, seamless synchronization, and a high level of integration. The book also addresses the ramifications of choosing SharePoint as a data source and the difference between SharePoint's architecture and ODBC data sources.
Finally, MASW offers a brief glimpse into using SharePoint tools such as SharePoint Designer and InfoPath and manipulating the SharePoint object model with SOAP and JavaScript to make your Access on SharePoint databases more professional, and conclude with a discussion of security and deployment.
For more details or to buy the book, you can visit the Advisicon store store. Tim has offered discount of $10 off to the first 10 buyers—use coupon code "save10bucks".
Congrats Gents!
Gord
Go to the top of the page
 
+
theDBguy
post Dec 11 2011, 04:51 PM
Post #2

Access Wiki and Forums Moderator
Posts: 57,581
From: SoCal, USA



Ben, George, and Tim:
ongratulations on the publication of your book!
Sounds like it would be a great addition to anyone's library.
Cheers
Go to the top of the page
 
+
argeedblu
post Dec 12 2011, 05:37 AM
Post #3

UA Forum + Wiki Administrator
Posts: 13,054
From: Sudbury, Ontario, Canada



Congratulations George, Ben, and Tim.
eorge, if it is written as well as Grover Park George on Access, the new book will be eminently readable, and eminently informative for its targeted audience.
Glenn
Go to the top of the page
 
+
jleach
post Dec 12 2011, 06:06 AM
Post #4

UtterAccess Editor
Posts: 8,051
From: Staten Island, NY, USA



Gentlemen, congrats on the publication. As many hours that I spend browsing shelves in our local bookstore, I have yet to see one that is devoted specifically to Access and Sharepoint collaboration. While I don't know Tim, I couldn't think of two more qualified people for this topic than Ben and George.
think a much needed informational gap has just been filled. No doubt your documented experience will prove invaluable to those looking to work Access on a cloud.
Congrats again,
Go to the top of the page
 
+
BananaRepublic
post Dec 12 2011, 09:44 PM
Post #5

Admin under the bridge
Posts: 1,138
From: Banana Republic



Thank you, Jack, but I feel obliged to point out that we're certainly not the only qualified people. We've been extremely fortunate to have the privilege of Jeff Conrad and Albert Kallal review the book for us. Frequent visitors to UA have benefitted from their expertise as well. Their feedback was invaluable and I hope it shows in the final product.
Go to the top of the page
 
+
jleach
post Dec 13 2011, 06:53 AM
Post #6

UtterAccess Editor
Posts: 8,051
From: Staten Island, NY, USA



Two names that have been rightly engraved in the list of Access's Best of the Best. All the better! ticons/default/thumbup.gif" style="vertical-align:middle" emoid=":thumbup:" border="0" alt="thumbup.gif" />
Go to the top of the page
 
+
GroverParkGeorge
post Jan 5 2012, 11:07 PM
Post #7

UA Admin
Posts: 22,264
From: Newcastle, WA



So far as I know, it's only being sold on the Advisicon website at the moment.
Go to the top of the page
 
+
dg_moore
post Jan 16 2012, 10:59 AM
Post #8

UtterAccess Addict
Posts: 158



This is hands-down the best reference book I've ever purchased, and that's a LOT of books. Well-written, understandable, and directly targeted at moving Access from the client to the web. If you're going to purchase just one book on this topic, this is the book to buy!
Go to the top of the page
 
+
BananaRepublic
post Jan 16 2012, 11:48 AM
Post #9

Admin under the bridge
Posts: 1,138
From: Banana Republic



dg_moore -
'm so gratified to hear that the book was of use to you and more importantly that it was accessible. I'll say that it was NOT easy to keep it approachable, given the natural complexity of SharePoint + web architecture and the change of paradigm.
If I may, what would make the book better?
Go to the top of the page
 
+
jleach
post Jan 16 2012, 12:02 PM
Post #10

UtterAccess Editor
Posts: 8,051
From: Staten Island, NY, USA



I can attest. Having had the book around for a few weeks, I just finally started getting into it over this past weekend. While I haven't undertaken any sharepoint/web db projects yet, I have an "invested interest" in them (I will be using them at some point).
rom an experienced "classic" Access developer's point of view, the book is particularly helpful in letting us know how to approach the scenario of utilizing sharepoint and web design. It makes clear that a different approach is a requirement, and further goes to explain in good detail how we must adjust our approach, why we must adjust our approach, and helps much in explaining and overcoming what would often be considered less than stellar practices for traditional Access (RDBMS practice as well, not just Access). This alone would be very difficult without some hand-holding.
The book touches on all points regarding design practice, from conceptual to task-based.
Additionally, we get a much needed introduction to SharePoint, from the Access developers point of view. SharePoint is a vast tool, and an Access developer trying to find pertinent information on what it means to us online or through other usual venues will have a very difficult time with this. The book does a great job aquianting us with those portions of Sharepoint that we need be concered with.
All in all, I give the book a shining 5 stars. The information is invaluable and cannot be found elsewhere. Though I must admit I found the price to be a little more than what I'm used to, the content is simply amazing. I'd easily put it in with my top 5 reference books I've purchased, and I have a bookshelf full of them.
And I'm pretty critical when it comes to this stuff...
A must have for anyone looking to move to web databases. The authors have smoothed the wheel so we don't have to.
Go to the top of the page
 
+
Squire4Hire
post Jan 20 2012, 11:41 AM
Post #11

UtterAccess Guru
Posts: 894
From: North of the 49th Parallel



Just ordered it an madly looking forward to it!
've taken on some development work with Access and Sharepoint at work and I've been looking for a good reference to dive into.
Thank you for sharing your knowledge!
Go to the top of the page
 
+
BananaRepublic
post Jan 21 2012, 01:07 AM
Post #12

Admin under the bridge
Posts: 1,138
From: Banana Republic



Awesome! When you get it and have derived into it, do feel free to post back with comments/feedbacks -- we're always interested in how we can improve the book.
Go to the top of the page
 
+
GroverParkGeorge
post Jan 21 2012, 01:25 PM
Post #13

UA Admin
Posts: 22,264
From: Newcastle, WA



Thanks, and please do let us know where we you see places we can improve or expand it.
Go to the top of the page
 
+
cms8220
post Feb 13 2012, 04:20 PM
Post #14

New Member
Posts: 1



Hello,
I am interested in the new book on Access 2010 and Sharepoint 2010 "Microsoft Access in a Sharepoint World". I currently do charting in Access through "Reports" and I have attempted to figure out how I can connect to the report/chart in Access to display it in Sharepoint. Does the book address this? Today, we have multiple access databases that feed data to the web...we are looking to see if Sharepoint can support what we need.
Is the coupon code for the book (save10bucks) still valid?
Thanks
Cheryl
Go to the top of the page
 
+
GroverParkGeorge
post Feb 13 2012, 09:41 PM
Post #15

UA Admin
Posts: 22,264
From: Newcastle, WA



Welcome to UtterAccess.
quot;I have attempted to figure out how I can connect to the report/chart in Access to display it in Sharepoint."
I'm not sure that's feasible. MASW is primarily about using Access 2010 to publish browser-enabled databases to SharePoint 2010. Note that this capability was introduced in the 2010 version.
Tell us a bit more about this comment.
"we have multiple access databases that feed data to the web"
How does that work now?
If the coupon code is still on the site, I would expect them to honor it.
Go to the top of the page
 
+
Scott_Hall
post Nov 6 2013, 10:06 AM
Post #16

UtterAccess Enthusiast
Posts: 73
From: Vancouver, WA



I'm interested in the book, but from the ToC it seems to only have a single chapter on web databases...can anyone who has the book comment? I don't mind spending the $75 clams if the book is greatly detailed with lots of good knowledge, but I've been burned on a few Access books that claimed web database info and provided about three pages worth.
Go to the top of the page
 
+
jleach
post Nov 6 2013, 10:23 AM
Post #17

UtterAccess Editor
Posts: 8,051
From: Staten Island, NY, USA



The entire book is about how to write a 2010 Web Database using Access as the front end to the Sharepoint List backend. I don't think you'll find it thin in related material... I have a copy, and can vouch for it.
'll note though, that if you haven't explored options in 2013 web databases, you might want to compare the differences between the two versions before making a decision and beginning development.
Cheers,
Go to the top of the page
 
+
BananaRepublic
post Nov 6 2013, 11:23 AM
Post #18

Admin under the bridge
Posts: 1,138
From: Banana Republic



Yes, Jack is correct here.
The fact is that 2010 web database need a fair amount of support from client and if we did a book exclusively on web database, it would be thin, indeed. We also felt it was more worthwhile to get into SharePoint side of things (e.g. we show you how to modify SharePoint forms so that it can be used in tandem with Access) and using Access client effectively.
All that said, the materials are still useful with Access 2013 *client*. I would be more inclined to recommend that you use 2013 web apps instead of 2010 web databases, which is much better architecturally anyway and has more of a future than 2010 web databases. Even so, the 2013 web apps currently still benefit from having client front-end to supplement some of workflow where it is not necessary to work in a web browser.
I hope that helps.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 20th August 2014 - 11:31 AM