to this level, I've mentioned constructing regular Accessibility client-side databases and run because of some of the new equipment and approaches that happen to be out there. This represents a very important part in the work done in Access 2007, but it is only one part. In addition, we've done a lot of work to make it easy to build client-server databases against Windows SharePoint Services. Doing this allows users who don't have the skills or privileges to be SQL Server DBAs to still get the manageability and stability benefits of storing data on the server, while retaining the ease of use of Accessibility. This is a significant long-term bet for Access, and the level of server functionality can be expected to continue to grow in the future. I'll be describing Accessibility 2007's SharePoint functionality over several posts, and will start with an overview of the server itself. Services Overview
is becoming increasingly well known, but is new to many Access developers. At the top level, it is simply a set of services that runs on top of Windows Server. It is shipped on the Office schedule, but it is included with Windows Server (i.e. if you have server, you can freely download the SharePoint bits). SharePoint provides the server cornerstone to the Office System, and SharePoint functionality appears throughout the Office customer apps. SharePoint is designed to be a very horizontal technology,
microsoft office 2010 activation, applicable to all Office users,
windows 7 x64 key, and not limited to large organizations. We'd expect that eventually anyone with a file server, will eventually move to SharePoint, and those without servers will be able to take advantage of services like Office Live. There is an enterprise-focused SharePoint server, called SharePoint Portal Server, that runs on top of Windows SharePoint Services (WSS) and provides additional functionality to large organizations. Entry 2007 runs on both, but with a few exceptions I'll call out,
Office Standard, all with the functionality described below works on WSS and is included in the base version of Windows Server. SharePoint Services is described more fully here, but for our purposes, we can think of WSS as being composed of two parts: a platform, and a server application built on that platform. The platform contains things like an authorization model, a set of collaboration services,
microsoft office Standard 2010 64bit, and flat file database (or "list") functionality this platform is highly programmable both directly and thru web services, and in 2007 will have a dedicated design tool called SharePoint Designer. The application then builds UI on top of that platform to enable a collaboration app. This app is designed to enable team collaboration out from the box, and contains lists for things like a calendar, tasks, issues, and documents. User interact with SharePoint directly as a result of the browser for adding or editing list items, uploading documents, or even modifying the site itself. quick walkthrough in the parts of SharePoint which can be most relevant to Entry (there's a lot of other stuff we won't go as a result of here, so if you're interested in SharePoint in general, please refer to the links above). Here's a picture of a demo SharePoint site: image to enlarge) on the Announcements title, takes you to the default view on the Announcements lists, called the "All Items" view. If the all items view doesn't meet their needs, users can build their own custom views in the browser, choosing columns, column order, setting filters, and so on. The All Items view for our demo Announcements list looks like this: image to enlarge) addition to the default view, each list has a single-item view and a single-item edit form. The single item view looks like this: image to enlarge) the single item form looks like this: image to enlarge) notice above that SharePoint has support for rich text, complete with in-browser instruments for formatting, as well as the ability to copy / paste from other apps. 2007 users can also use the Entry Datasheet to edit list items in the browser as a result of a grid,
microsoft office Home And Student 2010 64bit, which allows quicker editing for multiple items. The grid looks like this: image to enlarge) a new list is also done by way of the browser, and the user can select from a variety of built-in list types or create a custom list. The custom list creation UI looks like this: image to enlarge) columns is done after the shell for the list is created, by way of the "List Settings" UI, where you can choose data types, defaults, and so on: image to enlarge) with the lists created shows up on the "List of Lists", which prevents orphaned content: image to enlarge) addition to the very basic list functionality described above, SharePoint provides a number of other features that help users. You can turn on version history for list items, allowing you to see who made each change and when, and roll back those changes if desired. In addition, deleted items land in a "Recycle Bin" and can be easily undeleted. Here's what the recycle bin looks like: image to enlarge) Time
SharePoint team collaboration app and SharePoint platform provide basic in-browser database functionality - there's a place to store data and simple forms and reports. Of course it lacks many on the things that make Access so powerful (relationships, remote data, logic) but it adds some things which might be also useful to database authors (server manageability, recycle bin, versioning). In the next posts, we'll explore moving Access database to the SharePoint server and discuss generating apps that take advantage in the best with the rich-client and the rich-server.