Book description
"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 supplementary materials are not
included as part of eBook file.
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.
