Microsoft Office Access 2007 Inside Out

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 [email protected].

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 [email protected].

John Viescas is the author of numerous books, including Microsoft Office Access 2003 Inside Out, Building Microsoft Access Applications and the coauthor of SQL Queries for Mere Mortals. He has written numerous articles for technical publications and has lectured at conferences and user group meetings around the world. He has been recognized as a Most Valuable Professional every year since 1993 by Microsoft Product Support Services for his assistance on public support forums.

Jeff Conrad has written and assisted with technical articles on Access and created several Access add-ins given freely to the Access community. Jeff maintains a Web site with a wealth of information and resource links for those needing guidance with Access. He has been awarded Microsoft's Most Valuable Professional award for his continual involvement with the online Access community. He is very active in the Microsoft-sponsored Access public newsgroups and several other online forums where he is best known as the Access Junkie. In addition to his full time work, Jeff also creates Access database solutions for small businesses.