Building Microsoft Access Applications
- ISBN-10
- 0735620393
- ISBN-13
- 9780735620391
- Category
- Computers / Database Administration & Management
- Pages
- 679
- Language
- English
- Published
- 2005
- Publisher
- Microsoft Press
- Author
- John L. Viescas
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.
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].
Get the book
Similar books
-
Microsoft Access应用大全/Building Microsoft Access applications
By John Viescas, J. L.·维斯卡斯Microsoft Access应用大全/Building Microsoft Access applications
-
Extend Microsoft Access Applications to the Cloud
By Andrew CouchLearn how to create an Access web app, and move your database into the cloud. This practical book shows you how to design an Access web app for Microsoft Office 365, and convert existing Access desktop databases to a web app as well.
-
Expert One-on-One Microsoft Access Application Development
By Helen FeddemaWhat is this book about?Expert One-on-One Microsoft Access Application Development teaches Access developers best practices for building effective Access-based applications.
-
Expert One-on-One Microsoft Access Application Development
By Helen FeddemaEven if you don't have a multiboot setup for different Office versions, you can still use this technique, by placing the Office 2000 versions of the Outlook, Word, and possibly other object library files in a folder on your computer ...
-
Building Access 2 Applications: Using Point-and-Click Programming
By John Dranchak, Joseph R. LaCroceThe authors use their business experiences to give you real world examples for building Access applications. This book uses a case study and step-by-step examples to build a Contact Manager application.
-
Access 2010 Programmer's Reference
By Teresa Hennig, Geoffrey L. Griffith, Rob CooperWith this book, you'll discover the benefits of using the newest features to build small- to medium-scale database applications, integrate with other programs, create Web applications, and upgrade existing solutions.
-
Access 2007 Bible
By Cary N. Prague, Michael R. Irwin, Jennifer ReardonMichael R. Groh, Joseph C. Stockman, Gavin Powell, Cary N. Prague, Michael R. Irwin, Jennifer Reardon ... A special thank you to Erik Rucker, Clint Covington, Michael McCormack, Jensen Harris, Shavaj Dhanial, and the rest of the ...
-
Building VBA Apps: Using Microsoft Access 2010
By F. Mark SchiavoneThe books in this series focus on a task-based approach to learning Microsoft Access and therefore differ from other books that feature a complete review of all the commands and tools available in Microsoft Access.
-
Introductory Relational Database Design for Business, with Microsoft Access
By Jonathan Eckstein, Bonnie R. SchultzThis text: Takes a hands-on approach using numerous real-world examples drawn from the worlds of business, finance, and more Gets readers up and running, fast, with the skills they need to use and develop relational databases with Microsoft ...
-
Access 2010 All-in-One For Dummies
By Margaret Levine Young, Alison Barrows, Joseph C. StockmanRead the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most.