At some point in the life of your Microsoft Office Access application, you might want to consider upsizing to it to a Microsoft SQL Server database to optimize performance, scalability, availability, security, reliability, and recoverability.
In this step, you select the Access tables that you want to upsize to the SQL Server database.
Select the tables that you want to upsize, and then use the arrow buttons to move them to the Export to SQL Server list.
Alternatively, you can double-click a table to move it from one list to the other.
Important: Data for the reports generated by Office Share Point Designer 2007 is saved on the server on which the site is hosted.
To generate a Site Summary report for your site: You can generate reports that display all files, recently added files, recently changed files, or older files.
The single post on this blog that has, for several years now, consistently driven the most traffic to this site, is this one that I wrote almost three years ago.
The Site Summary report provides a high-level overview of your site, as well as links to more detailed reports.
For example, you can generate a Site Summary report like the one in the following illustration.