For AuthorsFor PublishersBookstoreAuthor ResourcesFAQsGPS Login
Anthologies (multiple authors)
Home

Shop at BookSurge

Fiction

Anthologies (multiple authors)

Access 2007 Pure SQL: Real, power-packed solutions for business users, developers, and the rest of us

 
 
Access 2007 Pure SQL: Real, power-packed solutions for business users, developers, and the rest of us
View larger imageEmail a friend

 
 
 
 
 

Access 2007 Pure SQL: Real, power-packed solutions for business users, developers, and the rest of us

This book provides the database professional and power user with working solutions for daily business tasks. The goal has been to reduce needless writing and concentrate on the daily needs of database usage and development. An efficient database professional does not need a book to tell him or her how to execute a query or how many types of queries Access 2007 supports; the answers are a click away in the help file or online.

What power users and developers need is thought-out solutions to show them the way to achieve their difficult tasks without having to look around for hours, days, or sometimes weeks. In addition, they need a book to show them when something is possible, when it is not, how many ways exist to achieve a task, and which one is the most efficient. Furthermore, the table of contents is not arranged by topic (tables, queries, reports, etc) but by solution. The content of the book should be practical and the layout should help the professional find what he or she needs in seconds.

Learn how to use your databases for real business tasks Pindar has worked on hundreds of business databases and operational systems for the last 18 years. In this book, he provides actual scenarios and code you can use in your daily business situations. Actually, you will get many ideas of how to employ Access 2007 to get data in ways you were not aware it was possible. Some examples, especially in the beginning of each chapter are quite simple so that readers with less Access experience can follow and learn but they are definitely not simplistic.

Leave superfluous theory on the side and focus on the essence of your operations You might be taught a thousand pieces of theory and politically correct techniques on databases. In the end, what you will need is a way to accomplish your task. This book will show you exactly the concepts you should learn and expand on them in detail. Theory is present but only to support a practical technique; not for the sake of it.

Concentrate on holistic solutions and not clustered technical skills This book leaves behind the classical format of texts. Instead of providing multiple and isolated concepts, it combines the necessary techniques to arrive to a real world solution. For example, instead of just showing what a date function is, it demonstrates how it can be used in combination with clauses and other functions to obtain order processing cycle times or order fulfillment goals for your corporation. At the end of the day, when you read a book, you need to be able to use your knowledge to achieve a task.

The business table of contents You will find a novelty in this book which is its business table of contents. There are two tables of contents in this book. There is the classical one to find what you need on database concepts. However, there is also a business table of contents you can consult to find the business solution you need. For example, how to conditionally update product prices from multiple suppliers and by various percentages.

Use this book as a handy reference Finally, this book has been written with the idea of using it as a reference. You might need to flip its pages to check something simple like the correct use of quotes in criteria expressions or concatenated fields. Or you might need to check something more elaborate like how to use a subquery to manipulate data in one table based on the values of another table.

SKU: 

ACOUK_book_usedlikenew_0615297927

In Stock
Availability: Usually ships in 1 business days
Our Price: $29.95 & this item ships for FREE with Super Saver Shipping.

Note: Item may be sold and shipped by another company. Learn more.
Product Details:
Author: Pindar E. Demertzoglou Ph.D.
Paperback: 380 pages
Publisher: AlphaPress
Publication Date: July 27, 2009
Language: English
ISBN: 0615297927
Package Length: 9.84 inches
Package Width: 6.93 inches
Package Height: 1.1 inches
Package Weight: 1.59 pounds
Average Customer Rating: based on 11 reviews
 
 

Customer Reviews:
Average Customer Review:4.5 ( 11 customer reviews )
Write an online review and share your thoughts with other customers.

Most Helpful Customer Reviews

4 of 4 found the following review helpful:

5Definitely a valuable resource for using SQL in Access2007.  Dec 15, 2009
By twolittlehorses
I highly recommend this book for anyone having difficulty with SQL as a programming language in the business world. Dr. Pindar writes in a clear and precise manner. The book is for those that love Access 2007 but need to write SQL scripts for their job. One of the reviewer wrote that this book was a waste of time. I found this to be inaccurate. SQL is a simple programming language and strict adherance to syntax and puncuation is required for success.

Thank you, Dr. Pindar.

2 of 2 found the following review helpful:

5A refreshing read, well structured and easy to follow  Nov 17, 2010
By B. Welch
"One of the better books on SQL I have read. It doesn't try to teach you how to write a database. It's more of a useful reference guide. It shows you how to get your data to do what you want it to do, as well as how this is best achieved in any business application you may need to manage or implement changes to.

I found it a refreshing read, and it will be a useful reference guide for many years to come. Worth every penny..."

2 of 2 found the following review helpful:

5Author also provide database for earlier version of Access  Aug 31, 2010
By silverflute
I use much older version of Access at work and the author also provides the sample database compatible with my Access 2003 (It's important for me as I need the older version Access file to practice the book's SQL syntax).

Another amazing thing is the author answers your email! (When you go to the book's website, you get the author's email and that's how I got the book's sampledata in Access 2003 format)

1 of 1 found the following review helpful:

5All the Code works!  May 23, 2010
By Benjamin Stepper
"This is really a great book. I recently failed an interview with AT&T for a job using Access SQL extensively.
I don't think I'll be failing any more interviews involving Access SQL, at least not after I go through this book 2 or 3 times. It's really amazing how all the code works. Most programming books are speckled with errors."


1 of 1 found the following review helpful:

5Great Guide to SQL for Access 2007  Mar 27, 2010
By Access Programmer
The book is a well written guide to using the SQL language to build databases and manipulate data in Access 2007. The author explains not only the syntax of how to manipulate the data but also gives insights and examples as to how the manipulations are useful from a business perspective. I think the book is a great resource for anyone using SQL in Access 2007.

See all 11 customer reviews on Amazon.com
 
 
 
 
 
 
 
 
 
 
Web business powered by Amazon WebStore