Learn everything you need to know for working with Microsoft Office Access 2007 from the inside out! This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds for using Office Access 2007 all in concise, fast-answer format. Whether you are upgrading from Office 97 or Office 2003, you’ll be able to dig in to the work-ready resources that help you take your Access 2007 experience to the next level. This information-packed complete reference shows you how to get the most out of Access 2007 and find out what’s new. You will learn how to design more-efficient databases, streamline data entry, find the information you need, and work with tools to produce effective forms, reports, and queries. In addition, you’ll begin to explore strategies for database design and advanced table design.
About the Authors
John Viescas has been working with database systems for most of his career. He began by designing and building a database application for a magazine and paperback book distributing company in Illinois in 1968. He went on to build large database application systems for El Paso Natural Gas Company in his hometown in the early 1970s. From there, he went to Applied Data Research in Dallas, where he managed the development of database and data dictionary systems for mainframe computers.
Before forming his own company in 1993, he helped market and support NonStop SQL for Tandem Computers in California. Somewhere along the way (would you believe 1991?), he got involved in the early testing of a new Microsoft product that was codenamed “Cirrus.” The first edition of Running Microsoft Access was published in 1992. Since then, he has written four more editions of Running, co-authored the best-selling SQL Queries for Mere Mortals, wrote Building Microsoft Access Applications, and is pleased to be writing about Access from the “Inside Out” for this book. If you hang out on the Web, you can find him answering questions about Access in the newsgroups. John has been named a Microsoft MVP every year since 1993 for his continuing help to the Access users’ community.
Jeff Conrad started working with Access when he saw a need at his full-time position for a database solution. He bought a book on Access (should have been one of John’s books) and began teaching himself how to use the program to solve his business’s needs. He immediately became hooked on the power and ease of working with Access long after John had written several books on the program.
Jeff found a home in the Microsoft Access newsgroups, asking questions as he was learning the ins-and-outs of Access and database development. He now enjoys giving back to a community that helped him when he was first learning how to use Access. He has been an active participant for many years in the Access newsgroups where he is best known as the Access Junkie.
Jeff also owns his own company, Conrad Systems Development, creating custom database and spreadsheet applications for the food service industry. Jeff maintains a Web site with a wealth of information and resource links for those needing guidance with Access (AccessJunkie.com). He was awarded Microsoft’s Most Valuable Professional award from 2005 to 2007 for his continual involvement with the online Access community. Because Jeff knows Access “Inside Out,” he recently joined Microsoft as a Software Design Engineer in Test working with Access and Excel technologies.