Product Description
Here is the ideal resource for anyone who wants to get the most out of all the new and enhanced features Access has to offer. Learn the best methods for creating and customizing a new database, retrieving, processing, presenting, and exchanging data, securing your Access environment--and much more. ... Read more

Customer Reviews (4)

very practical abd easy to work with
this is an very well easy o read and easy to use yet powerful tool. practice files can be download from osborne so no cd is required. if you're a beginner you can pick and quickly - if your advanced there's meat there also. good examples.

decent reference
I usually rely on the O'Reilly guides for software, but could not find one appropriate to my level of experience in Access - I have used the program before to look up and modify data, but am now in charge of organizing a small database and developing some queries. This book did a good job of breaking down the process, BOTH through the *wizards* - of which Access has an inordinate number, AND without the wizards.

I was surprised to see such negative reviews - unless other reviewers are frustrated with the lack of VBA or SQL. But this doesn't claim to be a book about either of those languages. Maybe the fact is Access is just an unfriendly program, both to programmers (too many wizards) and non-technical users (for whom SQL=WTF).

The only major drawback to this book is that it does not provide an adequate introduction or overview to Access. If you have never used Access before, that would be a problem. Otherwise, it is a good basic how-to.

How to do Nothing with...
After reading nearly the entire book, I find that I now know how to navigate through the program and what to expect when I click a button.That's about the extent of my knowledge.The author's attempt to cover 'everything' about Access unfortunately results in a demonstration of what access' capabilities are and how to run a wizard.For instance, I know that 'criteria' can be used to filter information, but I do not have a very clear idea of what to actually put in the 'criteria' section in order to get what I want.As far as actually setting up a database complete with forms and reports - forget it.I can't even look at this book without getting angry.

don't waste your money
I'm going to be blunt: this book totally sucks.
I have found it to be completely useless, and after a month of hoping it would help me understand Access 2003, I gave up and bought the Access 2003 for Dummies All-in-one Desk Reference.
I want to clarify: I am not your average home user getting myself in over my head. I have 6 years of experience in the IT industry, covering everything from hardware, OS support, and web design/programming. I just have never dove in to the deeper levels of databases.
This "How to Do Everything"(a.k.a. How to get really frustrated) book is cryptic and poorly written. The instructions are barely even instructions at all, and nothing is explained in depth. When I frantically went shopping for better, in addition to the "for Dummies" book, I picked up an Amazon competitor's $10 publication "Access 2003 in Easy Steps"(hey it was 10 bucks, why not?), which is more of just an introductory crash course - yet has told me more than the entire "How to Do Everything" book.
I would STRONGLY recommend not only definitely NOT buying this book(except for use as maybe a monitor riser), but investing in the "Access 2003 for Dummies All-in-one Desk Reference." It is clear, concise, sensibly organized, and even includes some base level VBA programming - which is great for anyone who's ever programmed before, but hasn't had experience with VB or VBA in particular.
I can't believe this thing even got published. ... Read more

Product Description
Access 97/2000 Database Development Outside VBA emphasizes how to develop simple yet powerful databases without requiring the writing of Visual Basic for Applications code, but rather utilizing VBA code that is freely available. The authors present a step-by-step process for creating databases and database objects using the built-in features of Access, including its many wizards. Beginning with the creation of a database and tables, the book proceeds through developing a variety of queries; designing forms and reports for specific purposes; and automating databases. Strategies for avoiding errors, tips for debugging, and information on error handling are discussed, along with security issues such as using passwords and assigning permissions. Additionally, the authors introduce Data Access Pages, a new feature in Access 2000 with the combined functionality of both forms and reports that can be used on the Internet.

The appendixes include an errors table and documentation for the database included on the companion CD. ... Read more

Product Description
Access Power Programming can help the professional programmer become more proficient in many important areas including 32-bit OLE controls, OLE/DDE automation, and more using VBA, API calls, and insight on programming effective reports, forms and queries. No Access power user or programmer should be without this award-winning book. ... Read more

Customer Reviews (15)

Worth it for the query-by-form alone
Because it is so rarely mentioned in other books, the coverage ofhow you build a complex search form that allows users to dynamically construct their own queries makes this book worth the price.

There is also a lot of other coverage of advanced topics such as advanced queries, security, ActiveX controls, using the Windows API, custom error handling and on and on. I don't think any Access programmer who gets this book will be disappointed. I can't wait to see Access 2000 (or 2002) Power Programming.

Excellent book for serious programming, NOT for beginners
The code in this book and that supplied on the CD was marvelous at helping me solve some serious problems and questions I had in a major database last year. I found it easy to understand and it was real life! Not somethingsimple that no one can use.

I also emailed the author with a comment andreceived a reply within 2 days! I was impressed to say the least.

I teachVB And Access classes and tell all my advanced Access students (and thosein VB that use Access) to get this book.

Terribly disappointing!
I gave up on this book after going through the first 6 chapters. The writing style is terrible. The book is not designed to teach rather dumps out information in a disorganized fashion.You could go through this book,cover to cover, and still be unable to handle a simple Access project. It'sa waste of money.

For the experienced Access/VB Programmer only!
This book taught me how to do a lot, but also left me puzzeled on the very advanced stuff. On some things it tended leave out a step and seemed to just assume I knew what to do. But over all I did learn a lot. Whoever canmaster this book really will be a master of Access.

The best and most comprehensive book for Access Programming!
As a programming instructor, I am always on the lookout for books that go from beginning to intermediate (if not advanced) and yet stay simple.I find that this book works for all levels of my students and I haverecommended it to all my classes! ... Read more

Product Description

For introductory computer courses on Microsoft Access 2010 or courses in computer concepts with a lab component on Access.

Teach the course YOU want in LESS TIME! 

Product Description
Efficient, streamlined programming techniques are explored--techniques that Access developers of all levels will be able to use in their everyday database applications: VBA, Active Data Objects, OLE DB, ODBCDirect, Jet, Replication, and more. The CD-ROM contains many sample database applications and accompanying source code. ... Read more

Customer Reviews (8)

Author's Review
First, thank you for using my book.I sincerely appreciate your candid feedback, both pro and con.By far, the most positive reviews I have received have been from the beginner to intermediate level users/developer category.I did not always receive high marks from the advanced user/developer category.

Second, although I was humbled by the privilege of being chosen by a major publishing house from a long list of prospective authors, the book-writing experience taught me many useful lessons.Some of these lessons reflected well upon either myself or the publisher, some did not.In particular, I learned that my meager talents often fall far short of those that must have been possessed by any of the literary giants such as Hemingway, Steinbeck, or Lewis.

As an interesting sideline, In November 1996 I was chosen as the author because, of all the candidates, I was the one who flat-out said "No" when asked if I could write the book.Access 97 was still in BETA and would not be released until 1997, and Sams/MacMillan wanted to release Access 97 Programming Unleashed the same week that Access 97 hit the street.I told them that they were asking me to write an "expert" book about a piece of software that I had never used.The only caveat that I offered was that if it was a matter of learning the new material and blending it with past version experience, that I could do that as well as anyone else, so long as they adopted a more realistic deadline which gave me sufficient time to do so.I'm not sure which impressed them the most, my pragmatism or my gullibility.

Third, I was somewhat unhappy with the way that this book turned out.Although this can often be a perpetual mindset with me, in this case, the causes were more tangible.The "spine" of every book is the author's outline.A great deal of my time and effort was spent on developing a first-class comprehensive outline for an advanced programmer's reference that focused heavily on coding issues related to Access applications.A primary intention was to write a book that had all of the information in it that was usually conspicuously absent in technical publications.According to my book plan, this was to peak out at just over 1200 pages of in-depth coding techniques with examples, best practices, and some sample applications.I began writing in December of 1996, and, with the assistance of my friend and co-author, had completed roughly 2/3 of the volume by the beginning of March 1997.At this point, our publisher changed the direction and focus of the book to an intermediate level topical reference that would bridge the gap for beginning programmers.I threw out approximately 600 pages of my own work.With the last-minute assistance of contributing authors chosen by the publisher and with whom I had never worked, we began in earnest to write to the publisher's new outline in an effort to meet our deadline.The result was a loosely coupled compilation, not a comprehensive and contiguous volume.

Because of my stubborn dedication to our contractual deadline, I chose to allow the publisher to farm chapters out for rewrite to their stable of technical authors, rather than move the deadline back another two months.In retrospect, this may have been a mistake, as it compromised the technical and literary integrity that I tried to build in from the outset.It may have been wiser for me to have forced them to move the deadline, thereby giving me enough time to recast the errant sections to fit the new mold.It would have been a rough fight, and frankly, I'm not sure if I would have got my way in the end.In case any of you wonder why standard industry practice for publishers is to give advances to their authors, this is why.For those of you who want to write your own book, be mindful of the fact that the size of the advance should probably be commensurate with the amount that you would want them to pay in order to own you for the period of time it takes to give them their due.

Fourth, to all who were kind enough to praise this book, I offer you my gratitude and humble thanks.You made this book a success by separating yourselves from your hard-earned money.Very few technical books of this sort ever reach the 20,000-copies-sold mark, much less actually surpass it.The high-water mark is usually in the neighborhood of 10,000-copies-sold.You spoke your appreciation to me in a pragmatic way that was far beyond either my, or the publisher's expectations.Thank you for your support.

Fifth, to all who were kind enough to offer constructive critical review and advice, thank you.The ratio of books returned versus books sold is extremely low.This is not only substantive proof that dissatisfied readers were in the minority, it is also pragmatic evidence of the effectiveness of our book, despite the challenges we faced in writing it.If you didn't like my book well enough to have used it regularly, or dislike it enough to have returned it, then perhaps it will make a good doorstop on a windy day.Either way, you have my appreciation for your candid thoughts.

Lastly, thank you for the privilege of being able to find a place in each of your lives, even if that place is a 4" slot on a sturdy bookshelf.

Best regards and sincere appreciation,

Joe Rhemann

Not much programming in this programming book
I couldn't figure out who the audience for this book was.The first half of the book talks about things like forms and reports in a kind of general way, like the reader doesn't know anything about Access.Then the secondhalf of the book is suppossed to be about code, but there is very little ofit.What code there is is hard to understand unless you already have someVBA experience.

This book was written by several different people andit repeats things, so they apparently did't know what each other were doingand it just makes the book fatter (over 800 pages) without adding realcontent.

One good thing about the book is that it comes with a CD thathas two complete books (among other things) on it."Teach YourselfActiveX Programming in 21 Days" and "Visual Basic forApplications Unleashed."

Vague with few examples
I have dragged this book around with me for about a year and I have found it almost useless. I found Microsoft on-line help more informative!! The book tries to cover many topics, but winds up skimming over many areas Ineeded info on. The examples are not sufficient (most are too short to beuseful) ane the book is vague on many issues. I have a hard time even usingit as a reference. This book is just another door-stop! Beware....

Do Not Buy This Book ??????
This is the biggest book I read, however the least useful.The book spend so much time talking about things, however when it comes to examples, the book is no ware close to any reader expectations.

The examples on the CDand the examples in the text are not related.Many times the book wouldstart taking about something and suddenly the author would jump to anothersubject leaving the reader wondering what happened.

There is no in depthinformation about basic elements of Access.New users of Access who wantto become a sound Access developer will be very disappointed if they buythis book.

I feel that the author made the book so big and divided itinto many chapters to attract buyers and he got that.

If you aredeveloping an Access application, this is not the book you want to buy. Donot buy this book before seeing it and checking it out carefully otherwiseyou would be wasting your money and disappointed as I was.

Reader from Saudi Arabia, March 8, 1999
This is the biggest book I read, however the least useful.The book spend so much time talking about things, however when it comes to examples, the book is no ware close to any reader expectations.

The examples on the CDand the examples in the text are not related.Many times the book wouldstart taking about something and suddenly the author would jump to anothersubject leaving the reader wondering what happened.

There is no in depthinformation about basic elements or advanced of Access.New users ofAccess who want to become a sound Access developer will be verydisappointed if they buy this book.

I feel that the author made the bookso big and divided it into many chapters to attract buyers and he gotthat.

If you are developing an Access application, this is not the bookyou want to buy. Do not buy this book before seeing it and checking it outcarefully otherwise you would be wasting your money and disappointed as Iwas. ... Read more

Product Description

“Everything you need to master Access 2007 forms, reports, and queries.”

Customer Reviews (2)

Great Book!
When I first opened the book, I had an idea of what Access was, but that's about it.This book gives the reader a really understandable first look at how to use Access.I created two databases right after reading the book.One has been live for 11 months now, and the other 6 months.You can really use this stuff!

Great job
I got exactly what I was looking for and it is in very good condition. Thank you. ... Read more

Product Description

• Illustrates best practices for migrating Access databases to SQL Server.
• Carefully explains the differences between these two systems and the changes needed for a smooth migration.
• Assumes no prior knowledge of SQL Server.

Although Microsoft's Access Database is extremely popular and adequate for smaller scale applications, many Access developers are discovering that their applications need a more robust, enterprise-ready database system like SQL Server. This book is designed as a guide for Access programmers looking to make this transition, but who have little or no prior experience with SQL Server.

Veteran Author Russell Sinclair begins by discussing SQL Server, its architecture and application environment, and its differences from Access. He provides coverage of key topics including security, data storage, system databases, database objects, and queries.

After reviewing SQL Server, he covers core migration issues, frameworks for decision making, and the migration process itself. Specific topics include Microsoft's Upsizing Wizards, use of SQL Server's Data Transformation Services (DTS), options for connecting Access databases directly to SQL Server, differences and similarities between Tables and Views in Access and SQL Server, how to write SQL Server stored procedures, and how to convert existing Access reports to stored procedures. ... Read more

Customer Reviews (6)

Outstanding ... a "must" read!
This is a phenomenal book! Russell Sinclair has a gift for explaining new ideas and concepts in a way that everybody can understand."From Access to SQL Server" is written like someone was speaking to you and has just enough detail to be thorough.The flow is perfect. While SQL Server has later releases, the basics don't change and Russell empowers you with understanding.I have read other books on this subject and none is explained as well.Great job, Russell!

Good intro from XS to SQL but outdated!
The book deals mostly with SQL Server 6.5 and 7.0 and two chapters are dedicated solely for running these two systems. If you're interested in SQL Server 2000 and MS Access 2000 I recommend SAMS MS Access Developer's Guide to SQL Server or a similar book.

Very Good Start
This book is a good starting point as it is fairly small and provides relevent information about almost all aspects of upgrading an Access database to SQL server.I would recommend the book by Rick Dobson - Professional SQL server development with Access 2000 as a supplement to this book because the two books cover some different topics and the two perspectives are invaluable.

Gets You Up to Speed with Access Data Projects & SQL Server!
If you're trying to get into using Access Data Projects (.adp files) with Access 2000 and SQL Server data, this book is great in that most of the information you need is right here in one place. Russel has done us a great service, in that there is very little written about .adp's anywhere - for some reason Microsoft has kept it a "stealth" technology. I had to spend dozens of hours searching the web to come up with what's in Russell's book.

In addition, Russell includes pretty much everything you need to know to get a very good start on working with SQL Server. In fact, outside of advanced SQL administration, the book is very useful as a SQL Server developer's reference.

Russell has done a great job of packing a lot of useful information into this book. I've seen a number of books in the past few years with titles like "Client-Server Development in Access" that frankly were total flops. It's a hard thing to write about. But Russell has succeeded.

Don't migrate to SQL Server without this book!
This is a great book in that it targets a specific need, and fills it.

After developing in Access and programming with VBA for four years I thought I could handle moving to SQL Server without a great deal of assistance. Not true. There are lots of things different - lots of 'gotchas' that exist in SQL Server as do in every development environment. Learning them through trial and error is not a pleasant experience. This book help you avoid dead ends and move your project to completion as painlessly as possible.

In particular I appreciated the help with the decision to use ODBC or an Access project and how to approach stored procedures and use them to best advantage.

Rarely have I come across a book where just about every paragraph, no every sentence - contains useful information. This one does. It makes for kind of a dry writing style, but if you can picture having a highly experienced expert at your shoulder as you migrate your database from Access to SQL Server, whispering tips at the appropriate times, then you will know what this book can do for you. ... Read more

Product Description
Get ahead in the job market with MOUS (Microsoft Office User Specialist) certification. It provides a worldwide standard that accurately validates the proficiency of your skills and productivity in Microsoft Office applications. This In a Weekend prep series offers "Walk, Run, and Fly" exercise levels letting you gauge your mastery level of each skill. "Walk" exercises review each task within the lessons with complete step-by-step instructions. "Run" exercises are more difficult because they tell you what to do, but not how to do it. "Fly" exercises offer the greatest challenge by relating tasks from each lesson to more advanced tasks in Microsoft Access. ... Read more

Product Description
A personal procedural training system that gets users up and running as quickly as possible on applications in the next version of Microsoft Office. These are brand-new offerings in the best-selling STEP BY STEP series, whose total sales are rapidly approaching two million volumes. Readers don't have to worry about bogging down-they get just the information they need to get the job done. Modular lessons let users start wherever they want and learn at their convenience and their own pace.Amazon.com Review
Microsoft Access 97/Visual Basic Step by Step is ageneral introduction to Microsoft Access with a focus on Visual Basic.The book assumes prior Access experience, but does fully describe allof the features required to understand the Visual Basic programs. Thebook contains a set of powerful examples, such as how to build acustom Web browser with just a few lines of code and how to set up anautomated payment system. Happily, the book comes with a CD-ROM thatcontains all of the code described in the book. ... Read more

Customer Reviews (32)

DON'T HESITATE
Don't hesitate to buy this book. I bought this book as part of course being taught on VBA. Don't be scared that it is for Access 97 because the visual basic portion of Access has not been developed any further. This is the book to have. I am now a full time database programmer for a state agency and this is my desktop reference. BUY THIS BOOK!!!

great beginners book
This book does exactly what it claims to. It's a great book for beginners in access programming and vba. If you are an experienced vb programmer and are crossing over to access, I would say Access 97 Developer's Handbook would be a better buy.

Great Book to Learn Access VBA
I read this book last year and found it very instructive. It is easy to understand and contains very good explanations of the sample code. Very little or no typos or code errors, which always helps. The cd contains one or two useful applications in addition to the chapter databases. What I like about the book was that it makes use of the wizards up to the point where you you have to write code, which is a good time saver.

Access and VB
This is one of the finer books for the beginner VB programmer when using Access 97.All examples are geared for Access 97 and have relevance to what the new user of Access would want to know.Little or no experience in VB is necessary as this book will guide you step by step.Well worth the money!!

Absolutely Serves It's Purpose
As the title of my review states, this book is ideal if your situation falls into the following category: You have a solid amount of skill with Access (without VBA) such as action queries, subforms/reports, option/combo boxes, relationships, SQL, etc.You understand Access and can already build fairly advanced applications, however you want to goto the next level.The next level is VBA and here is where you go "under the hood".You will find out how to do basic procedures and how they work.You will be shown the light as to why event procedures are so critical to more advanced applications.After reading this book (and implementing what you learned into your own applications) you will be well prepared for intermediate level books. The book is extremely well written and is careful to make sure that the reader does not fall behind.I felt like the author actually cared about the learning process, and didn't just write a book to prove his own expertise (like many others).In summary, if you already know Access (sans VB), and would like to go "under the hood" to be on your way to becoming what I would consider an intermediate developer (i.e companies actually pay you [albeit moderately] for your Access skills, however it is not 100% of your job description) - buy this now. ... Read more

Product Description

For introductory computer courses on Microsoft Access 2010 or courses in computer concepts with a lab component on Access.

Teach the course YOU want in LESS TIME! 

The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clearly defined projects for students and a one-of-a-kind supplements package for instructors.

Product Description
This book provides you with the tools and techniques you’ll need in order to build more sophisticated solutions. After walking through the features of Access 2007 VBA, you’ll learn all about object-oriented programming and ADO. You’ll then progress to advanced VBA concepts such as working with external DLLs and using automation to control external programs. Plus, two comprehensive case studies presents you with the hands-on experience in building real-world solutions using the concepts covered in the book. ... Read more

Customer Reviews (6)

Access2007 VBA very helpful
Very well- written book, in friendly style. Minor criticism is too much advanced topic matter (custom class definitions, etc) with some of the basics skipped over. Very helpful to this beginner though, very useful.

Okay
The service was o.k, nothing to brag about.I received a response to my question after the item actually shipped(about 3 days).It would've been great to receive a response quicker.

Most of the codes in this book work for me
I think it is a very good book for the people has some experience in the object oriented programming. The most of the codes are working for me especially chapter 13 Case Study. I hope I can find the codes for chapter 14 from internet.

Most of the codes in the book do not work
It is absolutely unforgivable for this book to be published given that most of the examples in the book do not work. The public should demand its money.

Bad Code for Connecting Access to SQL
I bought this book to review VBA and learn how to connect Access to Microsoft SQL Server. The code for connecting Access to SQL is wrong, and there is no trouble shooting guide. I'm ready to throw this book away, and start over. ... Read more

Product Description

For introductory computer courses on Microsoft Access 2010 or courses in computer concepts with a lab component on Access.

Teach the course YOU want in LESS TIME! 

The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clearly defined projects for students and a one-of-a-kind supplements package for instructors.

Product Description
The big day is Monday -- the day you get to show off what you know about Access 2000 programming. The problem is, you're not really up to speed, which is why we created this Weekend Crash Course®. Open the book Friday evening and on Sunday afternoon, after completing 30 fast, focused lessons, you'll be able to jump right in and start programming. ... Read more

Customer Reviews (15)

No good
Learn Access in 15 hours?No way.The authors sound more like consultants trying to sell you a product than instructing you on the basic building blocks.I use Access 2000 for plenty of database development and wanted to delve deeper into the programming aspect.This book falls well short of the what the title presents.

Not what it claims
I was hoping this book would be what I was looking for. I already know Access basics but I don't really know much VBA programming. I was looking for a beginning VBA book, and I hoped this was it. I was wrong.

First of all, there is no way to do this book in 15 hours, so I resent the false advertising. But I could forgive that if the book took me step-by-step in some way that is understandable. It does no such thing.

I'll admit, the first 4 chapters were fine. They introduce VBA programming to the reader very nicely. But after that the programming examples jump to a height that was way beyond my understanding, becasue they don't explain simpler VBA programming concepts first. They just jump into relatively complex code examples and assume you can figure it out. No explaination. No "ok, now let's examine this code and see what's going on..."

And when the book gets to the chapter on DAO and ADO they really lost me, and yet the authors go on their merry way, somehow believing that the reader is having no trouble following them. Same with the chapter on bound forms vs unbound forms. I could understand the discussion, but they don't prepare you at all for the complex code that they display.

On the plus side, there is some good discussion. Not about code but about chosing between taking one approach over another. However, in the end that discussion is useless because you still can't figure out how to code in VBA.

The best fit for me
I found this book fit my need quite well. I am a senior level Oracle DBA, have some VB experience (not much), good at Oracle developer 2000 (form and report), meaning I have solid database knowledge, skills, and programming skills. What I want is to quickly become good at Access application development for some small Access projects, and this book gives me just what I need.

Poor effort
If you are looking for a quick introduction to Access VBA this is not the book for you. The title is a misnomer - it implies that it will get you up and running in a weekend. Wrong! As a previous reviewer has said, incredibly, it does not even have step by step exercises.

Also there is no overall structure to the book and it rambles in places.An example is that suddenly in Session (chapter) 8 they go on about programming calendars (made by the author's company) before they even start describing forms. Ah! you think maybe calendars are important in VBA, but no, they are hardly mentioned again.

The CD source code exercises are also poorly done. Not all of the source code covered in the book is on the CD.

Problem is the book misses its purpose. It is not a simple easy to follow introduction to Access VBA (as is implied). Yet it is not at the advanced or even intermediate level either. It's simply confused and confusing.

The writers have an unusual gift. They are able to make the simple complex. Save your money. I wish I had. (writer is an experienced sw developer.)

Content doesn't deliver what title promises
I'm an MIS professional. From this book's title and a quick browse at the bookstore, I thought it would be just what I needed to quickly come up on Access VBA, given my experience (including Access database design and Word VBA). Wrong! There's no way you could spend a weekend with this book and come away with anything more than theoretical knowledge, because there's no chance to apply anything.

Incredibly, there are no step-by-step exercises in the book and no practice databases on the CD. What looked, at first glance, to be exercises actually turned out to be just explanations in numeric form. Apparently, connecting the book's explanations with the CD's finished code (a time-consuming exercise in itself) is supposed to teach you all you need to know about Access VBA. I've taught enough computer courses to know it just doesn't work that way. ... Read more

Product Description
This book deals with the many issues involved in making the transition from Access to MS SQL Server. While Access (part of the Microsoft Office suite) has long been the small business database of choice, for enterprise level solutions SQL Server is required. Microsoft is actively encouraging users onto this more sophisticated platform by making Access 2000 compatible with SQL Server. This means solutions can be developed using Access and easily scaled up to the more powerful SQL Server when the need arises.Amazon.com Review
Professional SQL Server Development with Access 2000 shows the experienced database programmer or administrator how to take advantage of SQL Server using the built-in tools and capabilities of Access 2000. Filled with screen shots and plenty of practical advice for working with data, this book proves that Access is a great tool for getting the most out of SQL Server.

Usually associated with the lower end, Access 2000 has clearly grown up with the features that let you connect to SQL Server 7/2000, but with the convenience of a graphical tool. The book covers not only the features of Microsoft databases, but also how to rely on Access 2000 as your tool of choice for common administrative and programming tasks. Starting from table design, and the powerful database diagramming tools available in Access, you learn how to create effective database designs. And a full discussion of joins, indexes, constraints, views, and other advanced features make this book good for even more advanced readers. Besides admin functionality, there's coverage of VBA for database programmers, and T-SQL (Microsoft's version of SQL), including an excellent section on stored procedures and triggers.

While there's a lot of textual description in this book, there are also plenty of easy-to-understand screen shots, making this a useful resource to have at your desk. The graphics that detail the use of Access 2000 toolbars (which list the functions for each tiny button) are very good. The tutorial turns toward using Access 2000 features (forms and reports) to work with SQL Server data on the back end. Later sections examine the options you have for Web development, including Access's own Data Access Pages, data sheets, and a short introduction to using Active Server Pages on Microsoft IIS.

Reference sections of database security and upsizing older Access databases to SQL Server help round out this comprehensive and thoughtfully written book, which shows that Access 2000 really can let you access higher-end features on today's Windows platform. This book is perfect for any administrator or database programmer who wants to benefit from Access and SQL Server used together. --Richard Dragan

Topics covered:

• Introduction to relational databases and Access 2000
• Installing SQL Server 7/2000 and the Microsoft Data Engine (MSDE)
• SQL Server data types
• Creating and managing tables
• Using constraints
• Database diagramming in Access 2000
• Using SQL Server views
• Programming the SQL Distributed Management Objects (SQL-DMO)
• Stored procedures and triggers (including VBA and ADO programming techniques)
• Access forms (bound and programmatic access to form controls)
• Report design in Access 2000 (including conditional formatting and charts)
• Publishing datasheets for Internet applications
• Quick introduction to form design using Active Server Pages (ASPs)
• Data Access Pages
• Office Web Components (including spread sheets and charts)
• Programming SQL Server in Access (including basic ADO programming)
• SQL Server security tutorial
• Upsizing Access databases to SQL Server
• ADO 2.1 object model reference

Customer Reviews (9)

Very thorough
As a professional db developer, I found this book from Rick Dobson to be an excellent guide to getting you on your way with Access using SQL Server as the back end. This a rite of passage for many Access developers, like me, who find SQL Server kind of intimidating. Rick takes you through every step of the way very logically, preparing you for your next benchmark. He thoughtfully anticipates your next question with a paragraph or two that explains the reasons why you're doing what you're doing and how to do it. No smarmy digressions, bad jokes or confusing examples. Highly recommended reading for IT developers who want to get to the next level of database development. Great job, Rick!

Outstanding resource for making the transition to SQL Server
By far the best book I have seen regarding the difficulties encountered when moving an Access application to SQL Server.Until reading this book, I couldn't figure out why my Access queries that were 'converted' into Stored Procedures could not reference each other, why my forms would not work, why the tables weren't updateable (primary keys weren't copied during conversion), etc.
All these and many more perplexing issues are clearly explained here.For quickest results, read Appendices B and C, then the first 7 chapters before trying to convert your first Access database to SQL Server.

An invaluable guide to Access Projects
Having spent a number of years using Access to develop commercial solutions I recently moved on to Access projects and found this book a real find in getting up and running in a short space of time.Covering each topic in logical chunks I found it to be more than a good grounding in the subject.It is also well written in plain English and avoids the unnecessary complications that are often found in such books and I would thoroughly recommend it to anyone who is considering developing Access projects.

A professional "getting started" book
I have years of experience in programming but knew nothing about Access, SQL or VBA when I got my latest assignment.I can't stand those 1000 page books that want to hold me by the hand while I build some simple-minded application through eight chapters.I just need to know the basics quick and then see a few examples of some typical tasks.This book is just what I needed to quickly get me up to speed and working on my own application.There are a few minor differences with Access XP (like changed menus) so you'll need a good XP reference also.I recommend this book to any developer that needs to come up to speed quickly on either SQL or Access.

Full of typos
I just received this book so I cannot comment on its technical merits. However, I have noticed the book is littered with spelling errors and errors in general. Examples are (1) On page 11 "As but this architecture won't be specifically considered furhter".. and yes, I included all the spelling typos. (2) On page 19 "if you had an Access poject" instead of "project." Isn't this what spell checkers are made for? There is at least one more error that I glanced over but did not record. And I have only read to page 19! My experience has been when a book contains many typos then then code should be suspect. I hope not, because a good Access 2000 to SQL book is needed. Caveat emptor!! Paul ... Read more

Product Description
Build your own Access databases and applications—without any programming experience!

You don't have to do any programming to build an Access database or custom application. Find out how to design graphical front-ends, how to build tables to store your information, and how to link the two together to create a working application. The authors use their business experiences to give you real world examples for building Access applications.

This book uses a case study and step-by-step examples to build a Contact Manager application. You'll also learn how to:

• Create applications without having to write any programming code
• Design an application using a structured development methodology
• Build an information mode
• Build custom databases, reports, and tables
• Understand the basics of Windows interface design

Customer Reviews (1)

intuitive but need more work
Readers of both intermediate and beginner's level can easily understang this book through its detailed example. The book is well organized but needs some editing work to reduce spelling errors and other inconsistencies.work ... Read more

Product Description
An introduction to database software package Microsoft Access, with exercises from health, business, education, social science and government, and stressing the importance of planning what a database should do before starting to create it. ... Read more

Product Description
Written by a former member of the Microsoft Access and Visual FoxPro teams, this high-powered tutorial holds the key to unlocking the secrets behind Access 95. Readers will get special coverage of all of the new Windows 95 32-bit OLE contro-Provides Access programmers with valuable insight on Access objects, OLE automation, DDE, replication, API programming, and in-depth coverage of developing with Access for leveraging into the client/server arena-Includes tips and techniques for programming effective reports, forms, and queries-Start up includes logging out users from the back-end and programmatically repairing and compacting the back-end-CD-ROM includes valuable routines and code from the book that programmers can use in their own applications ... Read more