Amazon.com
Access Database Design and Programming covers a lot of ground quickly but lucidly.Steven Roman begins with a description of general principles of database design, then describes the "relational algebra" that defines the meaning of such operations as unions and joins, introduces SQL syntax, and finally dives into the details of using VBA (Visual Basic for Applications) to write Access code. The result is a single book that can teach you all the basics of building database applications in Access.Portions of the book are heavy with logical equations whose effects can be hard to visualize, but Roman's judicious use of sample data makes it much easier to follow the operations being described.Book Description
When using software products with graphical interfaces, we frequently focus so much on the details of how to use the interface that we forget about the more general concepts that allow us to understand and put the software to effective use. This is particularly true of a powerful database product like Microsoft Access. Novice, and sometimes even experienced, programmers are so concerned with how something is done in Access that they often lose sight of the general principles that underlie their database applications.

Access Database Design & Programming, 2nd Edition, an update to thebestselling first edition, features:

• A discussion of Access' new VBA Integrated Development Environment, which, for the first time, is the one used by Word, Excel, and PowerPoint
• An expansion of the discussion of the VBA language itself, in response to reader requests
• A discussion of Microsoft's latest data access technology, called Active Data Objects (or ADO), along with a discussion of Open Database Connectivity(ODBC), which is intimately connected with ADO

Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, this book focuses instead on the core concepts, enabling programmers to develop solid, effective database applications. As a result, important topics such as designing forms and reports, database security, database replication, and programming for multiuser applications are simply not discussed. This book is a kind of "second course" in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to successfully develop in the Microsoft Access environment. Anyone interested in learning Access in-depth, rather than just scraping the surface, will enjoy and immensely benefit from reading this book.

Although this book is really an introduction directed to intermediate Microsoft Access users who are novice programmers, it should appeal to all levels of Access developers. For novice programmers, it focuses on a key body of knowledge that is typically neglected, but is nevertheless essential for developing effective database applications. For intermediate and advanced developers, its treatment of database design and queries provides a handy treatment that otherwise has to be gleaned from relatively uninteresting textbooks, while its programming chapters constitute a handy reference to some basic operations that can be performed using DAO or the Access object model. ... Read more

Product Description
This is Dr. Eghosa Ugboma's second textbook on learning SQL programming using different versions of MS Windows operating systems and different versions of MS Access. Although, this book is written using MS Windows Vista and MS Access 2007, his first textbook teaches SQL programming using MS Windows XP and MS Access 2003. However, if you are running MS Windows 2000, MS Access 2002, and MS Access 2000, Dr. Ugboma's first textbook on learning SQL is perfectly suitable for those MS windows and MS Access versions. His first textbook ISBN is 1-4196-5358-X or 978-1-4196-5358-2. Both books contain lots of hands-on activities that make crossing over to Oracle, SQL Server, and other high-end SQL platforms easy. All the alternative methods introduced and used in both textbooks work perfectly in other SQL platforms. ... Read more

Product Description
Jump start SQL programming using MS Access, experience the powerful features of MS Access SQL, acquire the fundamental concepts of SQL, master the techniques of writing effective SQL statements, and build, through hands-on, the skills required to become a professional SQL programmer. Easy crossover to other SQL platforms.MS Access is an excellent tool for learning SQL, supports SQL programming to a very competent level,and is found in virtually all Windows-driven PCs, and as a result, no need to purchase expensive SQL software. Learning SQL using MS Access is intriguing.The only textbook that shows how to achieve DIVIDE operation in SQL environment, and explains and shows alternative methods for achieving results sets such as totals, subtotals, and grand totals. Textbook contains alternative methods that run perfectly in other SQL platforms and uses examples that are related to the topics discussed. Dr. Ugboma has taught database programming for many years. He has written database programs using Oracle, SQL Server, and MS Access SQL, and he is very much familiar with their similarities and differences. ... Read more

Book Description
Microsoft Access is the most popular desktop database in the worldtoday and its very popularity means that its security measures can beeasily compromised."Securing Your Microsoft Access Database" takes adifferent approach to all the other Access books in the market in thatit focuses from the start on all the issues that will help protectyour database.The book approaches protection and security from atask-by-task perspective and provides detail on all the little thingsthat when put together will make your database more secure.This willachieve things like keep your staff from looking at your salarytables,stopping your customers from looking at the design of yoursoftware that you distribute and helping you decide which securityoptions are worth doing and which generally a waste of your time.The book has an IT manager's overview on all topics so that managerscan assess the risk of different strategies.Where the topics are atan administrator's level, the book provides a visual step-by-stepguide to implementing and undoing the settings. Finally, as Garry isvery experienced in writing for developers, the book goes into thedetail of programming all types of security issues such as hidingtables as system tables, producing databases that password crackersoftware cannot crack (easily), backing up databases, menus, queriesand even user surveillance.Download Description

Product Description
Microsoft - Programming Microsoft Visual Basic .NE ... Read more

Customer Reviews (16)

Not as Advertised
I have been working in this profession for 30 years and have migrated from COBOL to VB-3, to VB-6, and now to VB.Net.The title of this book is "Programming Microsoft Visual Basic.Net for Microsoft Access Databases."
When I started reading the book it began with very basic VB for the first 128 pages.Then once you do get into the VB sections of the book, there is a lot of repetition and not all of MS Access/VB programming is covered.Everything is done using embedded SQL commands.No raw access to MS Access.Try and find an INDEX change,or a SEEK command.
Rick, you should publish a second book and finish the topic and send it to everyone who purchased this book free.

A book that does what it sets out to do.
As I read the review that compained about the heavy use of ADO rather than ADO.net in the first part of the book, it seemed to me that the reviewer missed what Dobson was trying to do. This book really teaches two subjects--VS.Net and ADO.Net as it applies to Access. I appreciated that he used the old familiar ADO while discussing the new, unfamiliar VS.Net, and then, when the reader should be comfortable with the first topic, began to teach the second. I think he did a good job of laying the groudwork for using Visual Studio.net before then introducing the complex topic of switching to ADO.net. I would recommend this book for anyone transitioning from VB or VBA to .net using Access databases.

Decent, but confusing.
I'm a brand new developer using VS.NET, and having never used Visual Studio before I've grown very tired of every single book on .NET
spending %60 of their time explaining how it was done in Visual Studio 6, and how it is done in Visual Studio .NET. This book isn't much
different except that I see a shocking amount of emphasis on the "old" ADO method of data access. In fact, if I read this correctly,
there is more written on ADO/ADOX than there is about ADO.NET.

This is about the 10th book on .NET that I've purchased and every one so far (especially those from MS Press) spend 2-6 chapters talking
about .NET, what it is and why is is so bloody terrific. Book authors, PLEASE, lets stop introducing and re-introducing the same stuff
in EVERY .NET book! Write a "Beginning .NET" for all that stuff and save your readers some time!

Overall my opinion is that this book is mediocre. What this book is is a general .NET book with an
emphasis on database programming (albeit with the "old" ADO stuff).

In short, I'm glad I bought it used for only $10.

Good transition from VBA to VB.NET
The target audience for the book is, quite simply, Access developers who are accustomed to VBA and/or VB 6.

This book serves a good purpose, as the .NET materials I have seen to date all refer to SQL Server in their examples; they acknowledge Access, but fail to show its uses. I am not crazy about seeing "old" technology such as ADO used in some of the examples, but for a book of this nature (transitioning between coding languages) I guess that is inevitable that some old/new information would be included at various points.

Do not purchase the book if you're intending to use the built-in VBA capabilities of Access or other Office applications -- that's strictly not covered. What you will find, though, is a good sense of how VB.NET operates on its own, and how to create applications that draw upon the data stored in your Access databases.

This should be a good base point for someone who's developed in Access, and wants to investigate moving forward; it should be a means to an end, rather than the destination itself. Additional reading on ADO.NET and classes will be helpful, I believe, to continue fleshing out knowledge to be truly effective in your work, but this book does a good job of introducting those concepts.

Security
Nice walkthrough of setting up database security (MDW file).Only reasonable source I found for this. ... Read more

Book Description
Database Access with Visual Basic's major emphasis is on solutions, not technology.Rather than rattling off a list of features, diagrams and acronyms, this book provides step-by-step examples of the most important techniques developers typically go through to create database applications.Learn how to design a database, build the user interface, write queries,and construct a three-tiered client server system based on ADO 2.0, RDO, COM, SQL Server orOracle. Find out "what's new?" in Visual Basic 6 as it applies to data access strategies.Receive more information on different types of SQL queries and differences between the Access and SQL Server dialects. ... Read more

Customer Reviews (61)

A Thin Reference For Growing VB Programmers
I worry that there may be multiple editions of this book; mine was published in 1999.ADO, the key database technology of VB6, isn't treated until Chapter 10, followed by a quick jump to IIS in Chapter 11.Had problems getting some of the examples to run; the website offered hasn't been up for quite a while.This isn't a bad VB6 database book, and in fact I'd recommend it for students developing their background in the historical development of Microsoft's Universal Database Access technology -- its presentation of the older technologies is great.This text won't, however, solve any problems you'll encounter trying to develop VB6 database applications.

Another must have
Jeffrey writes extremely well and the previous edition of this book was the definitive book on the subject.This wasn't quite as good and lacks a degree of detail that a professional developer could need if messing about with data access but don't let me sound as if I'm putting you off...its a must have on your book shelf compared to some of the junk written on this subject.

He's also unique amongst authors in that he actually replies to E-mails you send him...

A good starting
Even though this book is a little old, and still shows some already unused techniques and resources, as DAO, it brings a good starting for basical VB-60, and good ideas over database accessing, either local or remote. If you are thinking about starting, this book is fine. But, be sure, you will need other titles, when you intend to go deeper in the subject, or you need newer techniques, as ADO.

A great book! Yet not complete
What a wonderful book! You can't seriously start writing professional VB application if you don't have this book. Any intermediate user should get it ASAP. Keep in mind, it's not for learning VB, you should first get an introductory book for that. However, I can't give it 5 stars. First, the book's first printing is from Jannuary 1999, it favors DAO a lot more than ADO (which is Microsoft's actual leading technology in data access) and he consistly uses ADO with ODBC (which is a good way to slow down a perfectly running application). Good overviews offered regarding SQL Server and Active Server Page, but just overviews. Get it, read it, use it. After that your application will be much better and you'll know in which field of databases you want to focus. If you want DAO then you are fine. For ADO, ASP or IIS you'll need something for more advanced users.

great book
I often refer to this book when I need some assistance.It covers everything I need to know as far as what i'm doing, you couldnt ask for a better book, both as a learning tool and as a reference. ... Read more

Customer Reviews (7)

There is better one
Try Martin Fowler's Patterns of Enterpise Application Architecture.
It has much better coverage in more useful context.
Also you can look at Hibernate or iBatis project for real application
of these patterns.

Useful patterns and interesting concepts
The book presented 25 patterns grouped in 5 areas, decoupling (conceptual and architectural level), resource, input/output, cache and concurrency.

The most interesting patterns are in resource and cache. Decoupling and concurrency patterns (e.g., data accessor, active domain object, layers, transactions, optimistic/pessimistic lock etc.) are well known and the contents are a bit too light to be very useful, yet the concepts are giving readers some directions.

In resource patterns, some interesting patterns are presented, particularly resource timer automatically releases inactive resource, retryer enables fault-tolerance for data access operations.

In cache patterns, cache collector purges entries whose presence in the cache no longer provides any performance benefits; cache replicator replicates operations across multiple caches.

There are some areas to be improved, first, author should consolidate pattern names with other pattern authors, e.g., data accessor is also known as data access object, active domain object is similar to active record,paging iterator is close to value list handler (though value list handler is more decoupled from underlying data store), the point is, one of the important benefits and purposes for documenting patterns is to build common vocabularies among designers, using different names for same or similar patterns is defeating this purpose. The same pattern name should be used and may be presented as a variation of the original pattern.

Secondly, the examples given in the book is a bit too simple, sometimes, the examples might not justify or validate the interface abstraction is generic enough to handle real world problems, so some tweaking and modification to the pattern would be expected.

Overall, the book is well organized, and contents are easy to follow, most patterns come with class diagrams and sequence diagrams. Good for designers who want to decouple data access from rest of the application, utilize cache to minimize data access and thus boost application performance, manage resources in an efficient and leaking-proof way.

Great book on persistence theory
I'm in the middle of developing yet another persistence framework for a client, having done it a couple of times before. Each time I refine my ideas about how to do it. I must say that this book has a thorough examination of issues and certainly food for thought as well as answers to a couple of questions I've had.

However, I wouldn't say it's a complete design (which it doesn't claim to be). I still found myself picking and choosing which patterns to use as is, which to modify to my liking, and which to discard.

Also, I was left with the impression that the book didn't give enough coverage to handling collections of objects. The material is mostly geared toward working with a single object, which is understandable. I just think it would have been helpful to have more discussion about handling collections. For example, what should happen when you request to load an object, but the criteria you passed to the loading mechanism results in data for more than one object being retrieved from the database? Hand back the first object? Raise an exception? If it's covered in the book, I missed it.

Further, I would like to see more discussion about WHEN to refresh an object from the underlying database and when to save to the database. I always struggle with that timing issue. Having studied EJB, I like how entity beans keep your bean in synch with the underlying database. But the EJB container intercepts calls and makes those things happen. When coding the persistence layer myself, that's not an option. So, again, this is something I'd like to see some light shed on.

Overall, though, a great book if you're interested in reading up on persistence layer patterns.

Good design pattern book in data access !!
I am in the process of writing a thesis proposal that utilizing JDBC and TableModeler to access various database platforms as a prototype.

While prototyping the model, I encountered a lot of consideration of what is the best approach for certain implementation (mainly on JDBC). While looking into a few of designing books, I found this Data Access Patterns book that fits into my research needs. I have read other book such as Designing Flexible Object Oriented System with UML and not able to apply the concept or see solution in it. It is simply a conceptual book. No practical examples at all.

Mr. Nock has explained the design patterns very clearly in each chapter by using JDBC as a media. The examples are very easy to understand as compared to Design Patterns Explained. I am not able to understand codes that implementing graphics in that book.

Mr. Nock addressed the pros and cons of the patterns. Many techie books do not even bother to talk about pros and cons.

The author has chosen the right title for the book, I realized that many times author received a poor rating because reader expect different contents based on the title of the book.

The feature I liked the most - the ¡§Applicability¡¨ section on each chapter. Unlike other patterns book, the author explains the concept and gives example of "what" and "when" to use certain design pattern. This section is pretty much the answer for my thesis obstacles. The answer is in this book!!

Minor typos do exist such as in page 390 roll back instead of rollback.

In concurrency chapter, author may have mis-used the term of updates locking. It should be Lost Updates instead of Missing updates. Concurrency chapter looks like UDB Lock Concurrency architecture.

Additional note - would like to see the quality aspect in each of the patterns.

Overall, the book is very well structured, explained and thoughtful.

Thank you Mr. Nock !!This is a perfect book for my thesis.

Looking forward to read your future publish.

Regards,

EQ

Excellent and Easy To Read
I have to disagree with the previous review.I will try to explain why I think 'b88zhou' review is inadequate after presenting my overview of this book.

After reading numerous pattern books, it is nice to see a pattern book with very good organization.

Each pattern is presented with the following subsections.

* Description
* Context
* Applicability
* Structure
* Iteractions
* Consequences
* Strategies
* Sample Code
* Related Patterns and Technology.

I specifically like 'Consequence' section because it outlines the 'bad' consequence of adopting the patter.This goes with the mantra of design patterns - there is no one good pattern.You trade off one design for another depending on the context of your domain.

Also each pattern is accompanied by UML class diagrams and UML sequence diagrams - this is a big plus in understanding pattern.

The sample code is written in Java/JDBC so you may need to understand Java but I believe this pattern is still relevant to ADO.NET and C++.[ ADO.Net does offer connected and disconnected database operation so some patterns may not be relevant - plus, event/delegate will aid in some patterns.]

Specific to what the previous reviewer say - here are my rebuttals.

>> Why do you want to make queries and database updates into factories?Looking at the sample code, does it really help decoupling?

The previous reviewer mentioned as 'factories' is the derivation of 'AbstractFactory'.If you do not understand why AbstractFactory aids in decoupling from the concrete implementation, I think you should re-read GoF book.The author usesAbstractFactory pattern extensively in context of "Input and Output Parameter" and "Cache Patterns".I do admit that sometimes "Input and Output Parameter patterns" may not need to use AbstractFactory but if you read 'Domain Assembler' pattern you will understand why.From Domain Assembler, you can see the benefit of having AbstractFactories for Selection, Domain Object, and Update -- assembling all these factories via interface not concrete implmentation - a basic idea of design to interface instead concrete implementation.

>> The "Cache Patterns" does not solve the problem of preventing stale entry or even attempt to describe how to invalidate cache entry, so no matter how efficient you get, the cache is not guaranteed to be up-to-date /correct.

Please re-read 'Cache Collector'.The pattern could have different name like 'Cache Garbage Collector'.He talks about how you can 'purge' old data.Also re-read 'Cache Replicator' for how to sync the cached data in distributed system.

>> I'm surprised "stored procedure" is not mentioned at all.

I guess you have not done too many DB oriented projects.The stored procedure is evil and add little value to OO programming.But if you want the stored procedure, just replace 'SELECT' or 'UPDATE' statements to whatever stored procedures you want to call.So I don't think you can add much with SP.

>> mature object/relational frameworks like EOF (Apple WebObjects) or TopLink

This book is not about Java Data Object or OR mapping.Object-Relational mapping tool is another beast.

I would recommend this book highly to anyone doing DB application development. ... Read more

Book Description
Databases on the Web is a concise, readable guide to enabling Web access (across intranets and the Internet) to information created over decades on many different systems. This content includes shop-by-mail pricing guides, school registration and tuition systems, and billion-dollar corporate databases.

The key to integrating databases onto the Web is flexibility. Flexibility is also the key to this book. Learn to make a wide range of applications and configurations work in harmony: all database types -- flatfile, relational, extended relational, and object; assorted SQL implementations; several levels of security concerns; and many transaction systems ranging from plain old CGI to FastCGI, NSAPI, and ISAPI.

Choose and use the best tools and configurations for your system, and follow the author's real-world success stories to make your intranet- or Internet-ready database work right the first time.

The companion CD-ROM offers database management systems, connection libraries for Perl and Java, and an invaluable collection of useful tools for building a Web/database application, including Microsoft's Visual J++ 1.1 Trial Edition. ... Read more

Customer Reviews (2)

Good info -- about due for an update.
My background -- I'm a senior software engineer, but haven't done much "web-work".

I'm in the planning stages of a large commercial website that will be mostly data-driven so I'm "consuming" asmany [good] books related to this subject as I can.

I've found this bookto be helpful. It contains many good tips, and a good overview of thedifferent technologies that might be used to build a data-driven website --along with the hows, whys, advantages, and disadvantages of eachtechnology.

It's perfect for someone trying to design a data-driven site,or add (or improve) database capabilities to an existing site. This bookprobably isn't the ONLY book you'll need to put together a full-blowndata-driven site -- but it'll get you headed down the right path, andyou'll come out of the book with a good idea of what other (more specific)books you need (and don't need).

The one negative for me with this bookis the number of typographical and grammatical errors that exist throughoutthe book. This type of thing is quite distracting to me -- and I have tosay the number of errors of this nature far exceed that of any othertechnical book I've bought from a bookstore.

Fortunately, the technicalcontent seems pretty sound.

The best advice I can give the author for"next time" is to find a good editor (if you had an editor lasttime, get a different one). Having been an author myself, I know the valueof a top-notch post-draft review process.

rffgh
fgsgdf ... Read more

Customer Reviews (19)

Good book for getting a handle on DB access in .Net
The book is well layed out and clearly written. It can be read out of sequence. Each chapter is self contained. It shows how you can get a free copy of MSDE sql server 2000 and deftly outlines the versions and how to get started using it. It begins with a good recap of basics of database. It follows with basics of sql. Then does excellent job of enabling you to handle administrative tasks of sql on your machine and getting started. It talks about new interface ADO, ASP Net and ties in xml. Well done. Got me going from startup.

Definitely worthwhile
I struggled for a long time to wrap my head around the new data access methodology of VB.Net. DataConnections, DataAdapters, DataSets, DataTables, DataGrids, DataViews, etc. It was all very confusing. This book divides up each of those components and shows how they stand independent of each other. Most helpful was how it introduced the dataset without using any database. Only when the concepts of the dataset were understood, did it tie in the dataset together to a database source. That approach is what got me past the confusion that was holding me back.

I didn't like the way the authors prefer to set everything in code instead of using the property pane and the designer but I got past that. Also, generally the code examples were more to demonstrate the principles being explained than to actually implement a technique one would like to do in a real-world application. That's not such a bad thing, but sometimes it's nice to have that too. I recommend this book for someone that needs to get the fundamentals of ADO.Net.

Clear book that achieves its goal
Very useful and clear explanations, methodological, covering all the important aspects that any developer would need for accessing data base with Visual Basic.net.highly recommended

Good RDBMS book
Good book from two well-received authors and speakers that have gotten good ratings at our VSLive! conferences. / jim

Takes the mystery out of ADO.NET
This book helped de-mystify ADO.NET for me.Database access in .NET is a complex topic that was handled elegantly in this book. It's clear, concise, easy to read, and has a good mix of prose and step by step instruction that one needs to get a jump start with ADO.NET.I recommed it highly. ... Read more

Customer Reviews (4)

Not what the book claims to be.
The book is old with no updates, and while the book started off with good explanations, that quickly died.It seems like the book was getting too long, so the authors decided not to cover certain things, or would statethat what they weren't covering was easy to do (like secure transactions). Not a good reference book or how to manual.There are plenty of other goodbooks out there.I can see why the publisher no longer even acknowlegesthis book as theirs anymore.

The book's samples are not Win 98 or NT 4.0 compatible.
If you are running Win98 or NT. Don't Get This Book. The sample VB4 scripts run only on Win95 or NT3.4 and there are no updated versions available.

Well written! Very detailed and usefull material
I found this book to be very easy to read but also very good explaining the contents.The examples are great and also the CD-ROM.

A Very Good to start with Database Dynamic linking....
This book has all the things I need to start doing linking Database with the Web (Intranet) without learning a whole chunk of books. This is also a good book to start if you need to move to a more advanced Wed database programming using either Visual Basic ... Read more

Book Description
Greg Buczek, successful author of Instant ASP Scripts and ASP Developer's Guide, delivers this hands-on "cookbook" aimed at developers and database administrators. Focuses on key topics of interest for high-end Access developers, and provides database solutions for e-commerce, network management, company intranets and more. This must-have book contains complete database solutions that aren't available through wizards or templates. ... Read more

Customer Reviews (1)

Terribly dissapointing
This book is riddled with typos, missing instructions, and organizational errors.I was forced to go out and buy another book on Access. Don't waste your time and money on this book ... Read more

Book Description
Learn solid practices in developing large, Struts-based web applications with MVC partitioning, database access, security, and content syndication, to name a few topics covered.

This book is not for the beginner programmer. It is recommended that you have a few years of web development and database development experience before attempting to work through Struts Fast Track. It is assumed that the reader knows the fundamentals of SQL, Java, Object Orientation, HTML, Servlets, JSP's, and XML.

In other words, this is not a book to learn the basics of Java and web development.

It has been written for the intermediate to advanced web developer in mind with real-world web project experience who wants a no-nonsense, minimal hand-holding, fast track introduction to leverage Struts and MVC in their web development efforts. LEVEL: INTERMEDIATE - ADVANCED ... Read more

Customer Reviews (15)

Good information with a database slant
This book sets forth some pretty heady stuff in the architecture arena.What I liked most is the integration of STRUTS with database architecture - something that sets this book apart from all the other books on STRUTS and J2EE that just set forth the programming function calls.All in all, a must have!

Good Practical Guide for Using Struts
This book is not a reference on all the features of Struts it is a practical guide for how to use Struts effectively in your web application.The book has many valuable labs including labs on validation, tiles, stress testing and master detail.I found the book to very usefull.

A rigid step-by-step guide not a learning resource
When I got this book, I had no J2EE development environment on my laptop. This book describes all the tools you should download. The tools recommended are worthwhile, but not presented in a way you can easily use. You have to do some work. However, given that I could not find alternative sources of information in print, it did give me a good understanding of what Struts can do.

Since writing this review, another book came on the market called Mastering Jakarta Struts by James Goodwill.I gave that book a 5 star review.That one is a VERY worthwhile Struts resource.

One start is too much for this book
I was one of the first ones to buy this book. I had finnished an application with Struts. I wanted to have a deeper understanding so I bought this book. What a fiasco, like somebody already mention one of the worst technical books.

It is hard to follow, talks more about databases than Struts. Next time I would not rush to buy a book and just wait for the reviews.

A book for programmers, not managers
If you have experience codeing webApps, and enjoy hand on code, this is the book. If you like books that are a reprint of JavaDocs (or don't know what JavaDocs are) this is not the book for you.

What some reviewers have not done is download the entire source code ..., as the book tells you to. The source code shows Master Detail CRUD processing using MVC, Struts Tiles, Struts Validator, DAO design pattern implemented, Java Security, Options Types, etc. etc.
Best source code you would ever see implemented. Enough theory books or JavaDoc books, show me your practical and realistic source code! ... Read more

Book Description
This is the ideal source for anyone who wants to know how to handle production VSAM files efficiently. You get all the coding details and efficiency considerations of using the VSAM utility, Access Method Services (AMS or IDCAMS), plus pointers on processing VSAM files in COBOL, CICS, and assembler language. You'll turn to this book for answers again and again as you work with VSAM.(12 chapters, 260 pages, 134 illustrations) ... Read more

Customer Reviews (1)

Really good
This book covers everything you need to know about VSAM & IDCAMS.You should be at least semi-familiar with JCL and TSO/ISPF.The focus is on utility, skipping a few things you would never do anyway.The onlynegative thing is that the peripheral subjects are very out of date (ie:Ithelps to know that DFP was the predecessor to DF/SMS). It has wonderfulexamples that are clear and easy follow.Each example is shown 3 ways: 1.From the TSO command line 2. In OS(MVS) JCL3. In DOS JCL(does anyonestill use this?). While the book could stand an update, it is still veryuseful. ... Read more

Book Description
What is this book about?

Written by an Access programmer with more than 10 years of VBA experience, this is the perfect guide for Access users who are ready to take their databases to the next level, or for programmers who are new to Access or VBA.  Veteran Access developer Denise Gosnell shows readers the ins and outs of Access VBA and provides plenty of source code, and fully developed sample applications to guide you along the way.

Not only do readers learn to build “stand-alone” desktop applications, but readers also learn how to integrate Access applications with Web Services, and SQL Server.Download Description
What is this book about?

Written by an Access programmer with more than 10 years of VBA experience, this is the perfect guide for Access users who are ready to take their databases to the next level, or for programmers who are new to Access or VBA.Veteran Access developer Denise Gosnell shows readers the ins and outs of Access VBA and provides plenty of source code, and fully developed sample applications to guide you along the way.

Not only do readers learn to build “stand-alone” desktop applications, but readers also learn how to integrate Access applications with Web Services, and SQL Server. ... Read more

Customer Reviews (9)

Frustating Book
I am relatively new to programming, but am very familiar with Access.I picked up this book hoping to improve my ability to customize my Access databases, but I've decided to return it to Amazon.The reader is asked to repeatedly try out examples, which is typically followed by a brief, superficial explanation of the code.Often, some of the more complex calculation are simply not explained!

If you are new to programming, do NOT buy this book.If you have any experience with Visual Basic programming, this book MIGHT give you some insight into how to navigate the Access programming environment, but even then it probably will fall short.

Great Book!
I took program courses years ago in college and was a very good programmer. However I never ventured into visual language because I found them confusing.This book will get you started.It gives you all the basics.If you have done old basic you need to get past the terminology but the example explain themselves. It give you skill but like any art you need to put it on the canvas.Great book!

Excellent book!
I've never coded in VBA.I've always relied on the macros in MS Access to do everything I needed to do.However, I picked this book up to try and learn a few new things.By the time I got through chapter 6, I was writing VBA code like it was nothing.

Incredible text written so the novice user can understand it with excellent hands-on examples and exercies both provide a tremendous self educational experience for the most basic of VBA programmers (such as myself).

Ms Gosnell should have wrote the advanced book
it's a great start FOR SOMEONE WHO KNOWS A LITTLE VBA.I highly do not recommend if for beginners.If you know nothing about vba, variables, sub routines, functions etcetera, I would suggest you start with a Steve Roman book on VBA for Word.The book is a great concept book for beginner understanding of n-tear programming in vba.As far as doing tricks in vba, there are very few examples in this book.The wrok advanced vba should have been the beginner book (to some degree.)

Great Beginner to Intermediate Book on Access and VBA
I must highly recommend this book by Denise Gosnell. After skimming through about 20 books on the subject at a super bookstore in Melbourne, I decided this book was the best by far. I must admit, I am beginning to become slightly discouraged at the amount of books out there - especially on PHP and MySQL that I decided to bite the bullet and learn Access and Visual Basic programming.

This book gives you great examples and you CAN go to any chapter depending on your current skill level without being thrown on a tangent of fancy techniques and confusing explanations. All I want in a book, is someone to TEACH me through step by step explanations and well thought out sample exersizes. Denise has a wonderful ability to write and keep up your enthusiasm to keep perservering. I highly commend everyone give this book a go and you will see what I am talking about.

Thank you Denise, I look forward to reading some more of you work in the near future.
... Read more

Book Description
Speed up your mastery of the #1 business databasePart of the Professional Microsoft Office suite and installed software on most new computers, Access is today's most widely-used small and medium business database. Now, Access 2000 Programming From the Ground Up brings you up to speed in a flash so you can put this popular professional tool through its amazing paces, without frustration...without wasting time. Database pro Whil Hentzen's down-to-earth treatment gives you a thorough grounding in programming best practices, and shows you how to make the most of Access 2000 to build full-featured, industrial strength applications. Coverage includes interactive use of Access...Access tools, queries, forms,reports, application control elements, VBA, macros and The Access Object Model. Find out how to structure an Access query, use a foundation library, set up an application foundation, work with multiple data sets and advanced query, form and report techniques...handle security, maintenance and client/server issues. You also learn how to extend Access's capabilities with breakthrough features such as ActiveX controls, replication and automation. ... Read more

Customer Reviews (2)

Accessvs. Programming
The book is very helpful for teaching non-programmers how to write applications using MS Access.Since most of the code is pre-written by MS Access, then it is not necessary to have a lot of examples of code.MS Access is a database system which now permits the integration of interfaces.Any wanting to learn how to use MS Access to write powerful applications, without having to get too detailed in code, would use this book.

This book is a waste of money and time
I bought the book because I though I was buying a programming book. But I was wrong! It's a book for a beginner level. It's too superficial. You never find a profound description of the topics that could interest a poweruser. ... Read more