Special Edition Using Microsoft Office Access 2007

Special Edition Using Microsoft Office Access 2007
by Roger Jennings

Special Edition Using Microsoft Office Access 2007
List Price: $49.99
Our Price: $27.48
You Save: $22.51 (45%)
Availability: Usually ships in 1-2 business days
Buy Used: from $6.50 (click here)
Category: Book
See more book details and other editions


(Click here)
Buy this book at online book store in your country
Canada | UK | Germany | France

Book Summary Information

Author: Roger Jennings
Edition: Paperback
Audio: English (Unknown); English (Original Language); English (Published)
Format: Deluxe Edition
Published: 2007-05-07
ISBN: 0789735970
Number of pages: 1488
Publisher: Que
Accessories:

Book Reviews of Special Edition Using Microsoft Office Access 2007

Book Review: Summary Review of Access 2007 Books
Summary: 5 Stars

This is the summary review of four Access 2007 books:
"Special Edition: Using Access 2007" (Special)
"Access 2007 Bible" (Bible)
"The missing Manual of Access 2007" (Manual)
"Access 2007 for dummies" (Dummies)

In sum, the special edition is the best. Buy the special edition. Even you are a fresh beginner on Access.

(My story? Well, I read the dummies first. Then looked at Manual, doesn't like it. So I got the bible. Still unsatisfied. Finally, I got the special edition.)I know some basics on Access 2003 and only use Access when Excel is not enough to handle my data. I started with "Access 2007 for dummies" and finished it in a couple of hours. Then I turned to "Access 2007 Bible" and "The missing Manual", the manual is the worst one and the bible just provides basics, well, maybe a bit more than, that the dummies book already covers.

The special edition provides more examples and detailed explanation on: Query, Forms, Reports, Pivot table.Not sure about the VBA part.

I also like very much the reader-friendly layout and enjoy its "what is in real world" sections at the end of several chapters.

This book also provides a good summary of basic database concepts like normalized, the importance of index, joints. The summary is very helpful especially you are a beginner.

The cover of the special edition claims that the special edition is the only Access book you need. Well, maybe not the only one, but if you have the special edition, you definitely don't need the Access 2007 Bible, The missing manual and the dummies book.

Summary of Special Edition Using Microsoft Office Access 2007

<>This book offers you comprehensive, information on using the new version of Access. Not only updated for the latest version, new chapters have been added on application automation with Access macros and collaboration with Microsoft SharePoint Team Server, both of which are hot topics.  All chapters are updated for the transition from Jet to the new Access database engine. Detailed, step-by-step instructions with icons guide you through Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports.

 

FM

Introduction

I Getting Acquainted with Access 2007

1 Access 2007 for Access 200x Users: What?s New

2 Building Simple Tracking Applications

3 Navigating the New Access 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 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 Moving to Networked Multiuser Applications

19 Linking Access Front Ends to Access and

Client/Server Tables

20 Exploring Access Data Projects and SQL

Server 2005

21 Moving from Access Queries to Transact-SQL

22 Upsizing Access Applications to Access Data

Projects

VI Collaborating with Access Data

23 Importing and Exporting Web Pages

24 Integrating with XML and InfoPath 2007

25 Collaborating with Windows SharePoint Services

VII Programming and Converting Access

Applications

26 Automating Access Applications with Macros 2007

27 Learning Visual Basic for Applications

28 Handling Events with VBA and Macros

29 Programming Combo and List Boxes

30 Understanding Data Access Objects, OLE DB,

and ADO

31 Upgrading 200X Applications to Access 2007

VIII Appendix

A Glossary

Index

Database Management Systems Books

Book Subjects
Most talked about in Database Management Systems Books
SQL*Net TCP/IP user's guide: Version 1.0 ImageSQL*Net TCP/ IP user's guide: Version 1.0
by JaÌime Amadeo
Oracle Corp; Published: 1987; Unknown Binding; Book
PL/SQL user's guide and reference: Version 2.2 ImagePL/ SQL user's guide and reference: Version 2.2
by Tom Portfolio
Oracle Corp; Published: 1995; Unknown Binding; Book
Oracle8i Data Warehousing ImageOracle8i Data Warehousing
by Lilian Hobbs PhD, Susan Hillson MS in CIS Boston University
Digital Press; Published: 1999-12-01; Paperback; Book
Best price: $69.46
Price in other shops: $69.95
Introduction to Management of Laboratory Data: A Tutorial Approach Using Borland's Paradox Relational Database ImageIntroduction to Management of Laboratory Data: A Tutorial Approach Using Borland's Paradox Relational Database
by C.N. Hegarty
Royal Society of Chemistry; Published: 1992-12-31; Hardcover; Book
Price in other shops: $180.00
DB2/400: Mastering Data Warehousing Functions ImageDB2/ 400: Mastering Data Warehousing Functions
by IBM Redbooks
Ibm; Published: 1998-09; Paperback; Book
Price in other shops: $33.00
Introduction to Programming with Visual Basic 6.0 with Database Management:with Website Development Applications with Modern Systems Analysis and Design: ... with Modern Systems Analysis and Design ImageIntroduction to Programming with Visual Basic 6.0 with Database Management:with Website Development Applications with Modern Systems Analysis and Design: ... with Modern Systems Analysis and Design
by Schneider
Prentice Hall; Published: 2003-09-04; Hardcover; Book
The Db Vista , A Database Management System for C Language         Applications Software Development ImageThe Db Vista , A Database Management System for C Language Applications Software Development
by Randall L. Merilatt
Raima Corp; Published: 1984-06; Hardcover; Book
Price in other shops: $15.00
Database Management Systems (McGraw-Hill International Editions: Computer Science Series) ImageDatabase Management Systems (McGraw-Hill International Editions: Computer Science Series)
by Raghu Ramakrishnan
McGraw-Hill Education (ISE Editions); Published: 1999; Paperback; Book
Fundamentals of Database Systems/Oracle 9i Programming (4th Edition) ImageFundamentals of Database Systems/ Oracle 9i Programming (4th Edition)
by Ramez Elmasri, Shamkant B. Navathe, Rajshekhar Sunderraman
Addison Wesley; Published: 2003-08-02; Hardcover; Book
Best price: $75.00
Price in other shops: $126.20
The Guru's Guide to Transact-SQL ImageThe Guru's Guide to Transact-SQL
by Ken Henderson
Addison-Wesley Professional; Published: 2000-03-04; Paperback; Book
Best price: $28.00
Price in other shops: $64.99
Similar Books and other products
Access 2007 Bible ImageAccess 2007 Bible
by Michael R. Groh, Joseph C. Stockman, Gavin Powell, Cary N. Prague, Michael R. Irwin, Jennifer Reardon
Wiley; Published: 2007-01-10; Paperback; Book
Best price: $18.93
Price in other shops: $49.99
Access 2007 For Dummies ImageAccess 2007 For Dummies
by Laurie Ulrich Fuller, Ken Cook, John Kaufeld
For Dummies; Published: 2006-12-26; Paperback; Book
Best price: $11.92
Price in other shops: $21.99
Microsoft Office Access 2007 Forms, Reports, and Queries ImageMicrosoft Office Access 2007 Forms, Reports, and Queries
by Paul McFedries
Que; Published: 2007-05-11; Paperback; Book
Best price: $22.78
Price in other shops: $44.99
Special Edition Using Microsoft Office PowerPoint 2007 ImageSpecial Edition Using Microsoft Office PowerPoint 2007
by Patrice-Anne Rutledge, Geetesh Bajaj
Que; Published: 2006-12-18; Paperback; Book
Best price: $16.00
Price in other shops: $39.99
Special Edition Using Microsoft Office Word 2007 ImageSpecial Edition Using Microsoft Office Word 2007
by Faithe Wempen
Que; Published: 2007-01-06; Paperback; Book
Best price: $23.82
Price in other shops: $39.99
Special Edition Using Microsoft(R) Office Excel 2007 ImageSpecial Edition Using Microsoft(R) Office Excel 2007
by Bill Jelen
Que; Published: 2006-12-16; Paperback; Book
Best price: $16.99
Price in other shops: $39.99
Access 2007 VBA Programmer's Reference (Programmer to Programmer) ImageAccess 2007 VBA Programmer's Reference (Programmer to Programmer)
by Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Armen Stein
Wrox; Published: 2007-05-14; Paperback; Book
Best price: $22.76
Price in other shops: $39.99
Microsoft® Office Access(TM) 2007 Step by Step (Step by Step (Microsoft)) ImageMicrosoft® Office Access(TM) 2007 Step by Step (Step by Step (Microsoft))
by Steve Lambert, M Dow Lambert
Microsoft Press; Published: 2007-01-31; Paperback; Book
Best price: $10.00
Price in other shops: $24.99
Access 2007: The Missing Manual ImageAccess 2007: The Missing Manual
by Matthew MacDonald
Pogue Press; Published: 2007-01-05; Paperback; Book
Best price: $19.49
Price in other shops: $34.99
Microsoft® Office Access(TM) 2007 Inside Out (Inside Out (Microsoft)) ImageMicrosoft® Office Access(TM) 2007 Inside Out (Inside Out (Microsoft))
by John Viescas, Jeff Conrad
Microsoft Press; Published: 2007-04-11; Paperback; Book
Best price: $29.29
Price in other shops: $49.99
Book store. Illustrated catalog of books on different categories