Building Microsoft Access Applications (Bpg Other) | 
 enlarge | Author: John L. Viescas
Publisher: Microsoft Press
Category: Book
List Price: $49.99
Buy New: $23.82
You Save: $26.17 (52%)
New (28) Used (6) from $23.82
Rating:  11 reviews
Sales Rank: 47110
Platform: No Operating System
Media: Paperback
Pages: 768
Number Of Items: 1
Shipping Weight (lbs): 3.1
Dimensions (in): 9 x 7.2 x 1.9
MPN: 0-7356-2039-3
ISBN: 0735620393
Dewey Decimal Number: 005.7565
UPC: 790145203939
EAN: 9780735620391
Publication Date: February 23, 2005
Availability: Usually ships in 1-2 business days
| |
| Similar Items:
|
| Editorial Reviews:
Product Description
Get expert design guidance and fully functional sample databases from John L. Viescaspopular author, consultant, and Microsoft Most Valuable Professional (MVP) for Access. Designed for everyone from Access power users to application developers to beginners, this book focuses on four of the most common database types: Inventory Management, Membership Tracking, Customer Support, and Registration Management. For each, youll walk through usage scenarios, design considerations, typical problems, and multiple solutions, along with complete sample databases. Youll examine the logic behind the table design for the application type and see how to use it as a template for quickly creating your own Access solutions. You get everything you need to design with confidence, avoid common pitfalls, and hit the ground running! For each of four common database types, explore a range of solution options from the simple to the complex. Review query, form, report, and code examples specific to each application type. Use the table designs in the sample databases to model your own solutions. The book is geared for power users who work with everything from Access 2000 to Access 2003. The CD includes eBook and complete database solutions for Microsoft Office Access 2002 and Access 2003 The author has been recognized as a Microsoft MVP for Access every year since 1993.
|
| Customer Reviews: Read 6 more reviews...
 I've learned much in the first 3 chapters March 27, 2005
Allan Bach (Allentown, PA USA)
45 out of 45 found this review helpful
As a self-taught Access developer for the past eight years, I have an extensive library of books dealing with beginneing to advanced areas of Access. I bought this book to add to my library, figuring it to be another reference item. However, in a casual browsing of the content, I discovered this book has much more to offer. I was pleasantly surprised to see information on levels of magnitude for linked tables, never having known that the number of sub folders for linked tables can affect the speed of reading from them.
Each of the sample databases has more than enough explanation and code to fully understand the how and why of the application.
After reading only the first three chapters, I have learned much that I was never aware of. I thought I understood Single and Double number types, but was re-educated by the information on page 18. Pages 32 and 33 taught me some new things about the difference between format and input mask.
I am now much better at my development, and I haven't yet finished the book. Excellent work, Mr. Viescas!
Excellent Books Showing Application Development February 8, 2005
John Matlock (Winnemucca, NV)
22 out of 22 found this review helpful
Microsoft Access is of course a database. But it's really much more than that. With its front end forms design capability and the integral report generating system, it is well suited for quite a number of small applications. I say small, because you aren't going to use Access to handle the operations of a Fortune 500 company.
There are a lot of books that teach about the basics of Access. They however tend to talk strictly about how to do the programming portion only. They do not go into the practical aspects of database, forms, or report design.
This book takes you deeply into the design of four small and rather simple applications. This way you can see what is needed to actually make an application that is really useful. It is unlikely that you'd actually run one of these applications as is, even if they were applicable to your business, you or your boss would want something changed. But with the knowledge you would get from the rest of the book, this should be a doable task.
There is one combined plus and minus about this book. The plus, it has an excellent introduction to SQL programming, one of the best I've ever seen. The minus is that the SQL is based on the JET engine database. Access now ships with both JET and MSDE which is a much better engine. I suspect that Microsoft will make MSDE the standard engine in the future. Even with this negative, this is an excellent book.
Very Solid, useful book for development of Access Applications. June 29, 2005
Clyde Hyde (NYC)
19 out of 19 found this review helpful
Easy to read first few chapters with basic design info, remainder of the book focuses on complete applications that can serve as a template/best practice for almost any other MS Access application.
Viescas clearly understands/communicates an in depth knowledge of Access Applications that I have not seen anywhere else.
The right stuff March 25, 2005
Arvin Meyer
14 out of 17 found this review helpful
This book has 4 complete database applications done in a manner which Codd and Date would be proud of. It's not another book of code or a book of dry procedural language. It's more than that. It takes the reader through the steps required to build a credible application.
As a Microsoft MVP, it has been my pleasure to have known John personally for 5 years. He continues to impress me with his knowledge of databases and SQL. His books are required reading for new Access users and certain to teach even this old dog some new tricks.
--
Arvin Meyer, MVP
Microsoft Access
How to contact the author... February 28, 2005
John L. Viescas (Paris, France)
26 out of 41 found this review helpful
The "About the Author" page about 5 pages inside the back cover tells the reader to contact the author via the author's website at http://www.viescas.com/.
To use the calendar control mentioned on page 634, you must also import the modUtility module. You will get compile errors if you don't include that module.
|
|
|
