Microsoft Office Access 2007 Inside Out
Published on 11. April 2007
Book
Mixed media product
1488 pages
978-0-7356-2325-5 (ISBN)
Description
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.
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.
More details
Series
Language
English
Place of publication
Redmond
United States
Illustrations
illustrations
Dimensions
Height: 230 mm
Width: 180 mm
Thickness: 70 mm
Weight
2174 gr
ISBN-13
978-0-7356-2325-5 (9780735623255)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
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.
Content
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