We don't believe in brain dumps. We are a certification website dedicated to providing answers to your questions about mcad, mcsd .net, mcdba, mcsa, and mcse information, requirements, books, exams, and training to help you earn your Microsoft certifications.
Save money using this special offer discount voucher coupon code on your Microsoft Certified Professional exams from Pearson VUE testing exam centers Save on your Microsoft Certification
Exams with this discount voucher coupon code!Click here to find out how to save money.		 MCSE exam discounts, MCDBA exam vouchers, MCSD .NET coupon codes
View my shopping cart containing certification books View My Shopping Cart
Certification resources including books, exam notes, training courses, training centers, bootcamps, and study websites.
No braindumps, just a wealth of information.
MCSE MCSA MCSD .NET MCAD MCDBA Training Centers
MCSE information, MCSE requirements, MCSE benefits, MCSE exams, MCSE questions, MCSE answers, MCSE study guides, MCSE help, MCSE bootcamps, MCSE training, windows 2003 exams
MCDBA information, MCDBA requirements, MCDBA benefits, MCDBA exams, MCDBA questions, MCDBA answers, MCDBA study guides, MCDBA help, MCDBA bootcamps, MCDBA training, SQL Server 2000 examsMCSD .NET information, MCSD .NET requirements, MCSD .NET benefits, MCSD .NET exams, MCSD .NET questions, MCSD .NET answers, MCSD .NET study guides, MCSD .NET help, MCSD .NET bootcamps, MCSD .NET training, ASP .NET exams, VB.NET exams, C# exams
MCSA information, MCSA requirements, MCSA benefits, MCSA exams, MCSA questions, MCSA answers, MCSA study guides, MCSA help, MCSA bootcamps, MCSA training, windows 2003 system administrator study notes
MCAD information, MCAD requirements, MCAD benefits, MCAD exams, MCAD questions, MCAD answers, MCAD study guides, MCAD help, MCAD bootcamps, MCAD training, windows 2003 certification exams
Click To View Larger Picture Microsoft Access Developer's Guide to SQL Server
by Andy Baron, Mary Chipman
List Price: $39.99
Our Price: $27.99
ISBN: 0672319446
Publisher: SAMS (13 December, 2000)
Edition: Paperback
Sales Rank: 3,465
Average Customer Rating: 4.83 out of 5
05
Buy now directly from Amazon.com
Purchase this book, safely and securly from the largest book dealer on the Internet, Amazon.com
VUE Voucher Number, Save money on all your Microsoft Certification Professional (MCP) Exams taken at Pearson VUE examination testing centers. No catch, 100% legitimate. Click to get the Voucher Number ( Promotion Code, Coupon Code ).

Customers Reviews:
Rating: 5 out of 5
05
Super Book - Take my word on it!
I have been an Access developer since 1.1 (1993). I have bought many a book over the years. Some good, some bad. This book, however, is super! It is designed totally with the Access developer in mind. All of the questions that popped into my head seemed to be answered in practical terms chapter by chapter. The organization is terrific and the flow is second to none. The topics that are worth repeating are repeated while others are left for a one-time only view. The writing is easy to digest, powerful and very explanatory. The pictures are all also very helpful. You can tell the writers paid attention to every line they wrote. But they also inject a human kind of writing style which keeps things interesting throughout.

In addition to a thorough discussion on SQL Server security vs. Access security, data conversion, upsizing, etc., the book covers the differences among MDWs, MDEs, ADPs and ADEs beautifully and it addresses scenarios for when to use stored procedures, server functions, views, etc and with great attention to detail. The chapters ADO vs. DAO and on T-SQL are well written too. Later the book even goes into simplifying building multi-tier apps with Access as front end, VB-based COM+ components in the middle and of course, SQL Server sitting in the back. And just when you think the last chapter will be a letdown as many last chapters are, it wows you with an incredible amount of insight into how to optimize, backup and perform other settings in SQL Server.

If you are a serious Access developer like me, and are timid about moving full force into SQL Server, then this is the book for you! I recommend it highly!

Rating: 5 out of 5
05
Other Books are "Streets", this one is a "Highway"
In the last 18 months I have spent time and money reading a dozen of books in order to acquire the necessary knowledge to migrate from Access to VB/SQL Server. I've tried the enclosed code and learnt many things.
However, until three days ago I didn't know "how" and "when" migration would happen.
I've read this book in 3 days and only now I know I will start tomorrow!
In every book I read I found something helpful, but this one is simply a highway leading you to the right place.

Chapter 11 is impressive. Only after reading those ninety pages I can say that I know the difference between MDBs and ADPs. I mean when and how to use each of them, which problems I'll encounter choosing MDB or ADP, which limitations, etc.
When and how to use DAO, ADO or ODBC, how to mix them in the same application using stored procedures at the server level.
Chapter 14 on n-tier apps is just a bible to me. This is not a reference on SQL Server or Access, but if you want to know how to migrate from Access to SQL Server, what are the differences that you, as a programmer, must know, when and how to use remote data or local data, how to build a 3-tier app, you can't miss it.
I don't know if I'll switch to VB or I'll continue using Access as a front-end.
What I know is that also if I decide to switch to VB I will keep this book on my desk all the time.
Thanks to both for this wonderful job.

Rating: 5 out of 5
05
Very good book
In October 2000 I had to create a reliable Access / SQL-Server project but I did not find any useful documentation. A few months later I found this book and gladly it shows the same techniques I developed. If anyone tells you to migrate Access tables to SQL-Server read this book first !!! One remark though: the authors suggest to use Stored Procedures wherever you can. Using Views for Select queries is faster and you can put the SQL-statements in your VBA-code.

Similar Products:
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM)
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM)		 Microsoft Access Projects with Microsoft SQL Server
Microsoft Access Projects with Microsoft SQL Server		 From Access to SQL Server
From Access to SQL Server
SQL: Access to SQL Server
SQL: Access to SQL Server		  
Please note: Checkout and payment processing is done safely and securely through Amazon.com.
Prices (as shown) are subject to change without notice and cannot be guaranteed.
Email this page to a friendEmail this page to a friend Correction/Comment/Suggestion Regarding This PageCorrection/Comment/Suggestion Regarding This Page?
©2003 CertificationWorks.com  Privacy Policy | Terms of Use | Contact Us
Microsoft Corporation in no way endorses or is affiliated with CertificationWorks.com.  All trademarks displayed on this website are trademarks of their respective owners.