Special Edition Using Microsoft Office Access 2007

by Jennings, Roger

• ISBN13: 9780789735973
• ISBN10: 0789735970
• Edition: 1st
• Format: Paperback
• Copyright: 2007-04-27
• Publisher: Que Publishing

Summary

Covers all facets of Microsoft's powerful desktop database development and management tool.

Author Biography

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 .NETInsight 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 25 years 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

[e-mail].

Table of Contents

FM Introduction
Getting Acquainted with Access 2007
Access 2007 for Access 200x Users: Whats New	p. 19
Building Simple Tracking Applications	p. 71
Navigating the New Access User Interface	p. 115
Learning the Fundamentals of Access Databases
Exploring Relational Database Theory and Practice	p. 175
Working with Access Databases and Tables	p. 201
Entering, Editing, and Validating Access Table Data	p. 265
Sorting, Finding, and Filtering Data	p. 289
Linking, Importing, and Exporting Data	p. 319
Transforming Data with Queries and PivotTables
Designing Queries for Access Databases	p. 377
Understanding Access Operators and Expressions	p. 411
Creating Multitable and Crosstab Queries	p. 449
Working with PivotTable and PivotChart Views	p. 521
Creating and Updating Access Tables with Action Queries	p. 549
Designing Forms and Reports
Creating and Using Basic Access Forms	p. 581
Designing Custom Multitable Forms	p. 625
Working with Simple Reports and Mailing Labels	p. 699
Preparing Advanced Reports	p. 745
Adding Graphs, PivotCharts, and PivotTables	p. 769
Moving to Networked Multiuser Applications
Linking Access Front Ends to Access and Client/Server Tables	p. 811
Exploring Access Data Projects and SQL Server 2005	p. 867
Moving from Access Queries to Transact-SQL	p. 913
Upsizing Access Applications to Access Data Projects	p. 947
Table of Contents provided by Publisher. All Rights Reserved.