Microsoft Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)

Learn everything you need to know for working with Microsoft® Office Access 2007--from the inside out! This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds for using Office Access 2007--all in concise, fast-answer format. Whether you are upgrading from Office 97 or Office 2003, you'll be able to dig in to the work-ready resources that help you take your Access 2007 experience to the next level. This information-packed complete reference shows you how to get the most out of Access 2007 and find out what's new. You will learn how to design more-efficient databases, streamline data entry, find the information you need, and work with tools to produce effective forms, reports, and queries. In addition, you'll begin to explore strategies for database design and advanced table design. Plus, you'll get an easy-to-use companion CD packed with custom resources and a fully searchable eBook. With INSIDE OUT, you get all muscle and no fluff!

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® for Applications
• Customize the Office Fluent Ribbon
• Explore using XML and Windows® SharePoint® 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® Product Guide eReference and other eBooks

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

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 Provides an overview of the features and functions of the program, discussing such topics as building queries, importing and exporting data, creating reports, securing a database, and distributing an Access application.