Special Edition Using Microsoft Office Access 2007

  • ISBN13:


  • ISBN10:


  • Edition: 1st
  • Format: Paperback
  • Copyright: 2007-04-27
  • Publisher: Que Pub
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
  • eCampus.com Device Compatibility Matrix

    Click the device icon to install or view instructions

    Apple iOS | iPad, iPhone, iPod
    Android Devices | Android Tables & Phones OS 2.2 or higher | *Kindle Fire
    Windows 10 / 8 / 7 / Vista / XP
    Mac OS X | **iMac / Macbook
    Enjoy offline reading with these devices
    Apple Devices
    Android Devices
    Windows Devices
    Mac Devices
    iPad, iPhone, iPod
    Our reader is compatible
    Android 2.2 +
    Our reader is compatible
    Kindle Fire
    Our reader is compatible
    10 / 8 / 7 / Vista / XP
    Our reader is compatible
    Our reader is compatible
List Price: $49.99 Save up to $19.57
  • Buy New
    Add to Cart Free Shipping


Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.


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


Table of Contents

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

Rewards Program

Write a Review