Skip to content

Microsoft Access 2010 in Depth

Spend $50 to get a free DVD!

ISBN-10: 0789743078

ISBN-13: 9780789743077

Edition: 2011

Authors: Roger Jennings

List price: $29.49
Blue ribbon 30 day, 100% satisfaction guarantee!
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Customers also bought

Book details

List price: $29.49
Copyright year: 2011
Publisher: Pearson Education, Limited
Publication date: 12/28/2010
Binding: Paperback
Pages: 1056
Size: 6.00" wide x 9.00" long x 1.75" tall
Weight: 3.432
Language: English

Roger Jennings is an author and consultant specializing in Windows database applications. He was a technical beta tester for all nine editions of Microsoft Access, SQL Server 6.5, 7.0, 2000, and 2005, every release of Visual Basic since version 2.0, as well as Windows 3.1 and all subsequent Microsoft Windows operating systems. He also was one of the founding members of Microsoft's former Access Insiders group. Roger's books have more than 1.25 million English copies in print and have been translated into more than 20 languages. He is the author of Que's "Special Edition Using Microsoft Access "titles for Access versions 1.0, 1.1, 2.0, 95, 97 (first and second editions), 2000, 2002, and 2003, and "Platinum Edition Using Access 97," He also wrote Que's "Special Edition Using Windows NT Server 4," "Special Edition Using Windows 2000 Server," "Unveiling Windows 95,"" Access Hot Tips," and "Discover Windows 3.1 Multimedia," For Pearson Education's Sams imprint, he has written two editions of "Access Developer's Guide "and three editions of" Database Developers Guide with Visual Basic," Additionally, he was the series editor for the" Roger Jennings' Database Workshop "titles. Roger is a contributing editor for the Redmond Media Group's "Visual Studio Magazine "and a columnist for the group's .NET"Insight "newsletter. Roger co-authored with Microsoft's Greg Nelson "A Client/Server Application: From Concept to Reality," a Tech*Ed presentation and white paper on Access 2.0 that was featured in the "Microsoft Developer Network News," An Access 2007 version of the application described in the white paper is located in the SEUA12 Chaptr15 folder of the accompanying CD-ROM. Roger has more than 25years of computer-related experience, beginning with his work on the Wang 700 desktop calculator/computer. He is a principal of OakLeaf Systems, a Northern California software consulting firm, and is the author of the OakLeaf Systems blog (http: //oakleafblog.blogspot.com). His OakLeaf U.S. Code of Federal Regulations (CFR) XML Web services demonstration project won the 2001 Microsoft .NET Best Award for horizontal solutions. You can contact Roger at Roger_Jennings@compuserve.com.

Introduction
Getting Acquainted with Access 2010
Access 2010 for Access 2007 Users: What's New
Building Simple Tracking Applications
Navigating the Fluent User Interface
Learning the Fundamentals of Access Databases
Exploring Relational Database Theory and Practice
Working with Access Databases and Tables
Entering, Editing, and Validating Access Table Data
Sorting, Finding, and Filtering Data
Linking, Importing, and Exporting Data
Transforming Data with Queries and PivotTables
Designing Queries for Access Databases
Understanding Access Query Operators and Expressions
Creating Multitable and Crosstab Queries
Working with PivotTable and PivotChart Views
Creating and Updating Access Tables with Action Queries
Designing Forms and Reports
Creating and Using Access Forms
Designing Custom Multitable Forms
Working with Simple Reports and Mailing Labels
Preparing Advanced Reports
Adding Graphs, PivotCharts, and PivotTables
Programming Databases with Macros
Automating Access Applications with Macros and Procedures
Emulating Table Triggers with Access Data Macros
Collaborating with Access Data
Linking Access Front Ends to Access and Client/Server Tables
Collaborating with Windows SharePoint Foundation 2010
Sharing Web Databases with SharePoint Server 2010
BONUS Chapters included in PDF
Working with HTML and XML Documents
Importing and Exporting Web Pages
Integrating with XML and InfoPath 2010
Creating Access Front Ends to SQL Server Databases
Exploring Access Data Projects and SQL Server 2008
Moving from Access Queries to Transact-SQL
Upsizing Access Applications to Access Data Projects and SQL Azure
Programming and Converting Access Applications
Learning Visual Basic for Applications
Handling Events with VBA and Macros
Programming Combo and List Boxes
Understanding Data Access Objects, OLE DB, and ADO
Upgrading Access 2003 and Earlier Applications to Access 2010
Appendix
What Was New in Access 2007 for Users of Access 2003 and Earlier
Glossary