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
- 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.
About the Author
Jeff Viescas was 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 (http://www.AccessJunkie.com). He is the author of Microsoft Access 2010 Inside Out and co-authored the Microsoft Office Access 2007 Inside Out book with John Viescas. Jeff is currently employed by Microsoft as a Software Design Engineer in Test working with the Access development team.
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 Design Chapter 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 Design Chapter 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