Microsoft Office Access 2007 Inside Out by Jeff ConradMicrosoft Office Access 2007 Inside Out by Jeff Conrad

Microsoft Office Access 2007 Inside Out

byJeff Conrad, John L. Viescas

Paperback | April 11, 2007

Pricing and Purchase Info


Earn 265 plum® points

Prices and offers may vary in store

Out of stock online

Not available in stores


You're beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2007—and challenge yourself to new levels of mastery!

  • Create tables that support your database design strategy
  • Import and link to data from spreadsheets, text files, databases, and other ODBC data sources
  • Build simple to complex queries to manipulate data
  • Learn advanced techniques for building and customizing user interface forms
  • Design attractive reports to calculate and analyze large sets of data
  • Automate your application with Microsoft Visual Basic(R) for Applications
  • Customize the Office Fluent Ribbon
  • Explore using XML and Windows(R) SharePoint(R) Services to create Web-based applications

    CD includes:

    • Fully searchable eBook—plus bonus chapters
    • Sample database applications—including query, form, and report examples
    • Articles from the experts: designing databases, understanding SQL, exporting data, and more
    • Links to demos, blogs, and user communities
    • References for finding Access 2003 commands in Access 2007
    • Windows Vista(R) Product Guide eReference and other eBooks

      For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Jeff Viescaswas awarded Microsoft's Most Valuable Professional award from 2005 to 2007 before joining Microsoft for his continual involvement with the online Access community. He maintains a Web site with a wealth of information and resource links for those needing guidance with Access ( He is the author of...
Title:Microsoft Office Access 2007 Inside OutFormat:PaperbackDimensions:1488 pages, 9.08 × 7.29 × 2.66 inPublished:April 11, 2007Publisher:Pearson EducationLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:0735623252

ISBN - 13:9780735623255


Table of Contents

AcknowledgmentsAbout the CDConventions and Features Used in This BookIntroductionPart 1: Understanding Microsoft AccessChapter 1: What Is Microsoft Access?Chapter 2: Exploring the New Look of Access 2007Chapter 3: Microsoft Office Access 2007 OverviewPart 2: Building an Access 2007 Desktop ApplicationChapter 4: Creating Your Database and TablesChapter 5: Modifying Your Table DesignChapter 6: Importing and Linking DataChapter 7: Creating and Working with Simple QueriesChapter 8: Building Complex QueriesChapter 9: Modifying Data with Action QueriesPart 3: Creating Forms and Reports in a Desktop ApplicationChapter 10: Using FormsChapter 11: Building a FormChapter 12: Customizing a FormChapter 13: Advanced Form DesignChapter 14: Using ReportsChapter 15: Constructing a ReportChapter 16: Advanced Report DesignPart 4: Automating an Access ApplicationChapter 17: Understanding Event ProcessingChapter 18: Automating Your Application with MacrosChapter 19: Understanding Visual Basic FundamentalsChapter 20: Automating Your Application with Visual BasicPart 5: Linking Access and the WebChapter 21: Publishing Data on the WebChapter 22: Working with Windows SharePoint ServicesChapter 23: Using XMLPart 6: After Completing Your ApplicationChapter 24: The Finishing TouchesChapter 25: Distributing Your ApplicationInstalling Your SoftwareIndex to Troubleshooting TopicsAbout the AuthorsChoose the Right Book for You