skip to content
Integrating Excel and Access Preview this item
ClosePreview this item
Checking...

Integrating Excel and Access

Author: Michael Schmalz
Publisher: Sebastopol, CA : O'Reilly, ©2006.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Database:WorldCat
Summary:
In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now.Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Schmalz, Michael.
Integrating Excel and Access.
Sebastopol, CA : O'Reilly, ©2006
(DLC) 2006275912
(OCoLC)61477793
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Michael Schmalz
ISBN: 9780596515539 0596515537 9780596553319 0596553315
OCLC Number: 607673250
Notes: Includes index.
Reproduction Notes: Electronic reproduction. [S.l.] : HathiTrust Digital Library, 2010. MiAaHDL
Description: 1 online resource (xiii, 216 pages) : illustrations
Details: Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.
Contents: Introduction to Access/Excel integration --
Using the Excel user interface --
Data access from Excel VBA --
Integration from the access interface --
Using access VBA to automate Excel --
Using Excel charts and pivot tables with access data --
Leveraging SQL server data with Microsoft Office --
Advanced Excel reporting techniques --
Using Access and Excel data in other applications --
Creating form functionality in Excel --
Building graphical user interfaces --
Tackling an integration project.
Responsibility: by Michael Schmalz.
More information:

Abstract:

In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now.Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful qu

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/607673250> # Integrating Excel and Access
    a schema:MediaObject, schema:Book, schema:CreativeWork ;
    library:oclcnum "607673250" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/45129125#Place/sebastopol_ca> ; # Sebastopol, CA
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/cau> ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://www.contentreserve.com/TitleInfo.asp?ID={A93DD981-EF0F-411D-8626-0EE518657177}&Format=810'" ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://www.contentreserve.com/TitleInfo.asp?ID={A93DD981-EF0F-411D-8626-0EE518657177}&Format=450'" ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://www.contentreserve.com/TitleInfo.asp?ID={A93DD981-EF0F-411D-8626-0EE518657177}&Format=50'" ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://www.contentreserve.com/TitleInfo.asp?ID={A93DD981-EF0F-411D-8626-0EE518657177}&Format=410'" ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://images.contentreserve.com/ImageType-100/2858-1/{A93DD981-EF0F-411D-8626-0EE518657177}Img100.jpg'" ;
    schema:about <http://experiment.worldcat.org/entity/work/data/45129125#Topic/business_data_processing> ; # Business--Data processing
    schema:about <http://id.worldcat.org/fast/888037> ; # Database management
    schema:about <http://experiment.worldcat.org/entity/work/data/45129125#Topic/microsoft_excel> ; # Microsoft Excel
    schema:about <http://id.loc.gov/authorities/subjects/sh85018264> ; # Business--Data processing
    schema:about <http://id.worldcat.org/fast/1371910> ; # Microsoft Access.
    schema:about <http://experiment.worldcat.org/entity/work/data/45129125#CreativeWork/microsoft_access> ; # Microsoft Access.
    schema:about <http://dewey.info/class/004/> ;
    schema:about <http://id.worldcat.org/fast/842283> ; # Business--Computer programs
    schema:about <http://dewey.info/class/005.7565/e22/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/45129125#Topic/business_computer_programs> ; # Business--Computer programs
    schema:about <http://id.worldcat.org/fast/842293> ; # Business--Data processing
    schema:about <http://experiment.worldcat.org/entity/work/data/45129125#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
    schema:about <http://id.worldcat.org/fast/1366659> ; # Microsoft Excel (Computer file)
    schema:about <http://id.loc.gov/authorities/subjects/sh85018263> ; # Business--Computer programs
    schema:about <http://experiment.worldcat.org/entity/work/data/45129125#Topic/computers_programming_languages_sql> ; # COMPUTERS / Programming Languages / SQL
    schema:bookFormat schema:EBook ;
    schema:copyrightYear "2006" ;
    schema:creator <http://viaf.org/viaf/21892850> ; # Michael Schmalz
    schema:datePublished "2006" ;
    schema:description "Introduction to Access/Excel integration -- Using the Excel user interface -- Data access from Excel VBA -- Integration from the access interface -- Using access VBA to automate Excel -- Using Excel charts and pivot tables with access data -- Leveraging SQL server data with Microsoft Office -- Advanced Excel reporting techniques -- Using Access and Excel data in other applications -- Creating form functionality in Excel -- Building graphical user interfaces -- Tackling an integration project."@en ;
    schema:description "In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now.Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful qu"@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/45129125> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/61477793> ;
    schema:name "Integrating Excel and Access"@en ;
    schema:productID "607673250" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/607673250#PublicationEvent/sebastopol_ca_o_reilly_2006> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/45129125#Agent/o_reilly> ; # O'Reilly
    schema:url "http://www.contentreserve.com/TitleInfo.asp?ID={A93DD981-EF0F-411D-8626-0EE518657177}&Format=410" ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=414880> ;
    schema:url "http://www.contentreserve.com/TitleInfo.asp?ID={A93DD981-EF0F-411D-8626-0EE518657177}&Format=50" ;
    schema:url "http://www.contentreserve.com/TitleInfo.asp?ID={A93DD981-EF0F-411D-8626-0EE518657177}&Format=450" ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=540456> ;
    schema:url "http://www.contentreserve.com/TitleInfo.asp?ID={A93DD981-EF0F-411D-8626-0EE518657177}&Format=810" ;
    schema:url <http://catdir.loc.gov/catdir/toc/fy0608/2006275912.html> ;
    schema:url "http://images.contentreserve.com/ImageType-100/2858-1/{A93DD981-EF0F-411D-8626-0EE518657177}Img100.jpg" ;
    schema:url <http://catalog.hathitrust.org/api/volumes/oclc/61477793.html> ;
    schema:url <http://books.google.com/books?id=ItFQAAAAMAAJ> ;
    schema:workExample <http://worldcat.org/isbn/9780596515539> ;
    schema:workExample <http://worldcat.org/isbn/9780596553319> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/607673250> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/45129125#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/45129125#Place/sebastopol_ca> # Sebastopol, CA
    a schema:Place ;
    schema:name "Sebastopol, CA" ;
    .

<http://experiment.worldcat.org/entity/work/data/45129125#Topic/business_computer_programs> # Business--Computer programs
    a schema:Intangible ;
    schema:name "Business--Computer programs"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/45129125#Topic/business_data_processing> # Business--Data processing
    a schema:Intangible ;
    schema:name "Business--Data processing"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/45129125#Topic/computers_programming_languages_sql> # COMPUTERS / Programming Languages / SQL
    a schema:Intangible ;
    schema:name "COMPUTERS / Programming Languages / SQL"@en ;
    .

<http://id.loc.gov/authorities/subjects/sh85018263> # Business--Computer programs
    a schema:Intangible ;
    schema:name "Business--Computer programs"@en ;
    .

<http://id.loc.gov/authorities/subjects/sh85018264> # Business--Data processing
    a schema:Intangible ;
    schema:name "Business--Data processing"@en ;
    .

<http://id.worldcat.org/fast/1366659> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://id.worldcat.org/fast/1371910> # Microsoft Access.
    a schema:CreativeWork ;
    schema:name "Microsoft Access." ;
    .

<http://id.worldcat.org/fast/842283> # Business--Computer programs
    a schema:Intangible ;
    schema:name "Business--Computer programs"@en ;
    .

<http://id.worldcat.org/fast/842293> # Business--Data processing
    a schema:Intangible ;
    schema:name "Business--Data processing"@en ;
    .

<http://id.worldcat.org/fast/888037> # Database management
    a schema:Intangible ;
    schema:name "Database management"@en ;
    .

<http://viaf.org/viaf/21892850> # Michael Schmalz
    a schema:Person ;
    schema:familyName "Schmalz" ;
    schema:givenName "Michael" ;
    schema:name "Michael Schmalz" ;
    .

<http://worldcat.org/isbn/9780596515539>
    a schema:ProductModel ;
    schema:description "electronic bk." ;
    schema:isbn "0596515537" ;
    schema:isbn "9780596515539" ;
    .

<http://worldcat.org/isbn/9780596553319>
    a schema:ProductModel ;
    schema:description "electronic bk." ;
    schema:isbn "0596553315" ;
    schema:isbn "9780596553319" ;
    .

<http://www.worldcat.org/oclc/61477793>
    a schema:CreativeWork ;
    rdfs:label "Integrating Excel and Access." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/607673250> ; # Integrating Excel and Access
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.