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

Product Description
Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is counterproductive, since this information is readily available in online references published by the major database vendors. For SQL beginners, it's more important for a book to focus on general concepts and offer clear explanations and examples of what the various statements can accomplish. This is that beginner book. A number of features make The LANGUAGE OF SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading them. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to build on your prior understanding as you encounter new words and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle, with special "Database Differences" boxes that will show you any differences in the syntax among those three databases, as well as instructions on how to obtain and install free versions of the databases. This is the only book you'll need to gain a working knowledge of SQL and relational databases. ... Read more

Customer Reviews (1)

A great intro to SQL
As a SQL novice, I found this book very helpful and easy to read. Everything was understandable and clear. The author did a nice job of explaining how each new topic relates to what you already know. It was nicely organized and very well written. It's the kind of book you can read to get the concepts, and then keep around as a reference. I'd definitely recommend this book for anyone interested in learning SQL.
... Read more

Product Description
Sams Teach Yourself Access 2000 Programming in 24 Hours considerably improves the quality of the database applications that you can create with Microsoft Access. Upon completed this book, you will be able to understand any sample VBA code that you see, and possess the skills to attack all of the most common Access programming tasks. Topics covered include using data aware controls, creating data aware Web pages, creating views to organize data, building reusable code modules, programming reports, communicating results with graphing, automating contact and task management with Outlook, and Access programming for Internet Explorer. ... Read more

Customer Reviews (9)

Some useful information, but poorly presented and edited.
This book is intended for very novice programmers, and, at least in the first seven chapters I have managed to slog through, covers Visual Basic and only passingly covers how to program for Access.The presentation is poor, both due to the awkward and affected style (e.g. "Conditional code is the traffic cop of computer programs.Individual lines of code solve singular problems.") and completely indecipherable statements such as "A collection is a user-defined datatype.The users who defined the collection are the programmers who wrote Access." Parts of the book are very basic, such as the sections describing the parts of the computer--the RAM, hard disk, bus, etc, and also has problems, such as "The electircal wire along which information travels is referred to as a bus.The microprocessor's address and data bus store the information of where data resides in memory."Confusing and inaccurate.

There are more blatant errors, such as the code example where the circumference of the circle is defined as pi*radius^2;this is actually the area.Also, a digression on an "aha" moment using Archimedes is wrong on the law of bouyancy, on Archimedes being "the father of geometry" and on Grady Booch originating the "aha" concept.

I don't recommend the book either for a begining programmer--there are many other books that are better written and more accurate or for someone, like myself, looking for a text to teach how to program specifically using Access VBA.However, if any of you are insistent are getting the book, I'll be happy to sell you my copy.

This book is really great!
I've been trying to learn programming now for about 7 years.Actually I started trying to learn exactly 20 years ago.I just never could figure it out.Now that I've worked through the first 10 chapters of this great book, I'm doing all sorts of things, I wrote an access basic double line word wrap module, as well as a module that interprets musical signs for input into MUP (a really great program...).I also wrote code to calculate totals for expenses in different categories and currencies as well as mileage calculation, which was impossible to do with the normal report tools.I've also written code for inputting a ms-directory listing (print to file) and outputting a file path and filename, which can then be imported and made into functional links.I've also written code to generate numbers (to print labels of consecutive numbers) and I wrote the code faster than I could have done it for example with excel.I highly recommend this book for anybody who wants to do programming and just can't seem to figure it out.Of course if you do have a knack for programming, you'll learn all sorts of neat tricks, I found this book very inspiring.And even then, I only have Access97, and was still able to adapt it (since it is written for Access2000) and the adapting was very little problem.I'm sure his new book for Access2002 will be just as good!

It's OK
Still haven't got some of the examples to work even though I have gone blind picking thru the code to see why. This book taught me some things but I think it jumps ahead at teams leaving gaps.

Good but could have been better
I'm an Excel Word VBA person and had some problems with this book. The projects didn't always work properly unless you set the right references in Tools, which shouldn't be necessary in internal programs. Most of the projects were about 60 lines of code, which is a general problem with programming books. They try to show you how to program by taking you on the Grand Prix the first day. In contrast, most Dummies book would show you a series of small procedures, about 15 lines of code, then piece them together towards the end of the book. That's the way to teach a new disciple. 'Here's how to do this. Here's how to do that. Here's how to put both together.' Most books (Especially Wrox) say, 'Here's how to do this and that and that and that and that. You don't have to understand all of it now, but well go through all 60 lines step by step and after doing 12 complex problems you should be able to figure some of it out.' Wrong.

Good but could have been better
I'm an Excel Word VBA person and had some problems with this book. The projects didn't always work properly unless you set the right references in Tools, which shouldn't be necessary in internal programs. Most of the projects were about 60 lines of code, which is a general problem with programming books. They try to show you how to program by taking you on the Grand Prix the first day. In contrast, most Dummies book would show you a series of small procedures, about 15 lines of code, then piece them together towards the end of the book. That's the way to teach a new disciple. 'Here's how to do this. Here's how to do that. Here's how to put both together.' Most books (Especially Wrox) say, 'Here's how to do this and that and that and that and that. You don't have to understand all of it now, but well go through all 60 lines step by step and after doing 12 complex problems you should be able to figure some of it out.' Wrong. ... Read more

Product Description
Learn how to tap the full potential of Access 2007 Transfer Access data seamlessly between Microsoft Office applications—and that's just for starters. In this all-new, comprehensive guide by well-known Access expert Helen Feddema, you’ll learn to write Visual Basic code that automates Access database tasks, creates standalone scripts, extracts and merges data, and allows you to put together powerful solutions. Whether you’re a beginner or a power user, this is the book you need to succeed with Access 2007. ... Read more

Customer Reviews (1)

Good source in passing VB scripts between Office components
The reason why I purchase this book was that I thought I was going to learn how to incorporate Office 2007 components into a ASP.NET 2.0 web application via VB script. Well the book is written for using VB script between the Office components. Posting, getting, and linking data in the major office applications. This is fine I need to learn these tasks.

The second reason why I bought this book was the Bible series from Wiley Publication usually has a CD-ROM with the book in PDF format and chapter lessons on the disk usually in the back of the book. On the front and back cover it has 3 comments on where to go on the internet to get these important files. When you go to the URl the files are not there.

I tried to contact the Publishing Co. several times by e-mail, there was no response.I contacted the author Helen Feddema by e-mail. I actually receive a answer from her 15 minutes after I sent my 1st e-mail.After 3 or 4 e-mails she personally gave me the PDF files to this book.This author gave her busy time and took some risks to help one of her readers. Maybe in the future Wiley Publication will give me the lesson files like the front and back cover says.

I give the author 5 stars and the Publication Co two stars on this book. There bible series of books is a pretty good series.

Michael Summers
Los Lunas, NM. USA
... Read more

Product Description
"I recommend this book for anyone who wants a strong foundation in Access."
—Jeff Lenamon, CIBC World Markets

Updated edition with exciting new Access 2007 features!

Harness the power of Access 2007 with the expert guidance in this comprehensive reference. Beginners will appreciate the thorough attention to database fundamentals and terminology. Experienced users can jump right into Access 2007 enhancements like the all-new user interface and wider use of XML and Web services. Each of the book's six parts thoroughly focuses on key elements in a logical sequence, so you have what you need, when you need it. Designed as both a reference and a tutorial, Access 2007 Bible is a powerful tool for developers needing to make the most of the new features in Access 2007.

• Build Access tables using good relational database techniques
• Construct efficient databases using a five-step design method
• Design efficient data-entry and data display forms
• Utilize the improved Access report designer
• Use Visual Basic(r) for Applications and the VBA Editor to automate applications
• Build and customize Access 2007 ribbons
• Seamlessly exchange Access data with SharePoint(r)
• Employ advanced techniques such as the Windows(r) API and object-oriented programming
• Add security and use data replication in your Access applications

What's on the CD-ROM?

Follow the examples in the book chapter by chapter using the bonus materials on the CD-ROM. You'll find separate Microsoft Access database files for each chapter and other working files, including

• All the examples and databases used in the book, including database files, images, data files in various formats, and icon files used in the book's examples
• A complete sample application file, including queries, reports, objects, and modules, that you can use as a reference

See the CD-ROM appendix for details and complete system requirements.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. ... Read more

Customer Reviews (18)

Beware the CD
I tried to load the CD but Symantec rejected it because of a Trojan.Wiley says it is a false positive, but I am not about to disable my AV software because they cannot put together a proper installation package that can pass inspection by one of the most widely used Anti-Virus systems.Makes me wonder about what got into the book.

Now that I have started using the book, I find that it consistently references missing files in the examples.I finally just gave up.

Good product, slow delivery.
Took a long time to get here,40 days, but arrived in good condition and complete with CD.

accessbible - at beginning
Book is fine. I had previewed it by taking it out of the library.
It came promptly- much faster than I had anticipated.

Sloppy, sloppy, sloppy!
I bought this large book with some enthusiasm, but after getting to Chapter 9, I have decided to drop the book as I do not trust it to guide me to more complicated topics.Number one, no one seems to have edited the book for sentences that do not read correctly. Number two, I have seen in more than one instance the same screenshot being labelled as two different things.There were six authors here. Couldn't they have edited each others chapters???

So many inaccuracies, would be a challenge for a beginner
There are so many inaccuracies from this book, it would definitely be a challenge for a beginner to use.The CD not containing the files used in the examples is a big problem.The missing files, errata, and full corrected chapters can be found at [...].The authors seem to know the subject, but the editing is terrible. ... Read more

Product Description
Part of the New Perspectives Series, this text is designed for a second, more advanced course on Access 2000.Includes extensive coverage of Visual Basic for Applications (VBA). ... Read more

Customer Reviews (3)

ACCESS 2000 Advanced Manual
Excellent book, good service.

Prior to purchase I would have liked to have seen several pages of technical examples used in the book to see if it used enough detail, it did, well written.

A very good book for self-learner
My boss asked me to develop a leave system. I have no experience about Access VBA before. I bought a lot of books. However most of them are too thick and theoretical. No step by step examples are provided. Fortunately after reading this one, I can finish my task now.

Microsoft Access 2000 with Visual Basic for Applications
I consider this book to be ideal for people needing real hands on knowledge of Access. I'm using it in self-study to learn advanced concepts and VBA. I feel this is the ideal text for the self-learner.

This is a superbly organized and clearly written book that anyone with an intermediate knowledge of Access who's interested in moving forward into VBA will appreciate. The figures and illustrations are well-integrated with the text, allowng the pictures and the words to work together to improve the knowledge of the reader. It's a good balance between theory and practice. It's difficult to point out specific qualities. In short, I think the strength of this book lies in it's organization and clarity of text.

The "Reference Window" concept gives a general overview of the procedure being taught. This has helped me understand the "big picture" and gives me ideas on using the concepts in my existing databases. The book is also a gold mine of good ideas that I'll be able to incorporate into my databases. Additionally, a well-detailed table of contents and good organization makes it fairly easy to find what you're looking for. All the above makes this book a keeper for future reference.

Technical concepts and overviews enhance the ability for the reader to learn some very challenging procedures. They are presented on an "as needed" basis and in sufficient quantity to increase understanding without being technically overwhelming. ... Read more

Product Description
As your essential guide to Microsoft’s new SQL Server 2005 certification (exam 70-442), this book offers you practical and in-depth coverage. Full coverage of all exam objectives is presented in a systematic approach so you can be confident you’re getting the instruction you need for the exam. Plus, practical hands-on exercises reinforce critical skills and real-world scenarios put what you’ve learned in the context of actual job roles. Finally, challenging review questions in each chapter prepare you for exam day. ... Read more

Product Description
The incredible expansion of the Microsoft Access market share combined with the growing number of users who want to customize and automate tasks has led to strong demand for this new book. Because Access is a relatively young product, many users haven't had the chance to get beyond the intermediate level-they're using Access but haven't tapped into its real power. This book is perfect for users who want to get to the heart of Access to help them build personalized and customized Access solutions. Fifteen lessons methodically teach readers, in the highly successful Step-by-Step format, how to use this built-in graphical programming language to customize Access to work the way they do. ... Read more

Customer Reviews (6)

Old book, but still useful
Best Access VBA book I have ever bought, and I have bought several.

Callahan is a great author, knows his application, and is great at explaining something that looks complicated, making it very simple to start programming your access forms and objects, jumping right into the nitty gritty.

Useful even if you use Access 2003.I have not bought Access Vista, but it's as good and still functional for Access 2003.

My favorite thus far
I have worked with Access97 for several years now, but the person designing the databases worked strictly in macros.I had read enough of the developer's books to realize that isn't the proper way to go, but those books were over my head since I had never had any programming experience.This book fit the bill because it assumed I knew nothing else.I think if I master this book and the Access Macro & VBA handbook by Susann Novalis that I will then be ready for the developer's books. Novalis described it as: intro books - walking; intro VBA programming - running; developer books - flying.I really want my databases to fly, but I have to learn to run first.

All the information you need to customized your Access DB
Great tutorial with specific examples that walk you though customizing Access DBs with a business purpose in mind. Really great book, I highly reccommend it to anyone who is planning to learn how to build customizedaccess applications. Worth every cent you spent on it.

A well-organized tutorial on developing Access applications
Mr. Callahan provides a well-organized, easy-to-follow tutorial onapplication development in Microsoft Access 95, emphasizing Visual Basicfor Applications (VBA). This book is an excellent introduction to Accessprogramming. Hands-on training is provided on the accompanying diskette.

If you like to "learn by doing", this is the book for you.
I love this book.I learned more in 3 hours with this book than I did in a month of wading through various Access and VBA tomes. It is a perfect fit for the fairly technical Access user who is new to Visual Basic.Is your database dying under the weight of its macros?You need VBA and this is the book to teach it to you. ... Read more

Product Description
Focuses on providing an introduction to SQL and using the Access database engine with SQL in a tutorial format. Each chapter is step by step and contains examples that can be run using Access. Softcover. ... Read more

Customer Reviews (3)

An "okay" book but it has numerous errors
The pace is very slow for the really basic stuff while more sophisticated techniques, such as correlated sub-queries, are not explained well enough.

There are numerous errors in the book which suggest the authors don't really know Microsoft Access.Clearly, some of the worked problems were only tried on paper and not through Access itself.Significant errors appear in the discussion of data types (pp. 58 - 81), joins (p. 105), calculations with dates (p. 145), null constraints (p. 282) and referential integrity (p. 288).The downloadable example database does not comply with modern database design protocols.

For a much better book, try "SQL Queries for Mere Mortals" by Hernandez & Viescas.

Excellent book to use to TEACH SQL (using Access)
This is an excellent book to use to teach students SQL in a very inexpensive way -- using Access. Although the book may not be in-depth enough for professionals, the authors do a great job of presenting the material in a very user friendly and systematic way for beginner students.

Use only if desperate to find an SQL book for Access
I know the pickings are slim for finding a book to learn SQL using Access, but PLEASE can't someone who knows how to teach and cares about getting their information correct write one?First off, this book has many errors including some statements that work OPPOSITE to the statements.Ex:On page 105 the description for "Nested LEFT and RIGHT OUTER JOINs" reads "In Access, A LEFT JOIN or a RIGHT JOIN can be nested inside an INNER JOIN, but an INNER JOIN cannot be nested inside a LEFT JOIN or a RIGHT JOIN."NO. NO. NO.It works in the opposite way.

The tables to be used in the book tutorials often bear no relationship at all to the fields or to the data and some of the naming produces run errors-- creating a frustrating experience for a student.This was obviously no labor of love for the authors, but a slapdash method to pump out a book.It is a crime that there was no quality assurance on this book.That alone would have caught the worst of it.For shame to all associated with its publication.

I generously gave it two stars just because it is probably better than nothing, but not much better.Again, here's a call to all of you SQL trainers out there:your market is wide open. ... Read more

Product Description
Take a look at this great application of VBA and learn to expand the capabilities of Access with simple programming. Author Charles E. Brown shows you step-by-step how to create your own code, work with Object-Oriented Programming, and more. Plus, discover and utilize key programming concepts that can be applied beyond VBA. ... Read more

Customer Reviews (3)

Steve's review of Brown's Access VBA Programming
Breadth of coverage was great, but I felt it lacked enough good lengthier program examples. A case study (small application example) or 2 would have been nice. Book is terse and well-written and organized.

A Good Introduction
My programming skills are minor and predate Windows as the main operating system in use. I know a few basic principles but have never been a "programmer". This book will not make me one but it goes a long way towards giving me the skills to reacquire some basic competency.

The text sets out some basic ideas about data structures and ways to manipulate them. These are general principles and have little to do with programming Microsoft Access but they are needed skills. Then the real lessons begin as the principles are used to learn how to manipulate Access objects and the Access environment. It is done is a thoughtful and logical manner which makes sense and which is easy to understand. It is a good introduction.

The code examples a fairly easy to follow and do a good job of making their points even when they are only read instead of tried. Actually trying the examples makes the learning process more complete. If I had one major gripe about this book it is that it did not ship with a disc. The examples are available by download over the net but are not included in the purchase. This make work fine for some but I got started in out of the way motel rooms without highspeed access. I would have rather paid a few dollars more and gotten what I need.

Still, as I said before, it is a good introduction.

For beginning (not experienced) programmers
The 1st half gives you a quick and sparce overview of what you can do without VBA.It spends lots of time interducing the reader to database design, queries, forms, and tables.If you have any idea what any of these are, you will get nothing out of the 1st half of the book.

The 2nd half introduces the reader to not just VBA but primarily to the concept of programming.I would say it is about 40% general programming (procedures, variables, scope, etc.), 30% idle banter, 20% useless graphics, and 10% Access specific code.

If you have any programming experience, you'll be wasting your time searching for the hidden nuggets in this book.If you are new to Access and to programming, this book is a good into. ... Read more

Product Description
Step-by-Step, Full-Color Graphics!

Get started using Access 2007 right away--the QuickSteps way. Color screenshots and clear instructions show you how to use all the new and improved features. Follow along and learn to work with the new Office interface and ribbon, create databases and tables, and enter and edit data. You'll also find out how to retrieve information, create forms, and generate reports. Plus, you can flip straight to the information you need easily using the color-coded tabs. Get the book that gets you started using Access 2007 in no time.

In each chapter:

• Shortcuts for accomplishing common tasks
• Need-to-know facts in concise narrative
• Helpful reminders or alternate ways of doing things
• Bonus information related to the topic being covered
• Errors and pitfalls to avoid

Customer Reviews (2)

This book got me up and running with Access
I used this book to learn MS Access when I had to build my first database in a hurry.It was easy to follow, proceeded in easy steps, and provided clear examples.I was able to design the database (admittedly a simple one), design a form for entry and recovery of records with a few simple calculations and design a couple of simple reports in a few days.

After that, if I wanted to do something new with the database, I could use the book as a reference.

I found this to be a very good introductory text.

Waste of money!
This book is useless. I thought I buiy it to quickly learn some basic Access skills to keep me going. The Author doesn't provide any material entering in data they expect you to have data already set and they skipp through alot of things. I know it's a Quickstep which is why they probably skipped through on showing how to enter in table and create a table but it makes it confusing. The whole purpose is entering in correct data correctly so you don't have problems when relating a table one to another. I had so many problems with this book and I finally gave up I'm going to look for another book. ... Read more

Product Description
Improve your database productivity with this task-oriented guide to using macro and VBA programming to create custom database applications. Building on your basic knowledge of Access, this book takes you to the next level. Master all the skills you'll need to automate complex processes and to design and deliver applications that meet users' exacting requirements--even if you have no prior programming experience. The companion CD contains code from the book for your reuse and sample databases for hands-on experience.Amazon.com Review
Database front ends are the bread and butter of most VisualBasic programmers, so it pays to know how to build them well (and asefficiently as possible). Access 2000 VBA Handbook does a goodjob of explaining the power of Visual Basic for Applications (VBA) andhow it can be used to create custom interfaces on top of Access 2000databases. This is a well-written, comprehensively researched bookwell-suited to aspiring Access developers. It's also a fine resourcefor programmers who use older versions of Access and want to learnmore about the newest version, particularly the new DAO-centricapproach to transactions.

The writing style will appeal to thosewith a modicum of familiarity in general programming concepts andprocedures--the sort of knowledge one can gain in a university-levelsurvey programming course. It documents core VBA as it applies toAccess but concentrates mostly on explaining the tools available tosolve various problems. The book doesn't go overboard with codelistings--a greater number of explicitly stated solutions to problemswould have made it better. Instead, it presents long, annotated listsof options and parameters. It also documents lots of step-by-stepprocedures involving Access's graphical user interface. --DavidWall

Topics covered: The Database Wizard, the VBAprogramming environment, basic VBA data and control structures, formdesign, record manipulation, and Structured Query Language(SQL). Object model coverage includes the Access object model, DataAccess Objects (DAO) and ActiveX Data Objects (ADO), with data-accessemphasis on DAO. ... Read more

Customer Reviews (15)

Was what i expected
Keep up the good work it's vendors like you that keep me comming back to amazon for all my shopping needs. Thanks!

Legacy Systems
Application development tools become obsolescent when released and today's entry level developers raised on Visual Studio 2008 or similar may cross their eyes when someone mentions Access 2000.After all, they may have just entered high school when Office Professional 2000 was released.Actually, Office 2000 software and the VBA that came with it were a high water mark for the era and became the virtual end of the line and therefore the highest form of development for the Microsoft strategy of the day.Access 2000 VBA is VBA6, the Office version of Visual Basic 6, which some still consider to be a worthwhile development environment if not still the premier VB development environment.If there is any doubt about the current popularity of VB6 one only need visit eBay to check on the selling prices for the various versions of VB6 that change hands on the site.

On the job, it may still be necessary for application developers to be able to get their heads inside of VB6 and VBA6 and depending on their needs, they may find "old" references useful."Access 2000 VBA Handbook" is aimed at the relatively unsophisticated developer and could be used by one who wishes to get his head inside of Access as a stepping stone to the current versions (2007 and 2010 beta 2).It also can be used as a reference for those who have forgotten or never knew what DAO was.I am certain that many can and may still find a book like this one useful.

Looking back over earlier reviews, I have sympathy both with those who found this to be the best book of its kind or found it to be a terrible book.While it is true that the author seems sometimes to jump around among topics, a less superficial reading usually reveals that the author expects only that the reader will engage his brain and his wits to "fill in the gaps."The apparent gaps are never large and if one treats them as minor brain teasers, he will quickly find that he learns more and more quickly than if everything were spoon fed in agonizingly detailed baby steps.Besides stimulating more rapid learning, the author's presentation style does not bog down as many other's do.For books of this type, the style is actually relatively brisk.

As evident from my five star rating, I cast my lot with those who found this to be an excellent text.Whatever leads the reader to this book, he will find in it VBA6 development up to the intermediate level presented in a style that stimulates the imagination and curiosity.What more can we ask for?

Access 2000 VBA Handbook
Good book. Easy to find the answers to my questions and get back to work.Good examples and written with clear explanations that get to the point.

Good Day.

Thank goodness for Susan Norvalis
This book really stands out from the crowd. Most VBA texts are written by great programmers who are terrible teachers. Not in this case -Using VBA to unlock the power of MS Access is thoroughly and clearly explained - from concepts such as database design and objects to JET, DAO/ADO and beyond.The author shows how to do everything that you can do with Macros, how to do many things that you can't do without VB and then how to most efficiently do all of them!Most useful is the clear way in which the book shows how to perform tasks efficiently in interactive (Forms) and automated (DAO/ADO Recordset manipulation) ways and when to choose each- this book will remain an invaluable tool in my library and be referenced often.

Not useful for developers
I must agree with other reviewers. In spite of a good knowledge of Access the reading of this book does not help to write practical applications, and is very frustrating. The author jumps from topic to topic and gives very little code that can be used in real life situations. I would qualify this book as no more than a broad and theoretical overview. ... Read more

Product Description

• Updated to cover all the latest features and capabilities of Access 2007, this resource provides new and inexperienced Access users with eight task-oriented minibooks that cover begininning to advanced-level material 
• Each minibook covers a specific aspect of Access, such as database design, tables, queries, forms, reports, and macros
• Shows how to accomplish specific tasks such as database housekeeping, security data, and using Access with the Web
• Access is the world's leading desktop database solution and is used by millions of people to store, organize, view, analyze, and share data, as well as to build powerful, custom database solutions that integrate with the Web and enterprise data sources

Customer Reviews (5)

Dummies is great
I am continuously using this boof for a project I was assigned. I find it very helpful, well organized and easy to understand.

Simson's Access 2007

Simpson's Access 2007 All-in-One Desk Reference for Dummies, bought through Amazon, is one of the best introductions to Access 2007.
I had worked with Access 2002 and 2003 for several years.I soon realized that, for version 2007, I needed a thorough
relearning of Access object management.
Simpson's numbered steps provide clear and graduated instructions for each procedure.The marginal book and chapter headings are helpful in looking up related topics.
Brother Joe Bouchard

Access 2007 for Dummies
I have used Microsoft Access at home for about 10 years, but never fully utilized most of it's powerful features, because I didn't take the time to really study any of the manuals and guides that were available.Prior to Access, my experience with data base applications was limited to proprietary programs of the company I worked for. Then I talked to someone about Access 2007 for Dummies, and decided to try it.I have only been using it for about 2 months and already I am pleased with my decision. The way it is written has allowed me to quickly identify some things I have always wanted to do with the program, as well as, show me some things I had never really considered in data analysis or record keeping.I am 75 years of age and semi-retired, so most of my use of the program is limited to keeping my personal, family and financial records, logging activities, generating forecasts, travel, sports data, etc.Knowing more about how Access works has enabled me to also reduce the amount of time spent updating and consolidating data.

Can't go wrong
You can't go wrong with any of the "Dummies" books.They are very easy to read and the directions are written in plain English.I would always buy a "Dummies" book before any other type of manual.

Terrible and not for anyone, especially "dummies"
I've never used Access before and spent about 2 days tinkering with it before I decided I needed a book to get any further.This is the first one I picked up.It gives you step-by-step instructions on how to do the simplest of tasks: open a new database, create a new table, use one of the various wizards within Access, how to navigate the new ribbon, etc.But they gloss over anything more complicated than that.That's a big problem when you're trying to learn a program as powerful and easily complicated as Access.I was really looking for help designing queries and I got nothing out of this book - it actually left me a little more confused.I'm pretty good with computers.I can't imagine how confused someone would be if they were actually a "dummy" when it came to computers.Thankfully, I got this book from the library so I didn't waste any money on it, but I did waste my time reading through the first third of the book before I abandoned it.I would recommend Access 2007: The Missing Manual instead - that book walks you through everything, often with screen shots of the program. ... Read more

Product Description
SQL for Microsoft Access unlocks the power of Structured Query Language (SQL) in Microsoft Access. It guides the reader through step-by-step examples of creating a database in Microsoft Access using SQL script to create tables, add records to tables, and retrieve and manage records using simple to advanced data manipulation techniques including queries and views. The reader also encounters exam-ples of integrating SQL script into VBA and ASP code.

* Explore the relational database structure and the basics of SQL. * Learn how to insert, retrieve, and filter records. * Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables. * Learn how to use views and temporary tables. * Discover how to prompt the user for information with parameter queries. * Find out how SQL can be used to enhance Active Server pages. * Test your knowledge through the end-of-chapter quizzes and projects. ... Read more

Customer Reviews (3)

Lots of mistakes
This book is loaded with problems.I started using the book three days ago, trying to work my way through the examples.I have only reached page 73 and here are the problems I've run into so far:

On page 48 there is Example 6 that demonstrates how to insert five records into a table.However, the author doesn't mention that you cannot use the example as it is written in the book, and that you have to run the five statement separately.Frustrating!

On page 57 you are instructed to update a Sales table that you have not created (I know, it's in the "Companion Resources". I'll get to that.)

On page 71 you get instructions to order another non-existent table (another companion resource).

On page 73, Example 7 shows you how to order a table by selecting rows.However, the output shown on the page is wrong.It is supposed to put the last names in alphabetical order, but there is no discernible order to the table shown.

Now, about the Companion Resource files. I tried to download them but I got an email saying that they are available only to "qualified instructors"- not just us schleps who shelled out $36 for the book!

Maybe have someone test this book before the next edition!

Excellent fundamentals explanation
As somebody new to both Access and SQL, I found this to be my best reference for getting started.It covers the basics and does a great job.You cannot perform advanced objectives without a solid understanding of the fundamentals.
Each chapter has a series of self-test questions to make sure you have mastered the necessary concepts for that chapter. (and the answers are in the back)
There's also quite a bit of good quick reference material in the back for frequently used SQL keywords (for Access) and general database terminology.
I've found it to be a great book and I highly recommend it.

Excellent Access Primer
This book is an excellent primer for the SQL novice.It is well organized and offers an excellent exposition of Microsoft's version of the SQL language.There is just on big problem; it is just about impossible to download the book's companion file offered on the Wordware site.This problem is a serious flaw in an otherwise outstanding book. ... Read more

Product Description
If the thought of programming databases casts a dark shadow on your soul, then let this book light up your life. Whether or not you've gone through the programming wringer before, Access 2000 Programming For Dummies clues you in to simpler ways to produce dynamic databases and applications. Uncover the secrets of professional database development and let this book reveal the many added features of Access 2000 that you'll quickly be taking advantage of.

Step up to the unlimited possibilities of such Access features as SQL (Structured Query Language), OLE/DDE (Object Linking and Embedding/Dynamic Data Exchange), and wizards, and discover all your programming options. Best-selling author Rob Krumm shows you how to do everything from building your own programs by using Access 2000 to building supercharged database applications by using ActiveX controls and SQL statements. Krumm also shares his personal methods for error-free code testing, and he's included an entire CD of sample code.

Stop wondering what would make your Access programming easier and pick up Access 2000 Programming For Dummies to discover the quickest way to get your databases up to speed. ... Read more

Customer Reviews (10)

Dummies Only Please
If you're a beginner this will help you understand how to write the code that will really take advantage of the power of MS Access.Combined with a good book on SQL this would turn any novice into a capable Access programmer. Includes a CD-ROM with code examples from the book.

Make it your official Access 2000 programming book
I really enjoyed this book. It covers a lot of information in much less space. The author programs where ever he can and does not really on macros or wizards. The are a couple typos, but the code is relaible enough. The major problem was one of the chapter databases could not be opened so I took extra steps to recreate it by importing tables from other databases and creating all the forms according to all the specs I was able to get from the book text. The book devotes a good chapter on SQL. The book covers nicely Classes.

Perversely useful
I found the book easy to use and well-organized for relating VB to Access. Also, in its own perverse way, this book was very helpful: once I understood that the book was full of errors, I used the errors to help me learn. I agree with other reviewers, though, that they should have hired an editor. (Also, on general principles, I suggest buying it from your local independent bookseller).

Bad editor, Good Author
The editor of this book should say sorry to the book author as he/she made this book with so many errors.He/she needs to learn basic editing skill.By the way, if I am the hire, I will fire him/her on the spot.

Great Guide for Patient People
As others have previously stated, the book is full of errors. That being said, I loved the book.

The book has helped me jump from a beginner to an intermediate user of Access.

I would recommend the title only for those with a background in programming who just need to apply their knowledge to Access. If you have no knowledge of programming, forget about undrstanding this book.

I liked the author's approach to teaching the Access/VBA programming environment/language. Like *Special Edition Using Access 2000* the use of VBA is strongly recommended as apposed to using Macros. In fact both books do not delve into Macros at all. If you feel you need to learn about Macros, I strongly recommend *Running Access 2000*.

The book has very little fluff and gets you right into programming.

Perhaps the book was just perfect for me at where I was in using Access. You definitely need to know the basics of Access before reading this book. ... Read more

Product Description
Databases are often viewed as the end product rather than as a tool in the work place. This book has been written to address this need, using straightforward examples and assessing different ways of storing information. It is a practical guide to collecting data and using Microsoft Access to transform it into useful information.Written for both Business Studies students and professionals, it adopts a functional approach which teaches theory by practical example. 'Jargon buster' sidebars explain the terminology related to database theory, while the revision questions at the end of each unit aid comprehension. This straightforward approach means that the text is ideal for self-study. ... Read more

Product Description
PROGRAMMING MICROSOFT ACCESS 2000 serves both as a starting point for novice Access developers and as a robust reference to new features and advanced topics for experienced programmers. This task-oriented handbook delivers comprehensive coverage of Access database development-starting with a review of fundamentals and version enhancements, and ramping up to advanced multiuser and multicomputer issues. Coverage is organized into four parts: Access Basics; Data Input to Data Output; Customizing and Extending Applications; and Multiuser, Client/Server, and Web Issues. The CD-ROM features all source code used in the text.Amazon.com Review
If you want to plunge deeper into the mysteries of Access andcreate dazzling data solutions, Programming Microsoft Access2000 will serve up the solutions. With support for object linkingand embedding database (OLE DB) and ActiveX Data Objects (ADO), Accessdatabases have become easier to use, as long as their programmer'sskill is up to the task.

You'll learn all about OLE DB and ADOsupport, as well as integration with SQL, Web access, multiuserissues, and Visual Basic for Applications with its readable text,snappy screenshots, and plentiful examples. (All code and samples areincluded on the companion CD-ROM). While you work through the examplesand design your own solutions, you'll find the practical "look, see,do" style well-suited to hands-on programming instruction.

You'llalso find the complete searchable text of the book on the accompanyingCD-ROM, making it a more powerful reference tool, as well asthird-party software to help you fine-tune your programming. Whetheryou're new to Access or upgrading to the 2000 version, ProgrammingMicrosoft Access 2000 will make your development jobs easier andmore efficient. --Rob Lightner ... Read more

Customer Reviews (17)

Programmin Microsoft Access 2000
I am what may be described as a `power user' and have developed a couple of Access applications for my consultancy in the past that were heavily dependent upon macros. Having a requirement for a new extensive application I was keen to adopt a more procedure-orientated approach to its design. I bought this book as a guide and have found the chapters dealing with the introduction to VBA and Access procedures particularly logically in approach and easy to follow. In my experience this is an excellent book for those making the migration from power user to new developer.

Excellent Book for Access Programming
I have been teaching Access programming for 4 years. Since I use this book, I have learned a lot, and all of my students love this book. This books has many very valuable examples, also it covers ADO topics in detail. This book impresses me the most is that it covers progmming topics in depth. If you want to learn progmming in Access, this is the right book for you.

Excellent Book for Access Programming
I have been teaching Access programming for 4 years. Since I use this book, I have learned a lot, and all of my students love this book. This books has many very valuable examples, also it covers ADO topics in detail. This book impresses me the most is that it covers progmming topics in depth. If you want to learn progmming in Access, this is the right book for you.

Save your money
There may be some good Access/VBA books out there. This is notone of them. The section on Office integration is almostworthless. This is not for the beginner and experienced developerswill get little from it. To be fair, there are a few cute techniquesyou can pick up from this book, and it might be worth having around ifyou could pick it up off a bargain table for less than ....

A very good book, but not for beginners!
The book is a good guide for people who have some experience with Access,and does an especially good job in introducing the new features in Access2000, such as the use of ADO.However, do not buy this book expecting tolearn the basics of Access from it.It is filled with acronyms and termswhich will lose you unless you previously know what they mean, although theauthor does a good job giving a brief explanation of each one.Otherwiseit is a great book and a good guide to VBA for people who have alreadyplayed around with Access. ... Read more

Product Description
Get up to speed on Access 2003 programming – in a weekend!

The big day is Monday. The day you get to show off what you know about Access 2003 programming. The problem is, you’re not really up to speed. Maybe it’s been a while since you’ve done Access programming. Perhaps you’re not acquainted with all the new tools that Access 2003 provides. Or maybe you just like a challenge. In any event, we’ve got a solution for you – Access 2003 Programming Weekend Crash Course. Open the book Friday evening, and on Sunday afternoon – after completing 30 fast, focused sessions – you’ll be able to dive right in and start creating sophisticated, data-driven solutions with Access 2003. It’s as simple as that.

The Curriculum

Friday

Evening: 4 Sessions, 2 Hours

• Introduction to Access and Programming
• From Macros to Modules
• Design, Testing, and Debugging
• Events – A Place to Run Your Code

Saturday

Morning: 6 Sessions, 3 Hours

• Variables and Naming Conventions
• Loops, Decisions, and Quick Exits
• Procedures, Modules, and Class Modules
• Access Architecture Working with Data Programmatically
• Adding, Updating, and Deleting Records Using ADO

Afternoon: 6 Sessions, 3 Hours

• Switchboards, Custom Menus, and Keyboard Events
• Using Unbound Forms
• Programming Check Box, Option Group, Combo, and List Box Controls
• Subforms and Continuous Forms
• Programming Tabbed Controls
• Message Boxes and Error Handling

Saturday, cont.

Evening: 4 Sessions, 2 Hours

• Importing and Exporting Data
• Improving the Speed of an Application
• Creating Animated Splash Screens, About Boxes, and Startup Screens
• Creating Help Systems

Sunday

Morning: 6 Sessions, 3 Hours

• Creating Search Dialog Box Forms
• Dialog Boxes, Reports, and ActiveX® Controls
• Application Architecture
• Packaging Your Application
• Programming Wizard-Type Forms
• Using Add-Ins

Afternoon: 4 Sessions, 2 Hours

• Programming File Attachments
• Securing Access Databases
• Access and Client Server Data
• Creating SQL Server Queries

Customer Reviews (5)

excellent. makes you from beginner to expert. really
short, easy to digest chapters.
very well explained.
i referred back to it many many times after i finished with it.
youve got theory, design, practice, quizes.
really well organized.
im sure very much work went into this book. and its obvious
RECOMMENDED for beginners/intermediates who want to go those few extra steps!

I still refer to the previous edition
I bought the Access 2000 version of this book in 2001.It was very helpful in getting started with Access programming.Don't take the fast timetable too seriously.I found it covered well how to get started on each subject, after which the net was a good reference source.I still refer to it, and copied some useful code, eg for selecting files.

"Crash" on page 10
After downloading the CheckWriter DB from Wiley's companion site for the book Access 2003 Programming Weekend Crash Course, I try and try but it will not run; it cannot find the linked files; and the "tools" for reference and linking are greyed out. So we "Crash" on page 10. How can the author claim he is teaching us Professional Techniques when his program will not run out of the box?

Take your time; as much as you need
The authors set themselves an ambitious remit. Can they actually teach you Access in 15 hours? They motivate this with a scenario of a weekend in which you have to learn, starting on Friday night, and going to Sunday afternoon. The time is divided into 6 parts, one on Friday, 3 on Saturday, 2 on Sunday. Each part has several sessions (=lessons) of half an hour each. A novel approach, at least to me. Somewhat of a role-playing setup.

Each session goes over some straightforward coding. There is a back and forth between the widget forms, which often show tabular data, and the procedures that make these forms, or analyse input from them.

The pace is rather hurried. And you don't really get into the SQL itself. But, by and large, you may be able to get a basic operational familiarity with Access if you stay the course. The problem is that some lessons may well take more than half an hour. If you find yourself doing this, don't worry. You're not a retard! Just take as much time as you need to understand the material. I think the authors are overly optimistic about the alloted time for some sessions. Yes, you can force yourself to commit only 30 minutes to each. But at what cost in comprehension? More to the point, you presumably want to build on what you learn here. A shaky foundation may not help. So take your time.

The book could be improved if the authors dispense with the artifice of the 15 hours total. Cute gimmick. But it wears thin, and can actually interfere with the book's efficacy.

Awesome book to get up and running on Access 03 Programming
I bought this book to go along with Access 2003 Bible - also written by Cary Prague.I did some of the tutorials in this book and used the Bible to help expand my knowledge and found it very useful.This book gave me the first layer into Access Programming, but I needed it to get me going! ... Read more

Product Description
Treats the Microsoft Access and SQL Server environment as a whole rather than as separate entities. Offers problem-solving strategies and techniques for building a powerful hybrid system with Access and SQL Server. Features illustrations and code samples for overcoming a wide range of technical problems. Provides a how-to-get-started guide to Access Basic for readers unfamiliar with object-oriented programming. Answers questions within the greater context of relational database. ... Read more

Customer Reviews (1)

Great book!
I think this is the most fantastic and authoritative book on Access and SQL Server that I have ever read.It is filled with excellent examples that draw on the authors personal experience.A must read!!! ... Read more

Product Description
Microsoft Access 2000 Developer's Guide to Microsoft SQL Server provides much needed information and guidance for the Access power user or developer who wants to exploit the power of SQL Server. Written by Access experts and Microsoft MVPs Mary Chipman and Andy Baron, this hands-on guide provides you with the practical knowledge you need to harness the enterprise-level power and scalability SQL Server offers, while using the Access tools you are familiar with. More than just a migration guide, you will benefit from the authors' expert discussions of topics including the new Microsoft Database Engine (MSDE), Transact SQL, building stored procedures and views, converting your applications to SQL Server, working with SQL Server security, and building Access interfaces to SQL Server databases. ... Read more

Customer Reviews (13)

Excellent book. Highly recommended!
I've been an Access developer for the past 10 years. Now our company is finally migrating our data over to a SQL 2000 database. This book is an excellent resource for those transitioning from Access to SQL. The information is well thought out, laid out in an easy to use format, supplies good examples, and has a tremendous amount of useful information.

"A 1"
Comprehensive. A good resource to have in the collection of books.

Andre Van Staden - Senior Developer
Marco Giani - Group IT Back end Developer

If I had bought this book first I'd have save a lot of money
I have a lot of SQL server books. Everything from SQL Server 2000 for Dummies up to SQL Server 2000 Stored Procedure Programming. And many times none of these books had what I needed. Then I would turn to this book. I was using VB.Net, so I figured this book wouldn't apply, but I was wrong. Even if you are not using Access, this book explains SQL Server the right way. Chipman and Baron offer simple but thorough explanations and samples of the things you actually need to know as a developer. They don't spend a lot of time on the things a SQL Server DBA might need to know that a coder would not.

Maybe their approach works so well for me because I came from an Access background, but I am willing to bet anyone coming straight from VB and needing to understand Transact SQL, effective stored procedures, funtions, and triggers would appreciate this book as well.

Appears to be an excellent book.
This answers a lot of programmer level questions about using MS-Access with SQL Server.It describes the limits and penalties when going the various routes.The book is quite clear in its descriptions.It would make a good addition to any Access programmer's collection.

One of the best
This is a great book.I have recommended it to coworkers who also purchased the book and they were equally impressed.This helped me have a much greater understanding of both Access and SQL Server and how they work together.

I would highly recommend this book to anyone using Access with SQL Server.It is easy to understand and has plenty of useful code examples.I use this as a reference on a regular basis. ... Read more