 Trade In this Item for up to £0.25
Trade in Building Access Applications Book/CD Package (Bpg Other) for an Amazon.co.uk gift card of up to £0.25, which you can then spend on millions of items across the site. Plus, get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
Get fully functional database samples and table designs for four of the most common Microsoft Access database types—and use them as templates to create your own Access solutions. Database expert and Microsoft MVP John L. Viescas provides the detailed guidance you need to customize your own solutions from these application types:
- Membership Tracking
- Inventory Management
- Customer Support
- Reservations Management
For each type, you’ll walk through typical usage scenarios, design considerations, and common pitfalls. You’ll examine the logic behind each application’s table design, and learn how to adapt it for your own Access solution.
Get expert insights and examples to help you:
- Learn specific design techniques to improve your table structures
- Build forms with an attractive, intuitive, and easy-to-use interface
- Create queries, forms, and reports specific to each application type
- Design for client/server from the start?and share data more efficiently
- Apply best practices to help your application run more smoothly
- Avoid the 10 most common design problems—and deliver more robust solutions!
Note: This book covers Microsoft Office Access 2003, Access 2002, and Access 2000
CD includes database samples and a fully searchable eBook.
Use the sample databases on CD to model your own solutions for:
- Membership Tracking: Enter, track, and manage member information and communications.
- Inventory Management: Track and manage stock and create purchase orders, invoices, and packing lists.
- Customer Support: Track contacts, enter customer details, identify follow-up items, and create reminders.
- Reservations Management: Manage course registrations, car rentals, room reservations, and more.
From the Back Cover
About the Author: John L. Viescas is the author of Microsoft Office Access 2003 Inside Out and the top-selling Running Microsoft Access books from Microsoft Press. He is president of Viescas Consulting, Inc., a respected provider of database application design and editorial consulting services. He has been recognized by Microsoft Product Support Services as a Most Valuable Professional (MVP) every year since 1993 for his contributions to the community of Access users. Product Description: Get expert design guidance and fully functional sample databases from John L. Viescas- popular 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 five of the most common database types: Inventory Management, Membership, Customer Support/Event Tracking, Reservation Management, and Questionnaire/Statistical Analysis. For each, you'll walk through usage scenarios, design considerations, typical problems, and multiple solutions, along with complete sample databases. You'll 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!
Inside This Book
(Learn More)
First Sentence
Even experienced Access developers occasionally commit design errors. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index
Even experienced Access developers occasionally commit design errors. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
14 reviews
48 of 48 people found the following review helpful
I've learned much in the first 3 chapters
27 Mar 2005
Format:Paperback|Amazon Verified Purchase
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!
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!
20 of 20 people found the following review helpful
Very Solid, useful book for development of Access Applications.
28 Jun 2005
Format:Paperback
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.
Viescas clearly understands/communicates an in depth knowledge of Access Applications that I have not seen anywhere else.
23 of 24 people found the following review helpful
Excellent Books Showing Application Development
8 Feb 2005
Format:Paperback
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.
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.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
