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

3.5 avg rating
( 4 ratings by Goodreads )
 
9780615297927: 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.

"synopsis" may belong to another edition of this title.

About the Author:

Pindar's exciting relationship with databases started 18 years ago and since then his undergraduate and graduate studies, work, consulting, and research focused around data and data systems. Specifically, Pindar's major goal and continuous work is on connecting and showing the crucial role of databases to the business world. He firmly believes that a super efficient database professional needs to understand very well the needs of a corporation at the operational, tactical and strategic levels. Most importantly, how to integrate information from multiple heterogeneous data sources. Databases are not data storage systems; they are so much more than that. Pindar started with DBase III back in 1991, continuing with all versions of Access from early 1993 and working with MS SQL Server, MySQL, Oracle, and IBM DB2 for a number of years. He is still in love with all of them. After almost twenty years, he still works with data, information processing, integration, and dissemination.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Pindar E. Demertzoglou Ph.D., Ms. Melanie Votaw (Editor), Mr. Mihalis Galanis (Cover Design)
Published by AlphaPress (2009)
ISBN 10: 0615297927 ISBN 13: 9780615297927
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description AlphaPress, 2009. Paperback. Book Condition: New. Bookseller Inventory # DADAX0615297927

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 38.42
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

2.

Pindar E. Demertzoglou Ph.D.
Published by AlphaPress (2009)
ISBN 10: 0615297927 ISBN 13: 9780615297927
New Paperback Quantity Available: 1
Seller:
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description AlphaPress, 2009. Paperback. Book Condition: New. book. Bookseller Inventory # M0615297927

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 47.04
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

3.

Galanis, Mihalis/ Demertzoglou, Pindar E., Ph.d./ Votaw, Melanie
Published by AlphaPress (2009)
ISBN 10: 0615297927 ISBN 13: 9780615297927
New Paperback Quantity Available: 1
Print on Demand
Seller:
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description AlphaPress, 2009. Paperback. Book Condition: Brand New. 380 pages. 9.00x7.00x0.86 inches. This item is printed on demand. Bookseller Inventory # zk0615297927

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 41.20
Convert Currency

Add to Basket

Shipping: US$ 7.95
From United Kingdom to U.S.A.
Destination, Rates & Speeds

4.

Demertzoglou Ph.D., Pindar E.
Published by AlphaPress (2009)
ISBN 10: 0615297927 ISBN 13: 9780615297927
New Quantity Available: 1
Seller:
Nearfine Books
(Brooklyn, NY, U.S.A.)
Rating
[?]

Book Description AlphaPress, 2009. Book Condition: new. Shiny and new! Expect delivery in 20 days. Bookseller Inventory # 9780615297927-1

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 54.99
Convert Currency

Add to Basket

Shipping: US$ 4.00
Within U.S.A.
Destination, Rates & Speeds

5.

Demertzoglou Ph.D., Pindar E.
Published by AlphaPress (2009)
ISBN 10: 0615297927 ISBN 13: 9780615297927
New Paperback Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description AlphaPress, 2009. Paperback. Book Condition: New. Never used!. Bookseller Inventory # P110615297927

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 63.20
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds