After entering my password and clicking OK, I'll see a dialog box that shows the various object being uploaded to SharePoint
Database ChangesThe first and most obvious change is that my tables now look different
Between them, you have most of the table design ability of the Table Design View, limited, of course, to those properties that SharePoint list support. Creating new objects like Queries, Forms, and Reports are more restricted.
Some queries like Aggregate Queries and Union Queries (to name just two) are not supported and forms can only be created in Layout View. Certain query, form, report, and code types are only supported in the "Client", that is, it will only run when used in Access as opposed to a Web Browser. This is useful in a Hybrid Web Application, but not in a Browser-Only application (which is what I'm hoping to develop here).
Many of the Database Tools are also absent in a Web Application. These include the Relationships Window, Performance Analyzer, Table Analyzer, and uploading data to SQL Server and SharePoint.
There are other differences that vary depending on the specifics of your database, but once you've uploaded your database to SharePoint, you need to be aware that some Access features are limited.
In my next post, (Viewing In Sharepoint), I'll look at the tables in SharePoint.