Book Description
In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now.
Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately.
But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to:
- Utilize the built in features of Access and Excel to access data
- Use VBA within Access or Excel to access data
- Build connection strings using ADO and DAO
- Automate Excel reports including formatting, functions, and page setup
- Write complex functions and queries with VBA
- Write simple and advanced queries with the Access GUI
- Produce pivot tables and charts with your data
With Integrating Excel and Access, you can crunch and visualize data like never before. It's the ideal guide for anyone who uses Microsoft Office to handle data.
Customer Reviews:
A wordy collection of Excel code.......2007-06-01
The title of this book is misleading. 70% of the book covers Excel and how to make Excel integrate into other platforms and applications. At 190 pages, that means the author spends about 60 pages covering Access (and that's only to cover intuitive tasks accomplished through the user interface). The examples are mostly Excel VBA code; none of which are particularly new or mind blowing.
The strangest part of this book is the author inexplicably puts a half-hearted Excel object model in an Appendix. But no object model for Access? Can anyone say filler? Seems a shame to waste such an interesting topic on this extremely wordy collection of Excel code. The positive: this book is thin enough to fit perfectly under my wobbly desk.
Hodgepodge of topics .......2007-01-23
This book contains a hodgepodge of topics loosely fitting in with Access and Excel. Unfortunately, the title is misleading. You would expect an entire book on automating data movement between Excel and Access (BOTH from AND to), but you don't entirely get that. The XML stuff and integration with other applications is interesting but not necessarily relevant. There's also a great discussion of Excel's R1C1 (relative address) and A1 (absolute address) style notation.
Let's go through the chapters:
1. Intro
2. Using Excel's Uset Interface
3. Data Access from Excel VBA (using Excel to pull data in)
4. Integration from the Access Interface which covers exporting data to Excel.
5. Using Access VBA to Automate Excel (about pushing/exporting a spreadsheet from Access to an Excel window using Access VBA)
6. Using Excel Charts and Pivot Tables with Access Data
7. Leveraging SQL Server Data with Microsoft Office... part of this talks about how Excel can AVOID Access (the opposite of what the book is supposed to be about!)
8. Advanced Excel Reporting Techinques... bad title, good topic. This is about using Access VBA to create reports in an Excel spreadsheet.
9. Using Access and Excel Data in Other Applications (OTHER??? applications. Now we are looking at OTHER applications like Word, Powerpoint, and MapPoint. Interesting, but way off topic.)
10. Creating Form Functinality in Excel (another chapter about Excel, not integration)
11. Builing Graphical User Interfaces (an unnecessary Access tutorial)
12. Tackling an Integration Project (general discussion)
Then there's an appendix about Excel('s) Object Model and VBA Basics.
So out of all of the above, all it has to say about importing Excel data into Access is many pages showing how to use the import wizard which is pretty intuitive anyway but doesn't say much about pulling Excel data into Access using VBA. What about getting DoCmd.TransferSpreadsheet to work as smart as manually using the Access import wizard?
What about Controlling Access from Excel.......2006-12-31
I'd actually rate this 3.75 *'s, but that's not available. I find this excellent in the material it does cover, namely "controlling," if you will, Access from Excel. There simply are an insufficient number of books and documents covering the details of Microsoft automation, which was supposed to be one of hallmarks of using MS Office. However, I found nothing in the text going the other way - controlling Excel from Access. This is an inexcusable ommission, in my opinion. The book should be retitled so it's true content is clear.
This book is useless........2006-12-28
Although the sevice was pretty good, item arrived on time, etc. The book is almost useless.
Great for Office Automation.......2006-11-04
I code in Access VBA but need to push data to excel spreadsheets and format the results. This book has the answers.
Would have gotten 5 stars but I didn't find a single reference to the Access TransferSpreadsheet function which pushes data to Excel Named ranges.
Book Description
Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "Ribbon") that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help.
Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.
Customer Reviews:
Easy to understand and written in an interesting manner........2007-09-11
I have a number of years of programming and system experience, but had not been exposed to Access. I decided to rewrite my business systems using Access to convert them from the Paradox system that I had used for years. Using this book and Microsoft Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out), I have already rewritten more than half of my systems in a couple of weeks, working on them for a couple of hours each evening. Granted, I am still not an expert, but I have been able to write Virtual Basic macros, designed and completed a number of tables for my data base, forms using multiple subforms, selection boxes, and functional buttons, and a number of professional looking reports. The use of these two books has greatly shortened my learning curve and helped me to be productive in much less time than it would have taken without them.
Learn Access 2007 From Head To Toe!!.......2007-07-17
'Access 2007: The Missing Manual' by Matthew MacDonald is another gem in the line of Missing Manual books. Filled with 700+ pages of material, if you are new to Access or even a seasoned pro, there is a little bit of something for everybody in this book. A fantastic layout, wonderful content, and one of the most user-friendly books out there, if you use Access for any length of time and want to become a better user or are a new user and want to discover how to use Access, this is the ONLY book for you.
An absolute marvel which richly deserves the title 'Missing Manual' as this keeps up with the past quality works expected from this line.
***** HIGHLY RECOMMENDED
Access 2007: The Missing Manual .......2007-03-16
Title: Access 2007: The Missing Manual
By: Matthew McDonald
First Edition: December 2006
Series: The Missing Manuals
ISBN 10: 0-596-52760-8
ISBN 13: 9780596527600
Pages: 751
This book is light reading. The style is light and easy to enjoy. The author is definitely a wordsmith and has total control over the tone of the book. Some of the chapters start with non issues to people interested in Access, but this seems to be his writing style: a neutral or buffered start so you do not bolt before you get into that chapter.
This book is heavy reading. After a few paragraphs of light introduction, each sentence is packed with actions to take, issues to ponder, tables to study, and much more. The actions to take could not be done in one night. Look forward to a week, at least.
Annoying things for me:
1. His use of 's.
Code's means "code is" and not "code's use" in the sentence [not the possessive but the contraction].
This happens all the way through the book, so heads up.
2. His use of double negatives.
I found it harder to concentrate on the meaning when there was no evidence that it was not found [see what I mean?]. "no reason you can't get a little fancier" [page 531]. Why not just say:
You could get a little fancier?
You could get a little fancier within reason?
This happens all the way through the book, so heads up.
I liked the following chapters quite a bit:
Chapter 4 blocking bad data
Chapter 15 automating tasks with macros
Chapter 16 automating tasks with visual basic
Chapter 17 writing smarter code
Part Six was the best
Chapter 18 sharing a database with multiple users
Chapter 19 importing and exporting data
Chapter 20 connecting access to sql server
Chapter 21 connecting access to SharePoint
These last two chapters were the very best in the book, depending on whether you were more interested in the sql server database or the collaborative issues surrounding SharePoint.
On page 640, one of the top reasons to switch to Sql Server: Real security
So does Access have Unreal Security? Not enough of a fine grained model? That is real reassuring...
OK, so I did read it, scrutinize it, check the fine points. When I mention that it is worth 5 stars and every penny you might have to spend to get it, that takes everything into account. The book asks questions like: Can you trust Microsoft? [Page 641], so some balanced point of view is being used by the author. Well done.
I really like Access 2007 and find it to be a quantum leap forward. Try it, you'll like it.
Frederick J Eccher Jr
MBA
M.S. Management of Information Systems
A.B. Psychology
B.A. Biology
CIO, Community Partners
President, Board of Directors, Saint Louis Visual Basic Users Group
[...]
Detailed information & instruction on the latest version of Access.......2007-01-12
This book teaches you how to design and maintain databases, search them for information, and build attractive forms using the new version of Access. There's also material on Access programming for automating common tasks. Access 2007 is quite a bit different from previous versions, and has a brand new interface. Once you master Access's new style, you'll be able to build databases rather quickly. The problem is that with Office 2007, you get no printed user guide at all. To learn about the thousands of features included in the software, Microsoft expects you to read the online help. The Microsoft help screens are helpful if you're looking for a quick description of something. If you're seeking information more on the art than science of Access, such as chart creation, you'll find nothing of real use there. This book excels at teaching aspects of Access that involve more wisdom than dictionary definition. This book is divided into seven parts, each containing several chapters:
Part One: Storing Information in Tables. In this part, you'll build your first database and learn how to add and edit tables that store information. Then you'll pick up the skills you need to stop mistakes before they happen, browse around your database, and link tables together.
Chapter 1. Creating Your First Database
Chapter 2. Building Smarter Tables
Chapter 3. Mastering the Datasheet: Sorting, Searching, Filtering, and More
Chapter 4. Blocking Bad Data
Chapter 5. Linking Tables with Relationships
Part Two: Manipulating Data with Queries. In this part, you'll build queries, apply changes, and summarize vast amounts of information.
Chapter 6: Queries That Select Records
Chapter 7: Essential Query Tricks
Chapter 8: Queries That Update Records
Chapter 9: Analyzing Data with Crosstab Queries and Pivot Tables
Part Three: Printing Reports. This part shows you how to use reports to take the raw data in your tables and format it into attractive printouts, complete with fancy formatting and subtotals.
Chapter 10: Creating Reports
Chapter 11: Designing Advanced Reports
Part Four: Building a User Interface with Forms. In this part, you'll build forms, which are customized windows that make data entry easy, even for those new to Access.
Chapter 12: Creating Simple Forms
Chapter 13: Designing Advanced Forms
Chapter 14: Building a Navigation System
Part Five: Programming Access. Shows how to use macros and Visual Basic programming to automate complex tasks and solve common challenges.
Chapter 15: Automating Tasks with Macros
Chapter 16: Automating Tasks with Visual Basic
Chapter 17: Writing Smarter Code
Part Six: Sharing Access with the Rest of the World. In this part, you'll learn how exchange data between Access and files such as text documents and Excel spreadsheets. You'll also see how to use Access to interact with some of Microsoft's server software such as SQL Server and SharePoint Server.
Chapter 18: Sharing a Database with Multiple Users
Chapter 19: Importing and Exporting Data
Chapter 20: Connecting Access to SQL Server
Chapter 21: Connecting Access to SharePoint
Part Seven: Appendix. This book wraps up with an appendix that shows how to customize the Quick Access toolbar to get easy access to your favorite commands.
I found this manual to be head and shoulders above all of the cheap "shovelware" books on such subjects that often have all the information you need, but are disorganized. I haven't seen any of the new versions of the "Que" books that always come out on Access, but I haven't been that satisfied with them in the past. I recommend this book for anybody planning on using Access 2007.
Book Description
This newest programming guide by bestselling author Jesse Liberty isn't your typical Visual Basic book. It's not a primer on the language, and it won't dull your brain with arguments hyping .NET either. Its goal, rather, is to make you immediately productive, creating Windows and Web applications using Visual Basic 2005 and Visual Studio 2005.
Written for VB6 and novice programmers, the book shows how Visual Basic 2005 can be used to rapidly build modern Windows and web applications.
What makes this book different is what's not included. There's no introduction to Visual Basic, no explanation of how it fits into the .NET world. Why waste time reading about something you'll learn for yourself as soon as you start creating applications? You won't even write a "Hello World" program. With Programming Visual Basic 2005 you'll get started building something meaningful, right away.
The book is divided into three parts--Building Windows Applications, Building Web Applications, and Programming with Visual Basic--each of which could be a book on its own. The author shares his thorough understanding of the subject matter through lucid explanations and intelligently designed lessons that guide you to increasing levels of expertise. By the time you've finished the book, you'll know how to program both Windows and web applications with VB 2005.
The support for this book extends beyond its covers. Jesse offers a FAQ, Errata, complete source code and a link to a free private support discussion center on his web site: LibertyAssociates.com - just click on books.
Jesse Liberty, Microsoft .NET MVP, is the best-selling author of O'Reilly Media's Programming ASP.NET and over a dozen other books on web and object-oriented programming. Jesse is a frequent contributor to many industry publications and websites, and has spoken at numerous industry events. He is a former Distinguished Software Engineer at AT&T and Vice President for technology development at CitiBank.
Jesse Liberty's books have successfully guided thousands of programmers into the world of .NET programming, and Programming Visual Basic 2005 is no exception.
Customer Reviews:
Great Second VB Book.......2006-09-26
I have been through many VB books including expensive college texts. I immediately found this to be the best one. I picked it up at a Borders (oops...) because I was sick of ordering books online and not liking them when I finally got them in the mail. After I read the first chapter in the book store, I didn't want to wait to get started so I paid the $40.
I found that something simple like naming conventions or form design can ruin a potentially great book. Jesse Liberty uses the standard naming convention (txtName, btnSelect, etc.) and is not nearly as strict with form design as most books I have been through.
I recommend this as a second book because, though chapter 15 and 16 are superb in describing the basics, the complete beginner may be better off with a "For Dummies" book or something like that.
Some SQL knowledge also makes the book go down easier.
Jesse Liberty Fails to Update the Errata.......2006-06-27
After spending many hours trying to figure why the sample code didn't work, I found the answer buried on Jesse Liberty's message board. A fellow reader points out an error on Jan 21 and as of June 26 Jesse has yet to update his errata. Most tech books have a decent size errata and that is to be expected, but for an author to fail in his responsibility at the cost of many collective hours by his readers is extremely inconsiderate. This book is in my trash can at the moment.
Not a complete transition to VB.Net.......2006-06-07
I absolutely love Jesse's books and articles. However, this book does not have a page dedicated to ADO.Net nor does Jesse talk about the debugging methods of VS 2005.
I understand writing a book is not easy, but I feel these are two critical components of .Net development
VERY VERY HIGHLY RECOMMENDED!!.......2006-05-21
Are you a Visual Basic programmer? If you are, then this book is for you! Author Jesse Liberty, has done an outstanding job of writing a book that makes you productive immediately to create Windows and Web applications using Visual Basic and its associated tools.
Liberty, begins by describing how to respond to events to build interactive applications. Then, the author shows you how to use drag-and-drop controls to create that connectivity, how to query with parameters, and how to build master/detail pages. He continues with a review of built-in browser controls. Next, the author discusses custom controls. Then he shows you how to use GDI+ and other techniques to draw dynamic applications. He also shows you how to detect mouse events and respond to them. Then, he shows you how to integrate legacy Com controls in a managed situation. The author continues by showing you how to create complex and sophisticated Windows applications. Next, he shows you the library of controls created for you to greatly simplify these tasks. Then, the author walks you through the controls that makes mastering pages and navigation a very easy task. He continues by showing you how to update the database and manage multiuser applications. Next, the author discusses personalization. Then, he shows you how to create web services and also how to create applications that use web services. He also takes you into some of the nooks and crannies of this tool. Next, the author provides a review of the visual basic language in detail. Then, he shows you how to use the new generic collections to create type-safe stacks, queues, and dictionaries. Finally, the author provides a slightly more formal overview of the visual basic language.
The goal of this most excellent book is to make you immediately productive, creating Windows and Web applications using Visual Basic and its associated tools. Thus, by creating applications, you will learn Visual Basic as it has evolved for .NET!
Learn Visual Basic 2005.......2006-05-01
What's with the negative reviews on amazon for this book?!? Plain and simple, Jesse Liberty is one of the top technical writers out there in the field today and I have YET to read a book by him that I haven't liked. Who cares if there are a few typos in a book, the main things that I am concerned about are if the writing is good, the layout is easy to follow with images and graphics put in at the right places, and the flow is tight and concise. The author achieves all of these goals in this book -- quite simply, if you use Visual Basic 2005 and you want to become a better programmer and desire to learn from a true expert in the field, pick up 'Programming Visual Basic 2005' today... you won't regret it.
***** HIGHLY RECOMMENDED
Average customer rating:
- VERY HELPFUL
- Very helpful
- Not perfect, but a perfect mix!
- Terrific, concise book on learning atabase Web applications
- This book is very hard to follow.
|
Creating Database Web Applications with PHP and ASP (Internet Series)
Jeanine Meyer
Manufacturer: Charles River Media
ProductGroup: Book
Binding: Paperback
 Graphic Design
| Design & Decorative Arts
| Arts & Photography
| Subjects
| Books
| Airbrush
| Animation
| Books
| Calligraphy
| Clip Art
| Commercial
| Graphic Arts
| Lithography
| Pop Culture
| Printmaking
| Silk Screen & Batik
| Typography
General
| Arts & Photography
| Subjects
| Books
Guides
| Job Hunting & Careers
| Business & Investing
| Subjects
| Books
General
| SQL
| Databases
| Computers & Internet
| Subjects
| Books
Database Design
| Databases
| Computers & Internet
| Subjects
| Books
General
| Databases
| Computers & Internet
| Subjects
| Books
Graphics & Multimedia
| Programming
| Computers & Internet
| Subjects
| Books
| DirectX
| Flash
| GIS
| General
| OpenGL
| Solid Works
Software Development
| Software Design, Testing & Engineering
| Programming
| Computers & Internet
| Subjects
| Books
Structured Design
| Software Design, Testing & Engineering
| Programming
| Computers & Internet
| Subjects
| Books
General
| Programming
| Computers & Internet
| Subjects
| Books
Databases
| Software
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
PHP
| Programming
| Web Development
| Computers & Internet
| Subjects
| Books
General
| Programming
| Web Development
| Computers & Internet
| Subjects
| Books
ASP
| Programming
| Web Development
| Computers & Internet
| Subjects
| Books
General
| Graphic Design
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
All Titles
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Arts & Photography
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Computers & Internet
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Similar Items:
-
Multimedia Communication Systems: Techniques, Standards, and Networks
-
Designing a Digital Portfolio (VOICES)
-
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Second Edition
-
PHP for the World Wide Web, Second Edition (Visual QuickStart Guide)
-
Learning Web Design: A Beginner's Guide to HTML, Graphics, and Beyond
ASIN: 1584502649 |
Book Description
If you want to add more power and functionality to your Web sites, add some database applications like a powerful shopping cart or a fun quiz game. Such applications make your site more dynamic, allow you to gather information, and provide customized experiences for your visitors. Creating Database Web Applications with PHP and ASP teaches beginning and intermediate designers the fundamentals of creating complex Web applications. By covering both open source (PHP/MySQL) and proprietary tools (Microsoft ASP and Access), readers gain insight to the strengths and weaknesses of each. In addition, they learn how to work with both sets of tools and determine which works best for their projects. Practical examples, including a shopping cart and quiz show, are used to teach the basic concepts behind creating and testing database code. Every example is also provided in both PHP and ASP for easy comparison and use. With the knowledge and experience gained here, beginners will learn the fundamental concepts behind these two technologies, while more experienced developers will learn which technology works best for their specific needs. Exercises, questions, and projects are included with each chapter.
Customer Reviews:
VERY HELPFUL.......2004-02-16
Jeanine,
Just wanted to let you know how helpful your book is. Before I thought, it was impractical to have two scripting languages and two databases. I said this because from my experience I started learning database from Access then learn Visual Basic Codes and Scripts. Originally, my field of profession is Financial Accounting. In the early 90's I learn Lotus then migrated to Excel spreadsheet programs. I was not satisfied for what Macros can do so I studied Access database. I was so amazed by it but there are things I know and hope will be easier and faster. I wanted to learn SQL knowing how powerful it is, but because how expensive commerialize DBMS softwares were it made me stick with Access. The internet period has arrived at that time, so I learned ASP with Visual Basic Scripting. I was not totally satisfied with it because VBScript is always tied up to a giant corporation and at the time I was learning HTML, XML &
JavaScript. This made me confuse, what direction am I going. I decided to continue what I learned so far, apply it then to whatever will make it easier. So, I studied ASP with JavaScript Langauge. Consequently, from learning and experience, I read about MySQL and PHP and studied it as well. So far your book is the best and most helpful, in showing how to connect to a server and for sure will SAVE me and my clients alot. Currently, I am a financial administrator and partly the intranet designer of a
University in San Francisco. My goal is to have my own server
company.
Thank you again and more power to you.
John
Very helpful.......2004-02-16
Jeanine,
Just wanted to let you know how helpful your book is. Before I thought, it was impractical to have two scripting languages and two databases. I said this because from my experience I started learning database from Access then learn Visual Basic Codes and Scripts. Originally, my field of profession is Financial Accounting. In the early 1990's I learn Lotus then migrated to Excel spreadsheet programs. I was not satisfied for what macros can do so I studied Access database. I was so amazed by it but there are things I know and hope will make things easier and faster. I wanted to learn SQL knowing how powerful it is, but how expensive commerialize DBMS softwares were it made me stick with Access. The internet period has arrived at that time, so I learned ASP with Visual Basic Scripting. I was still not comfortable & not happy with it because VBScript is always tied up with a giant corporation and at the time I was learning HTML, XML & JavaScript.
This made me confuse what direction am I going but continue what I learned so far, apply it then and whatever will make it easier. So, I studied ASP with JavaScript langauge. Consequently, from learning and experience, I read about MySQL and PHP and studied it as well. So far your book is the best and most helpful, in showing how to connect to a server and for sure will SAVE me and my clients alot. Currently, I am a financial administrator and partly the intranet designer of a university in San Francisco. My goal is to be a free lance web designer and to own a Web design company using MySQL (OPEN SOURCE database), PHP (OPEN SOURCE scripting language), Access database, and Active Server Pages (ASP).
Thank you again and more power to you.
John
Not perfect, but a perfect mix!.......2004-02-16
I'm a seasoned (some would say salty) web developer, and I have been teaching web applications for two years both online and "on the ground." I've looked in vain for the right mixture of theory, practical application and humor (a needed ingredient for this type of instruction). I use this book for intermediate web developer students who have a solid grounding in HTML, CSS and Javascript, and some basic knowledge of either PHP or ASP (or other programming logic). I used to use Wrox's Beginning ASP, but at more than 1000 pages, and more errata than I could cover in a single class, I continued looking. With this book, I think I've found the right text for some of the classes I teach!
Dr. Meyer's work starts with a review of HTML and Javascript, with an emphasis on how to use the DOM in an application setting. Regarding databases, there are chapters explaining application concepts and E-R diagrams, as well as how to use the CLI client for MySQL. The CD-ROM even has SQL instructions for importing the material from the text; and for Access users, db files that mirror the work in the text.
But the real heart of the matter is the instruction in coding practices, from reading and writing to databases (using MySQL and DSN-less Access connections), to using cookies and session variables for data persistance. And this is where this book has no equal: it supports both the hugely popular open-source PHP/MySQL as equally as it shows ASP and Access. I've never seen such a universal attempt pulled off quite as well.
I recommend the book, but no work is perfect. I don't think that a book can equal the combination of education and experience (but as an instructor, I may be biased). The PHP code supplied in the accompanying CD-ROM utilizes global variables (which may be turned off in some production environments for security purposes)--but that underscores the use of the text as a textbook, and not a coding "cookbook" with samples that are "ready-to-eat." Also, the ASP uses the less-common, but more palatable ASP JavaScript (or JScript) instead of the more commonly utilized ASP VBScript (but even third-party ASP interpreters like that used in the SunOne Server handled the code).
I found that students should adapt and improve the code from the CD-ROM as part of their studies, so that they could fix some typos, and learn how code integration works. Also, they needed to create interfaces for the samples so we could stop staring at web forms and add some color to the examples! Students have created portfolio pieces using the concepts in this text like psychological profile tests, e-commerce sites, calendar applications and marketing surveys.
Terrific, concise book on learning atabase Web applications.......2004-02-16
I am very new to computing, having just learned the basics of HTML. I found this book very helpful. First of all, it does start out with basic HTML which was reassuring for me. It then adds JavaScript. It builds up gradually, with many examples in the text. There is also a complete set of code on the CD. The PHP with MySql and the ASP with Access are always compared with general previews. The book has many screen shots.
The book also has some examples of what the screen would look like if you did something wrong which beginners tend to do. I have not seen this pedagogical technique in other texts. I found it very helpful. The chapters on database design and SQL were also very good. I strongly recommend this book. It is an excellent book for anyone new to Web applications or someone with some experience, who wants to know more. In particular, if someone knows one of the technologies featured (PHP, ASP, MySql, Access, SQL) and wants to know how this one technology relates to others, this is a good source. The examples of the book are well-chosen, without any extraneous material, and are explained in a table, with code in one column and explanation in another. I liked the fact that that it is clear and concise since I like most people don't have a lot of time to expend on a lot of unnecessary verbiage.
This book is very hard to follow........2004-01-09
I have created a couple of websites and know HTML pretty well. This book assumes you know ASP inside and out, and if you don't, this is not the right book for you. Even if you do, the book does not explain enough for you to actually create a database. I would recommend the Active Server Pages 3.0 book published by Wrox. I haven't tried their ASP.Net 1.0, but they are good about explaining everything to Newbies and being detailed orientated for programmers with more skill and knowledge. The Active Server Pages 3.0 book has three chapters dedicated to getting your database up and running, in addition to having a sample application that can be run on your own web server using windows 2000.
Average customer rating:
- Just What I Needed
- this book got me started on databases...
- If you own 2 Access books, this should be one of them
- Note to Shannon - DAO is not a problem.
- I'M A COLDFUSION GUY...KEEP THAT IN MIND:
|
Access Database Design & Programming (3rd Edition)
Steven Roman
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback
Database Design
| Databases
| Computers & Internet
| Subjects
| Books
General
| Databases
| Computers & Internet
| Subjects
| Books
Windows - General
| Operating Systems
| Microsoft
| Computers & Internet
| Subjects
| Books
Databases
| Microsoft
| Computers & Internet
| Subjects
| Books
General
| Programming
| Computers & Internet
| Subjects
| Books
General
| Languages & Tools
| Programming
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
Modeling & Simulation
| Computer Science
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
Mathematics
| Professional Science
| Professional & Technical
| Subjects
| Books
| Applied
| Chaos & Systems
| Geometry & Topology
| Mathematical Analysis
| Mathematical Physics
| Number Systems
| Pure Mathematics
| Transformations
| Trigonometry
Similar Items:
-
Access Cookbook, 2nd Edition
-
Integrating Excel and Access
-
VB and VBA in a Nutshell: The Languages
-
Access Hacks: Tips & Tools for Wrangling Your Data (Hacks)
-
Writing Excel Macros with VBA, 2nd Edition
ASIN: 0596002734 |
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
Access Database Design & Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. When using software products with graphical interfaces, we frequently focus so much on the interface that we forget about the general concepts that allow us to understand and use the software effectively. In particular, this book focuses on three areas:
-
Database design. The book provides an enjoyable, informative overview of database design that carefully shows you how to normalize tables to eliminate redundancy without losing data.
-
Queries. The book examines multi-table queries (i.e.,various types of joins) and shows how to implement them indirectly by using the Access interface or directly by using Access SQL.
-
Programming. The book examines the VBA integrated development environment (IDE). It then goes on to provide an excellent introduction to Data Access Objects (DAO), ActiveX Data Objects (ADO), and ADO Extensions for Data Definition and Security (ADOX). These sections serve as a handy introduction and primer for basic database operations,such as modifying a table under program control, dynamically adding and deleting a record, and repositioning a record pointer. The concluding chapter focuses on common programming problems, such as computing running sums and comparing two sets.
Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, Access Database Design &Programming instead focuses on the core concepts, enabling programmers to develop solid, effective database applications. This book also serves as a 'second course' in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to develop successfully in the Microsoft Access environment. Anyone interested in learning Access in depth, rather than just scraping the surface, will enjoy and benefit immensely from reading this book.
Customer Reviews:
Just What I Needed.......2006-02-02
In seeking out materials to train myself on Access 2003, I have found several books that have done adequate or good jobs of teaching the program. Most of them, however, did not do so well on teaching database theory or on instructing in how to use the native programming environment. This book helped to fill in the gaps. It is not perfect but it certainly was a good place to start.
The treatment of database theory is just that. It is a treatment of theory. It explains the concepts in a semi-rigorous manner which is dry but still informative. The notation is sometimes a trial to follow but that is the nature of the beast. When things are put in terms of equations, they just do not read as interestingly as a prose novel. Although this information is presented with Access in mind, it would be applicable to anyone who wants to learn about databases.
The treatment of the programming elements is no less dry but it too is informative. Again, reading lines of code does not strike me as an exciting way to pass the afternoon but it got the job done. The examples are as clear as the syntax allows and make the points well.
I should point out that I did not actually try the code presented in this book. I read the examples to learn the concepts. I cannot testify as to how well the code worked in a "real" environment.
While I will certainly be looking for other references and learning materials, this was a good choice for my first foray past just learning the basics of the application itself.
this book got me started on databases..........2005-11-17
Years ago, I've picked this book up to learn Access... I haven't used Access for quite a while now (mostly an Oracle person now), but I still have fond memories of this book. Not only does this book teach you Access, and it does that very well, it also go through the database fundamentals. An overall great book, imho.
If you own 2 Access books, this should be one of them.......2005-06-07
I first read Steven Roman's book on Access a few years ago when it was written for Access 97. I recently bought a copy of the current version as a reference.
What I liked about Steven's books was that he took seriously his coverage of normalization, which is rare amongst books on Access. If you're new to database programming, you need to learn the basics of normalization. In my experiences, I've come across a lot of databases designed by beginners that exhibit a "spreadsheet" type of understanding towards Access tables. The beauty of the relational model is that once you have your database set up, ongoing maintenance is minimal. If you learn how to program Access, but don't learn the basics of normalization and the relational model, you may as well just keep your data in Excel spreadsheets.
My complaint with this book is his coverage of ADO. The author clearly prefers DAO for MS Access, and he states as much, and his coverage suffers. He covers the material, but he makes using ADO appear to be very difficult. In an entire chapter on ADO, he fails to show the user the most basic thing: how to generate a recordset for a table in your Access database. Instead, he shows you how to use ADO to query other databases, such as SQL Server and even Excel, but not the Access Database that you're currently using.
In DAO one of the fundamental details that you need to know about is the CurrentDB object. Steven gets a gold star, because he not only covers the CurrentDB object, but he spends 6 pages on it. In ADO, an object that is used for a somewhat similar purpose is the CurrentProject object. You won't find coverage on it anywhere in this book - just check the index. Perhaps the author's surreptitious goal of the chapter is to frustrate you so much with ADO that you will return to DAO, his preferred choice. Tsk, tsk Steven.
After reading the books section on ADO over and over again, I cannot recommend this book if you plan on owning only one Access book. Instead, I would recommend Alison Balter's Mastering Access Databases. It is the best Access book on the market(as most Amazon reviewers will attest to) and covers nearly ever topic that you'd want to know about Access.
Even so, Steven's book covers normalization so much better than the other Access books out there that I would advise serious Access programmers to buy two books: Alison's and Steven's.
Note to Shannon - DAO is not a problem........2005-05-18
I haven't read this book, yet. But, reviewer, Shannon, complained about not being able to get it to work with DAO. The problem is in References. Her database is probably set with a reference only to ADODB.
In Module View, just select Tools | Reference and select DAO (Data Access Objects) as the reference. Then, you should be fine.
I'M A COLDFUSION GUY...KEEP THAT IN MIND:.......2004-11-12
For a ColdFusion developer, to graph where your interests would probably be, it would look like an inverted bell curve: the beginning is splendid, the middle just wouldn't apply, and the end is worth coming back for.
The beginning of the book talks about stuff that we need to make sure we get down well, regardless of our database platform: Access, SQL Server, Oracle, Sybase - doesn't matter. The first couple of chapters
talk about stuff that is universally applicable, and under-appreciated:
* Normalization of tables, including first, second, and third normal form. As most experienced database designers know, you may not be able to glance at a database and know second from third, but you
should take the time to learn the principles of normalization.
* Referential integrity between parent and child tables
* Relationship types: one-to-one, one-to-many, and many-to-many
* Join types: inner and outer
Up to about page 120, ColdFusion developers are all clear. About there, Chapter 7 gets into Access VBA specific problems about accessing and manipulating data, creating DAO connections, and how to
programmatically manipulate data using VBA. This is interesting stuff in and of itself, but probably not to a ColdFusion developer.
Picking up in Chapter 19, "Some Common Data Manipulation Problems," the party starts again, talking about complex select queries and joins.
From an Access standpoint, this book is chock full of goodies. From the point of view of a ColdFusion developer, I would say this much: if forced to choose between this book and the previous, the Cookbook, I would probably go Cookbook. But, as I mentioned in the previous review, if you work with both Access on the desktop and on the web, using ColdFusion, both of these are good, useful, handy references. Having a greater appreciation of what goes on behind the scenes in Access may help gain a greater appreciation for the larger picture.
Customer Reviews:
There is better one.......2006-12-14
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.......2004-12-11
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.......2004-05-11
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 !!.......2004-02-29
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.......2004-02-20
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 uses AbstractFactory 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.
Average customer rating:
- My favorite ADO book
- A perfect book for ADO
- Visual Basic ADO Book
- Its all here.
- GREAT - Data Shaping Chapter
|
ADO : ActiveX Data Objects
Jason T. Roff
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback
ActiveX
| Programming
| Web Development
| Computers & Internet
| Subjects
| Books
General
| Programming
| Web Development
| Computers & Internet
| Subjects
| Books
Distributed Databases
| Databases
| Computers & Internet
| Subjects
| Books
Database Design
| Databases
| Computers & Internet
| Subjects
| Books
General
| Databases
| Computers & Internet
| Subjects
| Books
Visual Basic
| Development
| Microsoft
| Computers & Internet
| Subjects
| Books
| .Net
| C#
| C++
| Visual Studio
Object-Oriented Design
| Software Design, Testing & Engineering
| Programming
| Computers & Internet
| Subjects
| Books
Structured Design
| Software Design, Testing & Engineering
| Programming
| Computers & Internet
| Subjects
| Books
General
| Programming
| Computers & Internet
| Subjects
| Books
General
| Languages & Tools
| Programming
| Computers & Internet
| Subjects
| Books
Data Structures
| Algorithms
| Programming
| Computers & Internet
| Subjects
| Books
Information Systems
| Software Engineering
| Computer Science
| Computers & Internet
| Subjects
| Books
General
| Computer Science
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
Web Programming
| Programming
| O'Reilly
| By Publisher
| Books
General
| Programming
| O'Reilly
| By Publisher
| Books
Similar Items:
-
Serious ADO: Universal Data Access with Visual Basic
-
ADO Programmer's Reference
-
DAO Object Model: The Definitive Guide
-
Access Cookbook, 2nd Edition
-
VB and VBA in a Nutshell: The Languages
ASIN: 1565924150 |
Book Description
Getting data across platforms and formats is a cornerstone of present-day applications development. ADO: ActiveX Data Objects is both an introduction and a complete reference to ADO (ActiveX Data Objects), Microsoft's universal data access solution. You'll learn how to easily access data in multiple formats--such as email messages, Access databases, Word documents, and SQL databases--even on different platforms, without spending extra time learning every last detail about each format. Author Jason Roff shows by example how to use ADO with your programming language of choice to save programming time, so you can concentrate on the content and quality of your application rather than the nitty-gritty of specific data formats. ADO: ActiveX Data Objects includes:
- Chapters dedicated to the Connection, Recordset, Field, and Command objects and the Properties collection
- A complete, detailed reference listing every ADO object, method, property, and event, in convenient alphabetical order
- Chapters on ADO architecture, data shaping, the ADO Event Model
- An appendix containing enumeration tables used by ADO objects and collections, listed alphabetically
- Brief introductions to RDS, ADO.NET, and SQL
ADO: ActiveX Data Objects is a versatile one-stop guide to both the theory and practice of programming with ADO through Version 2.6. The thorough reference section and topic-specific chapters will help you find quick answers about the details of objects, collections, methods, and properties of ADO. And the abundance of practical code examples will give you a good grasp of how to use ADO's strong points most effectively.
Customer Reviews:
My favorite ADO book.......2006-12-08
I have also read Programming ADO from David Sceppa and I prefer this one because it contains a lot examples with source code. My only complain is that there is only a small C++ program and the rest are all in Visual Basic. However, this is not a big issue as it is very easy to port the samples in C++.
A perfect book for ADO.......2004-02-28
this is a very good book, comparing to MSDN ADO note on the web, which covers only access to .mdb database, this book covers a variety of methods and databases. Thank for the great contribution.
Visual Basic ADO Book.......2002-09-24
This is a well written book for existing programmers who want to learn ADO. While the examples are in Visual Basic, the core concepts of ADO are very detailed and anyone with an understanding of a similar language, such as ASP or C++ should have no trouble applying the examples to the other language. It will not help you if you don't already know how to program.
It also serves as a good reference book.
Its all here........2002-08-12
You can't get a more complete ADO book.. ever gritty detail is in this book.. It's almost too much information. :- ) if you code ADO. This is a good book to have.
Cheers
Wayne lambright
GREAT - Data Shaping Chapter.......2001-09-20
I bought this book for one chapter - data shaping, and it turned out to be the only place that I found that was able to explain it in a way that I could understand. The author has a knack for thoroughly explaining the material. I also found the appendix on SQL helpful.
Book Description
Presents strategies for application development, interface design, and enabling Web-based access.
* Includes numerous case studies and examples from the private and public sectors.
* Provides information on integrating legacy MIS systems and planning for future developments in database design.
Customer Reviews:
Good content, bad writing.......2007-02-11
Based on content and organization, it's good, maybe really good. But the poor writing makes it hard to read. It's also kind of expensive.
I was new to GIS design and implementation, so I can't compare this to what else is out there on these topics. I do have some experience with databases and GIS software, so I'm not that green to the concepts. I'm a thorough reader and like for reading to flow, especially when it's explaining something techy. This book has many punctuation errors (e.g. a period where a comma should be), uses the wrong word (e.g. their for there, or where for were), uses the wrong form of the verb "is", uses plural where it's really singular, etc. Sometimes a sentence is just worded in a way that makes it difficult to follow.
I have learned a lot about design and implementation of GIS with this book. I just wish it would have been less taxing to get through.
Book Description
Maybe you got Access as part of Microsoft Office and wonder what it can do for you and your household; maybe you're a small business manager and don't have a techie on staff to train the office in Microsoft Access. Regardless, you want to quickly get your feet wet--but not get in over your head--and Access 2003 for Starters: The Missing Manual is the book to make it happen.
Far more than a skimpy introduction but much less daunting than a weighty tech book, Access 2003 for Starters: The Missing Manual demystifies databases and explains how to design and create them with ease. It delivers everything you need--and nothing you don't--to use Access right away. It's your expert guide to the Access features that are most vital and most useful, and it's your trusted advisor on the more in-depth features that are best saved for developers and programmers.
Access is sophisticated and powerful enough for professional developers but easy and practical enough for everyday users like you. This Missing Manual explains all the major features of Access 2003, including designing and creating databases, organizing and filtering information, and generating effective forms and reports.
Bestselling authors, database designers, and programmers Scott Palmer, Ph.D., and Kate Chase are your guides for putting the world's most popular desktop data management program to work. Their clear explanations, step-by-step instructions, plenty of illustrations, and timesaving advice help you get up to speed quickly and painlessly.
Whether you're just starting out or you know you've been avoiding aspects of the program and missing out on much of what it can do, this friendly, witty book will gently immerse you in Microsoft Access. Keep it handy, as you'll undoubtedly refer to it again and again.
Customer Reviews:
VERY WORTHWHILE.......2006-08-03
If you are new to Access and want to learn how to do things, this book is very helpful. If you are an experienced user and want to become an expert, this book may not have everything you need. We use this manual in conjunction with the Video Professor and between the two, we are now very comfortable with Access.
Wow - exactly what it says!.......2006-04-06
I own a Network Consulting firm which handles IT for Small to Medium businesses. That said, I know zilch about Microsoft Access. Recently a client asked I provide them with a simple inventory managment database. While I actually set them up with an out of box solution, I figured I should learn Access to possibly do our own development.
This book is really fantastic. I own plenty of tech books; some good, and some not so good. I rated this book high for the two things it does really well:
1. It shows you a nice view of what you *can* do in terms of options at each stage of building/working with a database, and explains them.
2. It applies the information with easy to follow, yet not stupidly simple projects.
I went through 130 pages today alone and if the wife wasn't bugging me to death, would probably knock out a chapter or two more before bed.
Great book. The title explains it all.
Great Way To Learn Access.......2005-12-30
The Pogue Press line does it again!! When I looked down at the retail price for this book I couldn't believe my eyes. If you are new to Microsoft Access and want to ramp up quickly on how to use this exciting application, you would be hard-pressed to find a better bargain to get up to speed in no time.
I usually write longer reviews, but for the price that this book is listed at, this would inefficient and a waste of time. If you want to learn how to use Access 2003, stop reading and pick up this book today!!
***** HIGHLY RECOMMENDED
Average customer rating:
- batteries not included... or CD rather.
- Piece of Garbage
- Good only if you're a newbie
- Not Pen Testing
- Akil's review of "Hack I.T." - Newcomer's paradise
|
Hack I.T.: Security Through Penetration Testing
T. J. Klevinsky ,
Scott Laliberte , and
Ajay Gupta
Manufacturer: Addison-Wesley Professional
ProductGroup: Book
Binding: Paperback
Encryption
| Security & Encryption
| Web Development
| Computers & Internet
| Subjects
| Books
Privacy
| Business & Culture
| Computers & Internet
| Subjects
| Books
Hacking
| Business & Culture
| Computers & Internet
| Subjects
| Books
Security
| Business & Culture
| Computers & Internet
| Subjects
| Books
Network Security
| Networking
| Computers & Internet
| Subjects
| Books
General
| Networks, Protocols & APIs
| Networking
| Computers & Internet
| Subjects
| Books
Network Programming
| Networking
| Computers & Internet
| Subjects
| Books
Testing
| Software Design, Testing & Engineering
| Programming
| Computers & Internet
| Subjects
| Books
General
| Programming
| Computers & Internet
| Subjects
| Books
Systems Analysis & Design
| Computer Science
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
General
| E-commerce
| Industries & Professions
| Business & Investing
| Subjects
| Books
French
| Foreign Language Nonfiction
| Nonfiction
| Subjects
| Books
Nonfiction
| French
| Foreign Language Books
| Specialty Stores
| Books
All French Books
| French
| Foreign Language Books
| Specialty Stores
| Books
All Titles
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Business & Investing
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Computers & Internet
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Similar Items:
-
SANS GIAC Certification: Security Essentials Toolkit (GSEC)
-
Hacking Exposed
-
Malware: Fighting Malicious Code
-
Incident Response and Computer Forensics, Second Edition
-
Inside Network Perimeter Security (2nd Edition) (Inside)
ASIN: 0201719568 |
Customer Reviews:
batteries not included... or CD rather........2006-11-10
I bought this book for a graduate level class I'm currently taking. The book arrived without the "included CD." Amazon quickly cross-shipped a replacement book. Unfortunately, this one was also missing the CD. As I later found out... even in brick and mortar stores, the book doesn't have the "included CD."
You can download the CD contents from the publishers website.
The book is pretty good. Easy read. The author does a great job of covering the topics in-depth. Each chapter also has an example case study.
Piece of Garbage.......2006-03-17
Understand firstly that this book is old. Wait, one more time, OLD. The amusing thing is one of the authors still tries to shine light on this trash and use it to try and sell security work for the joke of a practice he runs. Give me a b-a-reak. Fed up with with trash like this on a market. If you're dumb enough to buy this book becuz the nuklehead convinced you it was cutting edge - then back slowly away from the book, run it through a shredder and then stick in your cats litter box.
Good only if you're a newbie.......2004-04-20
This book is good ONLY if you're a newbie. If you're in the field, save you're money and buy something with some teeth to it. Such as, Hacking Exposed. The title itself is very misleading. There is no Pen testing. Unless you get all the tools they talk about and launch an attack. The authors are also a little biased on their choices of tools. I can think of better tools to use, in some situation, then what they suggest. All-in-all, it's just an OK book, if you're new...really new.
Not Pen Testing.......2004-04-16
After reading through this book, it was clear that it teaches you nothing about:
1) Penetration testing
2) Securing your environment
What it does go over are all the possible tools you can download out there, and how you can randomly hack things around you.
Moreover, it is light on methodology, and only touches on operating system and application level security.
This book is a bad idea for those new to pen testing: seek other resources. It is even worse for professionals, who should be cautious altogether.
Akil's review of "Hack I.T." - Newcomer's paradise.......2003-11-09
A Class piece of literature. Well-written, by guys who obviously have experience of both hacking, and Security Consultancy. I consumed the 500 pages over a marathon four days. It was well worth the hours I put aside for this task.
The book has a nice 'human' touch, and makes the reader very aware of the expectancies of corporate clients (those that may employ 'Penetration Testers').
Many of the links to 'tools' are no longer up, but there are many alternatives (as a simple google search will reveal). And of course a CD is included with the book to get you up and running in terms of some basic tools.
This book is a 'must-have' for guys (like myself) new to the Security/Penetration Testing field. Great work Klevinsky/Laliberte/Gupta. Give us more!!!
Books:
- Interior Lighting, Fourth Edition
- Interior Photography: Lighting and Other Professional Techniques with Style
- Kitchen Confidential: Adventures in the Culinary Underbelly
- Land Development Handbook (Handbook)
- Leading Teams: Setting the Stage for Great Performances
- Living In Paris (New Edition) (Living In...)
- Living In Paris (New Edition) (Living In...)
- Making Mosaics: Designs, Techniques & Projects
- Master Handbook of Acoustics
- Materials and Components of Interior Architecture (6th Edition)
Books Index
Books Home
Recommended Books
- Workers' Control in America: Studies in the History of Work, Technology, and Labor Struggles
- So That's What They're For!: The Definitive Breastfeeding Guide 3rd edition
- Fundamentals of Music, Fourth Edition
- Internet Business Models and Strategies: Text and Cases
- Information Theory, Inference & Learning Algorithms
- Swimming to Antarctica: Tales of a Long-Distance Swimmer
- Lonely Planet Southeast Asia on a Shoestring
- Corporate Governance, Financial Markets and Global Convergence
- IR: The New World of International Relations
- Unraveled Sleeve
Microsoft Access Data Analysis: Unleashing the Analytical Power of Access
Excel Advanced Report Development
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series)
Pivot Table Data Crunching (Business Solutions)
