Overview

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.

Full Product Details

Author:   Jeff Conrad ,  John Viescas
Publisher:   Microsoft Press,U.S.
Imprint:   Microsoft Press,U.S.
Dimensions:   Width: 18.00cm , Height: 7.00cm , Length: 23.00cm
Weight:   2.174kg
ISBN:  

9780735623255

ISBN 10:   0735623252
Pages:   1488
Publication Date:   11 April 2007
Audience:   General/trade ,  General
Format:   Mixed media product
Publisher's Status:   Out of Print
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Table of Contents

Part 1: Understanding Microsoft Access Chapter 1: What Is Microsoft Access? Chapter 2: Exploring The New Look Of Access 2007 Chapter 3: Microsoft Office Access 2007 Overview Part 2: Building An Access 2007 Desktop Application Chapter 4: Creating Your Database And Tables Chapter 5: Modifying Your Table Design Chapter 6: Importing And Linking Data Chapter 7: Creating And Working With Simple Queries Chapter 8: Building Complex Queries Chapter 9: Modifying Data With Action Queries Part 3: Creating Forms And Reports In A Desktop Application Chapter 10: Using Forms Chapter 11: Building A Form Chapter 12: Customising A Form Chapter 13: Advanced Form Design Chapter 14: Using Reports Chapter 15: Constructing A Report Chapter 16: Advanced Report Design Part 4: Automating An Access Application Chapter 17: Understanding Event Processing Chapter 18: Automating Your Application With Macros Chapter 19: Understanding Vusual Basic Fundamentals Chapter 20: Automating Your Application With Visual Basic Part 5: Linking Access And The Web Chapter 21: Publishing Data On The Web Chapter 22: Working With Windows Sharepoint Services Chapter 23: Using XML Part 6: After Completing Your Application Chapter 24: The Finishing Touches Chapter 25: Distributing Your Application Appendix: Installing Your Software Part 7: Designing As Access Project Chapter 26: Building Tables In An Access Project Chapter 27: Building Queries In An Access Project Chapter 28: Designing Forms In An Access Project Chapter 29: Building Reports In An Access Project Part 8: Articles Article 1: Disigning Your Database Application Article 2: Understanding SQL Article 3: Exporting Data Article 4: Function Reference Article 5: Color Names And Codes Article 6: Macro Actions

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions