Finished Updating All 33 Chapters of “Microsoft Access 2010 In Depth”

Hooray! Yesterday, 10/1/2010, I sent the updated 53-page manuscript of Microsoft Access 2010 In Depth’s Chapter 3, “Navigating the Fluent User Interface,” and its 53 illustrations to Pearson Education’s Senior Acquisition Editor Loretta Yates (@loyates). (Chapters 1 through 3 were dependent on information from many of the other 32 chapters, so they were last in line for updating.)

Here’s the final Table of Contents from the Excel spreadsheet I use to track progress:

Microsoft Access 2010 In Depth

FM		Front Matter
0		Introduction
I		Getting Acquainted with Access 2010
1		Access 2010 for Access 2007 Users: What's New
2		Building Simple Tracking Applications
3		Navigating the Fluent User Interface
II		Learning the Fundamentals of Access Databases
4		Exploring Relational Database Theory and Practice
5		Working with Access Databases and Tables
6		Entering, Editing, and Validating Access Table Data
7		Sorting, Finding, and Filtering Data
8		Linking, Importing and Exporting Data
III		Transforming Data with Queries and PivotTables
9		Designing Queries for Access Databases
10		Understanding Access Query Operators and Expressions
11		Creating Multitable and Crosstab Queries
12		Working with PivotTable and PivotChart Views
13		Creating and Updating Access Tables with Action Queries
IV		Designing Forms and Reports
14		Creating and Using Basic Access Forms
15		Designing Custom Multitable Forms
16		Working with Simple Reports and Mailing Labels
17		Preparing Advanced Reports
18		Adding Graphs, PivotCharts, and PivotTables
V		Programming Databases with Macros
19		Automating Access Applications with Macros
20		Emulating Table Triggers with Access Data Macros
VI		Collaborating with Access Data
21		Linking Access Front Ends to Access and Client/Server Tables
22		Collaborating with SharePoint Foundation 2010
23		Sharing Web Databases with SharePoint Server 2010
VII		Working with HTML and XML Documents
24		Importing and Exporting Web Pages
25		Integrating with XML and InfoPath 2010
VIII		Creating Access Front Ends to SQL Server Databases
26		Exploring Access Data Projects and SQL Server 2008
27		Moving from Access Queries to Transact-SQL
28		Upsizing Access Applications to Access Data Projects and SQL Azure
IX		Programming and Converting Access Applications
29		Learning Visual Basic for Applications
30		Handling Events with Macros and Procedures
31		Programming Combo and List Boxes
32		Understanding Data Access Objects, OLE DB, and ADO
33		Upgrading Access 2003 and Earlier Applications to Access 2010
X		Back Matter
App A		What Was New in Access 2007 to Users of Access 2003 and Earlier
App B		Glossary
		Index

In the spirit of conservation, QUE minimized the number of trees cut down to publish this detailed book. Parts VII through X/chapters 24 through 33 and the appendices (in green-colored type) aren’t printed. Instead, they’re included in the PDF file that you can download (along with the sample code) from QUE Publishing’s Web site when you register your book. Electronic-only chapters cover less-widely-used technologies and those deprecated by Microsoft, such as VBA in favor of Access macros. The PDF includes all the book’s text and illustrations.

QUE also helps conserve your cash: The US list and Amazon prices for this edition are US$39.99 and US$26.99; previous editions were US$49.99 and US$31.99.

Alternatively, you can purchase the ePub version of the book, which works with all popular eBook readers. Details will follow.

Technorati Tags: Access 2010,Microsoft Access 2010,Web Databases,Access Web Databases,SharePoint Server,SharePoint Server 2010,Access Services