Access Cookbook Solutions to Practical User Interface and Programming Problems
| PC Community Computer Users Group | |||
| Helping each other and our community use computer technology | |||
Access Cookbook
by Bud Gallagher
October 2002
Access Cookbook is a book for the Access user who wants to create database applications that are more than wizard-created clones of every other database application. The book is organized into 14 chapters, each of which focuses on a particular topic in using or programming Access. Each chapter consists of a single question and its solution. Each solution contains a simple database with complete construction details, what controls you need to create and what events you need to handle. All the code and tools needed are included on the CD-ROM that comes with the book.
Chapter 1 – Queries This chapter covers the many types of queries in the Access environment. Queries are the heart of Access and learning how to use them intelligently will make your work in Access go much more smoothly. The chapter covers simple queries to the most complex such as cross tab and DDL (Data Definition Language) queries.
Chapter 2 – Forms This chapter shows you how to make forms do what you want them to do. Multipage forms, popup forms and incremental search list boxes are some of the form types covered.
Chapter 3 – Reports The Access report writer is very flexible and allows a great deal of customization. This chapter shows you how to create attractive and useful reports. Some of the examples in this chapter require programming.
Chapter 4 – Developing and Distributing Applications This chapter contains tips and suggestions for making your application development go more smoothly. It raises a number of issues that developers run across as they ready the application for distribution.
Chapter 5 – Taming your printer This chapter introduces the printer object and its properties. It shows you how to perform tricks that were difficult, if not impossible in early versions of Access. Access 2002 required for most of the examples in this chapter.
Chapter 6 – Managing Data This chapter shows ways of working with data that traditional database operations don’t support. Learn how to filter data, back it up, locate it and perform sound-alike searches. VBA needed but the book does a good job explaining the methods used.
Chapter 7 – Exploring VBA in Microsoft Access Information in this chapter includes handling embedded quotes in strings, creating procedure stacks and code profiles. This chapter is very technical and is n geared to the intermediate level or better programmer.
Chapter 8 – Optimizing Your Application This chapter shows steps you can take to make your databases work as smoothly as possible. Topics include optimizing queries, forms and VBA.
Chapter 9 – Making the Most of Your Interface This chapter shows you methods to make you user interface stand out and be easy to use. Many different techniques are shown. Methods include combo boxes that accept data, animated buttons and many more.
Chapter 10 – Multiuser Applications This chapter covers networking database problems. Multiple Users, file locking and security are covered in detail. A must read if your database is going on a network.
Chapter 11 – The Windows API This chapter explains how to use the built in features in the Windows API. The chapter contains many examples on accessing the API such as restricting mouse movement to a specific area on the screen and many other useful tricks available in the API.
Chapter 12 – Automation This chapter covers interfacing your Access Application to Microsoft Office Applications. It shows how to use an Excel spreadsheet in your Access Program and how to import and export data between the applications
Chapter 13 – Using Data Access Pages This chapter covers using Access applications on systems and networks that do not have Access on them. This requires Access 2000 or Access 2002.
Chapter 14 – Working with SQL Server Data This chapter shows how to take advantage of the new data options available in Access Data Projects which connect directly to a SQL Server Database. Something that I will never use and I am sure would only be used by programmers programming for big business.In summary, Access Cookbook is a very good book and even though I would never need the information contained in several of the chapters I would recommend it to anyone doing Access programming.
 |
Product Information:Access Cookbook Ken Getz, Paul Litwin & Andy Baron, Authors. |
All reviews © PC Community and the individual authors.
| a | ||||||
| Home | For Members | Join PCC | About PCC | Contact Us | ||
PC Community, P.O. Box 55513, Hayward, CA 94540-0513
Copyright 2008
Last Updated on July 4, 2005 2:39 PM by Webmaster