Special Edition Using Microsoft Office Access 2007
by Roger Jennings
List Price:
Our Price: $27.48
You Save: $22.51 (45%)
Availability: Usually ships in 1-2 business days
Buy Used: from $6.49 (click here)
Category: Book
See more book details and other editions
Book Summary Information
Author: Roger JenningsEdition: 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: If you want to learn how to develop in Access, this is NOT the book for you.
Summary: 1 Stars
I purchased this book for a project, based on the stellar reviews that had been posted. Unfortunately, well-meaning people provided the wrong types of reviews and I wasted money on this book!
So, to help you put into context my decidedly negative rating of this book, I will provide background on my roles here at work; I am primarily the chief data architect responsible for all things OLTP, OLAP and DSS related. That means I spend 90% of my time writing T-SQL and related code to manage and insert, update or delete rows into tables in databases on SQL Server systems.
The other 10% of my time is spent mostly on .NET development doing same - that means developing web based applications where data grids are populated with results from SELECT statements or, forms have been built that will insert, update or delete a row from a table based on input into the form.
Now that you know the context, my basic problem is this; we have departments that created Access 'applications' by this I mean they know enough to create a very simple application where a few dozen rows can be easily handled by the one person they deployed the 'application' to. Now, however, the application has outgrown the design, more powerful queries and forms management is required and most importantly, we need to move the tables to SQL for maintenance and performance considerations; breaking Access apart so multiple users can have the 'application' part and the 'database' part is on SQL Server.
Based on the book's title, and the stellar reviews, I purchased this book to help me tackle this project. That was 3 weeks ago, and while I admit I have not had the time to read the book cover to cover; that is precisely the point of this negative review. Because in order to know everything necessary to meet the title's claim to be the "only access book you will ever need" you have to thoroughly read and digest this book. You have to do this because unlike other books aimed at developer's, this book doesn't start with a 'basics' project and build out from there - it starts with the (in)famous Northwind and some templates to load - which I might do if there were lessons that would take me through the essential parts of what I need to know.
The layout of this book does not do this - so if you are looking for such a book; for example that would provide a section on "How to create a simple form, bind a combo box control to a table, and a query using a WHERE clause"; then this is not the book for you.
Go find another !!!
If on the other hand, your roles and responsibilities consist of a scope where you have say, 20 hours a week to just sit and read and learn and muse and play; then you might find this book quite handy. I find it a colossal waste of money and time trying to read through sections and glean enought to get anywhere.
And why would I even be looking for a book on Access development? Well, if Office had a decent BOL as does SQL Server, I probably wouldn't. But Office is sadly deficient in any useful how to instructions - either in help or online; instead, Office Product Management seems to believe, as does the author of the book if you just go through definitions and descriptions of what to do that is somehow sufficient... it decidedly is not.
Save your $$$ - look elsewhere !!!!
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
- Arts & Photography
- Biographies & Memoirs
- Business & Investing
- Children's Books
- Comics & Graphic Novels
- Computers & Internet
- Cooking, Food & Wine
- Entertainment
- Gay & Lesbian
- Health, Mind & Body
- History
- Home & Garden
- Horror
- Law
- Literature & Fiction
- Mystery & Thrillers
- Nonfiction
- Outdoors & Nature
- Parenting & Families
- Professional & Technical
- Reference
- Religion & Spirituality
- Romance
- Science
- Science Fiction & Fantasy
- Sports
- Teens
- Travel
Most talked about in Database Management Systems Books
SQL*Net TCP/ IP user's guide: Version 1.0by JaÌime Amadeo
Oracle Corp; Published: 1987; Unknown Binding; Book
PL/ SQL user's guide and reference: Version 2.2by Tom Portfolio
Oracle Corp; Published: 1995; Unknown Binding; Book
Oracle8i Data Warehousingby 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:
Introduction to Management of Laboratory Data: A Tutorial Approach Using Borland's Paradox Relational Databaseby C.N. Hegarty
Royal Society of Chemistry; Published: 1992-12-31; Hardcover; Book
Price in other shops:
DB2/ 400: Mastering Data Warehousing Functionsby IBM Redbooks
Ibm; Published: 1998-09; Paperback; Book
Price in other shops:
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 Designby Schneider
Prentice Hall; Published: 2003-09-04; Hardcover; Book
The Db Vista , A Database Management System for C Language Applications Software Developmentby Randall L. Merilatt
Raima Corp; Published: 1984-06; Hardcover; Book
Price in other shops:
Database 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)by Ramez Elmasri, Shamkant B. Navathe, Rajshekhar Sunderraman
Addison Wesley; Published: 2003-08-02; Hardcover; Book
Best price: $75.00
Price in other shops:
The Guru's Guide to Transact-SQLby Ken Henderson
Addison-Wesley Professional; Published: 2000-03-04; Paperback; Book
Best price: $28.00
Price in other shops:
Similar Books and other products
Access 2007 Bibleby 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: $19.37
Price in other shops:
Access 2007 For Dummiesby Laurie Ulrich Fuller, Ken Cook, John Kaufeld
For Dummies; Published: 2006-12-26; Paperback; Book
Best price: $11.92
Price in other shops:
Microsoft Office Access 2007 Forms, Reports, and Queriesby Paul McFedries
Que; Published: 2007-05-11; Paperback; Book
Best price: $23.99
Price in other shops:
Special Edition Using Microsoft Office PowerPoint 2007by Patrice-Anne Rutledge, Geetesh Bajaj
Que; Published: 2006-12-18; Paperback; Book
Best price: $16.00
Price in other shops:
Special Edition Using Microsoft Office Word 2007by Faithe Wempen
Que; Published: 2007-01-06; Paperback; Book
Best price: $25.49
Price in other shops:
Special Edition Using Microsoft(R) Office Excel 2007by Bill Jelen
Que; Published: 2006-12-16; Paperback; Book
Best price: $16.86
Price in other shops:
Access 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.61
Price in other shops:
Microsoft® 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:
Access 2007: The Missing Manualby Matthew MacDonald
Pogue Press; Published: 2007-01-05; Paperback; Book
Best price: $19.49
Price in other shops:
Microsoft® 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: