What’s New in Microsoft Access 2010?
Access 2007 offered very limited options for sharing databases on the web. In Access 2007, you could only publish lists and move an Access 2007 database to a document library. Access 2010 removes this limitation if you use a Microsoft SharePoint Server 2010.
Coupled with a SharePoint Server, you can create web databases and allow users to access a database in a web browser. Of course, you need Access 2010 to make changes to the database itself. However, Microsoft does warn that some features do not directly translate to the web and that some workarounds may be necessary.
Starting with Access 2007 SP2, users of Access could export data to a PDF (Portable Document Format) or an XPS (XML Paper Specification) file. Before Service Pack 2, users of Access 2007 could attain this capability with a separate download.
Starting with Access 2010, the ability to export directly to PDF and XPS files will be a built-in feature. Exporting data to these files allows users to print, post, or e-mail the data in a convenient format. This feature will also allow users to export forms, reports and datasheets to PDF and XML formats for easy distribution. In addition, by exporting in these formats, all formatting characteristics from the database will be retained without requiring recipients to install or own a copy of Access 20010 to print or read these files.
Access 2010 will allow users to connect to a web service as an external data source. To do this, users need a definition file that can be provided by the administrator of the web service. After installation of the definition file, it is possible for the Access 2010 user to link to the web service data as a linked table for manipulation, additions, deletions, and other database functions.
To make life easier for those users who use several features of Access often, Microsoft has integrated the Microsoft Office Backstage that is a part of the Microsoft Office Fluent User Interface.
Microsoft considers the Backstage to be a companion rather than a replacement of the Office Ribbon. On the File tab, users can access the Backstage View that contains functions that can be applied to an entire database. Examples include compacting, repairing, or even creating a new database from scratch. For convenience, the Backstage View is placed on the left-hand side of the screen with multiple tabs consisting of groups of functions and related commands.