Michael R. Groh
is a well-known author, writer, and consultant specializing in Windows database systems. His company, PC Productivity Solutions, provides information-management applications to companies across the country. Over the last 25 years, Mike has worked with a wide variety of programming languages, operating systems, and computer hardware, ranging from programming a DEC PDP-8A using the Focal interpreted language to building distributed applications under Visual Studio .NET and Microsoft SharePoint.
Mike was one of the first people outside of Microsoft to see Access in action. He was among a select group of journalists and publishers invited to preview the Access 1.0 beta (then called Cirrus) at the 1992 Windows World Conference in Chicago. Since then, Mike has been involved in every Microsoft Access beta program, as an insider and as a journalist and reporter documenting the evolution of this fascinating product.
Mike has authored parts of more than 20 different computer books and is a frequent contributor to computer magazines and journals. Mike has written more than 200 articles and editorials over the last 15 years, mostly for Advisor Media (San Diego, CA). He frequently speaks at computer conferences virtually everywhere in the world, and is technical editor and contributor to periodicals and publications produced by Advisor Media.
Mike holds a master’s degree in Clinical Chemistry from the University of Iowa (Iowa City, IA) and an MBA from Northeastern University (Boston, MA).
Mike can be reached at AccessBible@mikegroh.com. Please prefix the e-mail subject line with “AccessBible:” to get past the spam blocker on this account.
Joseph C. Stockman is an independent consultant, software designer, and author who has been using Microsoft Access since its initial release. He has also developed courseware and taught classes in Access and VBA. Joe developed his first application in Access, and then migrated into Visual Basic and Visual Basic .NET, where he specializes in creating applications for the Windows Mobile platform. He worked for several software companies before forming his consulting business in 2002, where he deals with all types of clients including healthcare, financial, government, manufacturing, and small business. His ability to turn his customers’ wishes into working applications keeps them satisfied. Joe is also writing the fundamentals column for the Advisor Guide to Microsoft Access magazine.
Gavin Powell is a computer consultant and a writer, with over 20 years of IT experience and over 10 titles to his credit. He has worked as a programmer, analyst, data modeler, database administrator, and Unix administrator. Gavin is also a semiprofessional musician, songwriter, and recording engineer, playing multiple instruments and writing prolifically. Gavin can be reached by e-mail at firstname.lastname@example.org or email@example.com.
Cary N. Prague is an internationally best-selling author and lecturer in the database industry. He owns Database Creations, Inc., the world’s largest Microsoft Access add-on company. Their products include a line of financial software; Business! for Microsoft Office, a mid-range accounting system, POSitively Business! Point of Sale software, the Inventory Barcode manager for mobile data collection, and the Check Writer and General Ledger. Database Creations also produces a line of developer tools including the appBuilder, an application generator for Microsoft Access, the EZ Access Developer Tools for building great user interfaces, appWatcher for maintaining code bases among several developers, and Surgical Strike, the only Patch Manager for Microsoft Access.
Cary also owns Database Creations Consulting, LLC., a successful consulting firm specializing in Microsoft Access and SQL Server appl
"I recommend this book for anyone who wants a strong foundation in Access."
—Jeff Lenamon, CIBC World Markets
Updated edition with exciting new Access 2007 features!
Harness the power of Access 2007 with the expert guidance in this comprehensive reference. Beginners will appreciate the thorough attention to database fundamentals and terminology. Experienced users can jump right into Access 2007 enhancements like the all-new user interface and wider use of XML and Web services. Each of the book's six parts thoroughly focuses on key elements in a logical sequence, so you have what you need, when you need it. Designed as both a reference and a tutorial, Access 2007 Bible is a powerful tool for developers needing to make the most of the new features in Access 2007.
- Build Access tables using good relational database techniques
- Construct efficient databases using a five-step design method
- Design efficient data-entry and data display forms
- Utilize the improved Access report designer
- Use Visual Basic(r) for Applications and the VBA Editor to automate applications
- Build and customize Access 2007 ribbons
- Seamlessly exchange Access data with SharePoint(r)
- Employ advanced techniques such as the Windows(r) API and object-oriented programming
- Add security and use data replication in your Access applications
What's on the CD-ROM?
Follow the examples in the book chapter by chapter using the bonus materials on the CD-ROM. You'll find separate Microsoft Access database files for each chapter and other working files, including
- All the examples and databases used in the book, including database files, images, data files in various formats, and icon files used in the book's examples
- A complete sample application file, including queries, reports, objects, and modules, that you can use as a reference
See the CD-ROM appendix for details and complete system requirements.
Note: CD-ROM/DVD and other supp...