Microsoft Access 2010 Bible

(Rick Simeone) #1

Part VII: Appendixes


1258


FIGURE B.6
The new Navigation Pane replaces the old Database window.

Publish Access to the Web


Starting with Access 2010 developers have the option of publishing a prepared Access database to
SharePoint services. Instead of simply sharing data with SharePoint users, the new feature actually
converts Access objects (tables, forms, and so on) to their SharePoint equivalents, and pushes the
objects to a SharePoint server. Users are then able to access the application through a URL, rather
than as a traditional file-based application.

Tables


A table is a table is a table, but new features make life easier and faster. Access 2007 and 2010
tables support rich-text formatting in memo fields and multivalue fields, as well as automatic for-
matting of data pasted from Excel. If you paste an Excel date field into a new table, Access recog-
nizes it and formats the field as the Date/Time data type. It’s a simple change, but it really does
help with initial table design.

Another welcome addition is the alternating color option in Access 2007 and 2010. Creating a
“green bar” look for your datasheets is now a snap and makes reviewing data and forms that much
easier and appealing for the end user.

50_475348-bapp02.indd 125850_475348-bapp02.indd 1258 4/1/10 2:01 PM4/1/10 2:01 PM

Free download pdf