 |
Microsoft Office Access 2007 Bible
Read an excerpt:
Chapter 1: An Introduction to Database Development
Excerpt provided courtesy of John Wiley & Sons Inc. Copyright © John Wiley & Sons Inc. Written permission from the publisher is required for any use of this material.
|
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Special Edition Using Microsoft Office 2007; Ed Bott, et al, $25.95, 35% Off!
- Microsoft Office Excel 2007 Bible; John Walkenbach, $25.50, 36% Off!
- Microsoft Office Outlook 2007 Inside Out; Jim Boyce, et al, $28.50, 37% Off!
- Windows Vista Inside Out; Ed Bott, et al, $31.50, 37% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
* Thorough beginning-to-advanced coverage has made this the book users and
developers need to succeed with this leading database system
* Revised and updated to cover the substantial changes to Access 2007, including
the dramatically different interface and easier interactivity with Excel
* Shows database novices and pros alike how to store, organize, view, analyze,
and share data through custom database solutions that interact with Web and
enterprise data sources
* Includes a valuable CD-ROM with examples and databases from the book as well
as trial software
Table of Contents
Acknowledgments.
Foreword.
Part I: Access Building Blocks.
Chapter 1: An Introduction to Database Development.
Chapter 2: Creating Access Tables.
Chapter 3: Designing Bulletproof Databases.
Chapter 4: Selecting Data with Queries.
Chapter 5: Using Operators and Expressions in Access.
Chapter 6: Working with Datasheet View.
Chapter 7: Creating Basic Access Forms.
Chapter 8: Working with Data on Access Forms.
Chapter 9: Presenting Data with Access Reports.
Part II: Programming Microsoft Access.
Chapter 10: VBA Programming Fundamentals.
Chapter 11: Mastering VBA Data Types and Procedures.
Chapter 12: Understanding the Access Event Model.
Chapter 13: Using Expressions in Queries and VBA Code.
Chapter 14: Accessing Data with VBA Code.
Chapter 15: Using the VBA Debugging Tools.
Part III: More Advanced Access Techniques.
Chapter 16: Working with External Data.
Chapter 17: Importing and Exporting Data.
Chapter 18: Advanced Access Query Techniques.
Chapter 19: Advanced Access Form Techniques.
Chapter 20: Advanced Access Report Techniques.
Chapter 21: Building Multiuser Applications.
Chapter 22: Integrating Access with Other Applications.
Chapter 23: Integrating Access with SharePoint.
Chapter 24: Using ActiveX Controls.
Chapter 25: Handling Errors and Exceptions.
Part IV: Professional Database Development.
Chapter 26: Optimizing Access Applications.
Chapter 27: Advanced Data Access with VBA.
Chapter 28: Bulletproofing Access Applications.
Chapter 29: Securing Access Applications.
Chapter 30: Using the Windows API.
Chapter 31: Using the Access Replication Features.
Chapter 32: Object-Oriented Programming with VBA.
Chapter 33: Reusing VBA Code with Libraries.
Chapter 34: Customizing Access Ribbons.
Chapter 35: Distributing Access Applications.
Chapter 36: Using Access Macros.
Part V: Access as an Enterprise Platform.
Chapter 37: Using XML in Access 2007.
Chapter 38: SharePoint as a Data Source.
Chapter 39: Client/Server Concepts.
Chapter 40: SQL Server as an Access Companion.
Chapter 41: Upsizing Access Databases to SQL Server.
Part VI: Appendixes.
Appendix A: Access 2007 Specifications.
Appendix B: What’s on the CD-ROM.
Appendix C: What’s New in Access 2007.
Index.
About the Authors
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 info@oracledbaexpert.com or ezpowell@ezpowell.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 applications. Local and
national clients include many Fortune 100 companies including manufacturers,
defense contractors, insurance, health-care, and software industry companies.
His client list includes Microsoft, United Technologies, ABB, Smith & Wesson
Firearms, Pratt and Whitney Aircraft, ProHealth, OfficeMax, Continental Airlines,
and other Fortune 500 companies.
Formerly, he has held numerous management positions in corporate information
systems, including Director of Managed Care Reporting for MetraHealth, Director
of Corporate Finance and Software Productivity at Travelers Insurance where
he was responsible for software support for 35,000 end users, and Manager of
Information Systems support for Northeast Utilities.
He is one of the top best-selling authors in the computer database management
market, having written over 40 books that have sold over one million copies
on software including Microsoft Access, Borland (Ashton-Tate) dBASE, Paradox,
R:Base, Framework, and graphics. Cary’s books include 11 books in the Access
Bible series (recently number one on the Ingram Bestselling Database Titles
list and in the Amazon.com top 100), Access 97 Secrets, dBASE for Windows Handbook,
dBASE IV Programming (winner of the Computer Press Association’s Book of
the Year award for Best Software Specific Book), and Everyman’s Database
Primer Featuring dBASE IV. He recently completed several books for Access 2003
including Weekend Crash Course in Office Access 2003 Programming. Cary recently
sold a product line named eTools for Microsoft Access to MightyWords, a division
of FatBrain.com and Barnes and Noble.
Cary is certified in Access as a Microsoft Certified Professional and has passed
the MOUS test in Access and Word. He is a frequent speaker at seminars and conferences
around the country. He is on the exclusive Microsoft Access Insider Advisory
Board and makes frequent trips to Microsoft headquarters in Redmond, WA. He
has been voted the best speaker by the attendees of several national conferences.
Recently, he was a speaker for Microsoft sponsored conferences in New Orleans,
Hawaii, Phoenix, Chicago, Toronto, Palm Springs, Boston, and Orlando. He has
also spoken at Borland’s Database Conference, Digital Consulting’s
Database World, Microsoft’s Developer Days, Computerland’s Technomics
Conference, COMDEX, and COMPAQ Computer’s Innovate. He was a contributing
editor to Access Advisor magazine and has written for the Microsoft Office Developer’s
journal.
He is active in local town politics serving on the South Windsor, Connecticut
Board of Education, Parks and Recreation Commission, and the Board of Assessment
Appeals.
Cary holds a master’s degree in computer science from Rensselaer Polytechnic
Institute, and an M.B.A and Bachelor of Accounting from the University of Connecticut.
He is also a Certified Data Processor.
Michael R. Irwin is considered one of the leading authorities on automated
database and Internet management systems today. He is a noted worldwide lecturer,
a winner of national and international awards, best-selling author, and developer
of client/server, Internet, Intranet, and PC-based database management systems.
Michael has extensive database knowledge, gained by working with the Metropolitan
Police Department in Washington, D.C. as a developer and analyst for the Information
Systems Division for over 20 years and assorted Federal Agencies of the United
States Government. Since retiring in June 1992, he runs his own consulting firm,
named The Irwin Group, and is principal partner in the company - IT in Asia,
LLC, specializing in Internet database integration and emphasizing Client/Server
and net solutions. With consulting offices in Cincinnati, Ohio, Bangkok, Thailand,
and Manila, Philippines, his companies offer training and development of Internet
and database applications. His company has the distinction of being one of the
first Microsoft Solution’s Providers (in 1992). His local, national, and
international clients include many software companies, manufacturers, government
agencies, and international companies.
His range of expertise includes database processing and integration between
mainframe, minicomputer, and PC-based database systems, as well as B-2-B and
B-2-C integration between back-end databases; he is a leading authority on PC-based
databases.
He is one of the top best-selling authors in the computer database management
market, having authored numerous database books, with several of them consistently
on the best-sellers lists. His books, combined, have sold nearly a million copies
worldwide. His most recent works include The OOPs Primer (Borland Press), dBASE
5.5 for Windows Programming (Prentice Hall), Microsoft Access 2002 Bible, Microsoft
Access 2002 Bible Gold Edition (co-authored), and Working with the Internet.
The Access Bible series have constantly been number one on the Ingram Best-selling
Database Titles list and is consistently in the Amazon.com and Buy.com top 10.
He has also written several books on customs and cultures of the countries of
Asia (including China, Japan, Thailand, and India). Two of his books have won
international acclaim. His books are published in over 24 languages worldwide.
He has been a contributing editor and author to many well-known magazines and
journals.
He is a frequent speaker at seminars and conferences around the world and has
been voted the best speaker by the attendees of several international conferences.
Michael has developed and markets several add-on software products for the Internet
and productivity related applications. Many of his productivity applications
can be obtained from several of his Internet sites or on many common download
sites. Many of his application and systems are distributed as freeware and careware.
He has also developed and distributes several development tools and add-ins
for a wide range of developer applications.
Jennifer Reardon is considered a leading developer of custom database applications.
She has over ten years’ experience developing client/server and PC-based
applications. She has accumulated much of her application development experience
working as lead developer for Database Creations. She has partnered with Cary
Prague developing applications for many Fortune 500 companies.
Her most significant projects include a spare parts inventory control system
for Pratt & Whitney’s F22 program, an engineering specifications system
for ABB-Combustion Engineering, and an emergency event tracking system for the
State of Connecticut. She was also the lead developer of many of the Database
Creations add-on software products including Business, Yes! I Can Run My Business,
Check Writer, and the User Interface Construction Kit.
She has co-authored Access 2003 Bible, Access 2002 Bible, and Access 2000 Weekend
Crash Course. She has also written chapters in other books on subjects including
Data Access Pages, the Microsoft Database Engine, the VBA programming environment,
creating help systems, and using Microsoft Office 2000 Developer. She has authored
chapters in Microsoft Access 97 Bible and Access 97 Secrets.
Jennifer owns her own consulting firm, Advanced Software Concepts, providing
custom applications to both the public and private sectors. She specializes
in developing client information systems for state-managed and privately-held
healthcare organizations. She has also developed a job costing and project management
system for an international construction company. Her corporate experience includes
seven years with The Travelers where she was an Associate Software Engineer
serving on numerous mission-critical client/server software development projects
using Easel, C, SQL Server, and DB2. She has contributed several chapters for
books on dBase and Microsoft Access.
Jennifer holds a Bachelor of Science degree from the University of Massachusetts.
|
|
