For AuthorsFor PublishersBookstoreAuthor ResourcesFAQsGPS Login
Comics & Graphic Novels
Home

Shop at BookSurge

Comics & Graphic Novels

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.

In Stock
Availability: Usually ships in 1 business days
Our Price: $31.00 & 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 2 reviews
 
 

Customer Reviews:
Average Customer Review:5.0
Write an online review and share your thoughts with other customers.

5Superb Job!  Sep 21, 2009
This guy knows how to pass on knowledge even on difficult topics. I always had trouble with many relationships, referential integrity,
and cascades. In this book these topics were made to seem easy and the cool thing is that he explains them from a technical and business point of view so that one knows how to apply them.

1 of 2 found the following review helpful:

5Excellent book!!! Answers to all of my questions!  Sep 14, 2009
What is amazing in this book is its organized approach in 30 chapters. Definitely, the author took his time writing it. Every topic is covered both in breadth and in depth to the point that even a novice can arrive at a professional level very quickly. I can really find the answers to my questions fast and efficiently with its two tables of contents. This is the first time I have seen two tables of contents in a book. Definitely a strong if not the strongest companion to anyone using Microsoft Access.

 
 
 
 
 
 
 
 
 
 
Web business powered by Amazon WebStore