[AccessD] Sign up for an Office 365 Developer Site

 Thank you Darryl. 

So, when you have to handle (structured) data then you use SharePoint Lists?
Do you use MS Access with SharePoint Lists?
Have you ever met SharePoint Lists limitations -  http://msdn.microsoft.com/en-us/library/ff647105.aspx  - recommended max qty of items in a list to be 2000 (two thousands)?
Or SharePoint Lists usually keep unstructured data - whole data tables stored as CSV/text delimited files, XML, JSON...?
In this case is there a limitation on the size of the data stored in one SharePoint list item?

Please feel free to reply when you'll have time.

Thank you.

-- Shamil

Sunday, January 12, 2014 11:28 PM UTC from Darryl Collins <darryl at whittleconsulting.com.au>:
>Firstly, Office 365 comes in many flavours.
>
>The version we use has MS Office 2010 installed locally on everyone's PC, you can open up files using Office 365 on the web if you want, although there is far less functionality on the web version.  The main use of Office 365 is as a central document repository, Sharepoint (list based) Database and MS Exchange.
>
>It is not some much Office 365 itself, but more how you can seamlessly integrate everything together.  For example, Outlook with Onenote and then with Sharepoint, and then be able for any team member to access that information from any device, PC or Mobile.
>
>She runs a clinic for kids with special needs - has a lot of clients with kids with ADHD, Autism, social skill issues, that sort on thing. 
>
>In the past they all used take down notes on paper and file them in a big steel cabinet. 
>
>Now they put all their notes in Onenote, along with any other relevant docs, emails, notes from the school / parents etc on sharepoint and attach those docs to the client's record in the Sharepoint Client 'Database'.  Sharepoint can be set up as a simple database as well as document management.    These documents can be updated live and shared as well.
>
>You can also get sharepoint to set up processes - for example, you might need to follow up a client 2 months after a certain test - sharepoint will send an email to the consulting therapist, plus CC Monica to ensure it gets done.
>
>The upside is all this stuff is automatically backed up and if another therapist needs to see that client, they can instantly access all of the relevant records, even if they are offsite.  All of the data is updated live and can be edited on the fly.
>
>They use MS Exchange extensively, for email, tasks and calendars.   You can also set up 'resources' and 'rooms' in MS Exchange so a therapist can book a room and some piece of working kit and everyone else can see in the calendar that those resources are busy for that time space. 
>
>All of the therapist have different mobile devices (although they are mainly Apple or Samsung) and getting MS Exchange setup was painless and fast.  The girls all love it.
>
>In the past it was all a big mess - using a series of local databases, spreadsheets and paperlists with multiple copies on USB sticks etc.  Urrrrgh.
>
>
>
>-----Original Message-----
>From:  accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov Shamil
>Sent: Monday, 13 January 2014 10:07 AM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] Sign up for an Office 365 Developer Site
>
> Hi Darryl --
>
>Thank you for sharing your experience with SharePoint/Office 365.
>
>May I ask you to list briefly a few business use cases where your/your customers or your wife's businesses find Office 365 a "killer app"? FYI: I have ZERO experience with SharePoint/Office 365. 
>
>Thank you.
>
>-- Shamil