MS Office Access 2003 - Inside Out

Author(s): John L. Viescas
Publisher: MS Press
Year: 2004
ISBN: 0735615136
Language: English
File type: PDF
Pages: 1288
Size (for download): 20 MB

Access is just one part of MS’s overall data management product strategy. Like all good relational databases, it allows you to link related information easily—for example, customer and order data that you enter. But Access also complements other database products because it has several powerful connectivity features. As its name implies, Access can work directly with data from other sources, including many popular PC database programs (such as dBASE and Paradox); with many SQL (structured query language) databases on the desktop, on servers, on minicomputers, or on mainframes; and with data stored on Internet or intranet Web servers.

Access also fully supports MS’s ActiveX technology, so an Access application can be either a client or a server for all the other Office applications, including MS Word, Excel, PowerPoint, Outlook, FrontPage, Publisher, and the new MS OneNote.

Access provides a very sophisticated application development system for the MS Windows operating system. This helps you build applications quickly, whatever the data source. In fact, you can build simple applications by defining forms and reports based on your data and linking them with a few Visual Basic statements; there’s no need to write complex code in the classic programming sense. Because Access uses Visual Basic, you can use the same set of skills with other applications in MS Office or with MS Visual Basic.

MS Access can also act as a direct source of information published on an intranet or the World Wide Web. Data access pages let you quickly create and deploy intranet applications using pages that you create directly from Access much like you would create an Access application form. Data access pages can retrieve and update data stored either in an Access database or in MS SQL Server. MS Access 2003 includes new and enhanced features to allow you to export or import data in XML format (the lingua franca of data stored on the Web) or to directly link to an XML data source on a MS SharePoint Services Web site. You can export data (or subsets of data) stored in a MS Access or SQL Server database to a SharePoint server and then link those files back into your original application.

DOWNLOAD
http://rapidshare.com/file/3579469/off2003insout.rar

PASSWORD
ganelon