Microsoft® Office Access 2007: Comprehensive Concepts and Techniques

Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis, and discrete mathematics. He has authored more than 75 textbooks and has co-authored three levels of Microsoft® Office Access 2013 books for this popular Shelly Cashman Series and A Guide to SQL. Gary B. Shelly wrote and published his first computer education textbook in 1969. More than twenty million copies of Shelly Cashman Series' textbooks have been sold. Gary and a talented group of contributing authors have produced books on computer programming, computer concepts, and application software that are the leading textbooks in the computer technology market today. Gary has hosted the annual Shelly Cashman Institute, a week-long training event focusing on the latest topics in technology, for the past 34 years. Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, Texas, where she was an Associate Professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992. She also authors many instructor resources for database texts. Thomas J. Cashman received his education at California State University, Los Angeles. He established one of the first business data processing programs in the U.S. at Long Beach City College in California, where he taught and served as department head. In 1969, he began collaborating with now best-selling author, Gary Shelly.

1. Creating and Using a Database
2. Querying a Database
3. Maintaining a Database
Integration Feature: Sharing Data Among Applications
4. Creating Reports and Forms
5. Multi-Table Forms
6. Using Macros, Switchboards, PivotTables, and PivotCharts
SQL Feature: Using SQL
7. Advanced Report Techniques
8. Advanced Form Techniques
9. Administering a Database System
Web Feature: Sharing Access Data
Appendices
A: Project Planning Guidelines
B: Introduction to Microsoft Office 2007
C: Microsoft Office Access 2007 Help
D: Publishing Office 2007 Web Pages to a Web Server
E: Customizing Microsoft Office Access 2007
F: Steps for the Windows XP User
G: Microsoft Business Certification Program
H: Database Design