Introduction. Chapter 1. Introduction to Access 2007 VBA. Chapter 2. The Basics of Writing and Testing VBA Code. Chapter 3. Programming Applications using Objects. Chapter 4. Creating Your Own Objects. Chapter 5. Interacting with Data Using and SQL. Chapter 6. Building Interactive Forms. Chapter 7. Importing, Linking, and Exporting Using External Data Sources. Chapter 8. Using Access with Web Services and SharePoint Lists. Chapter 9. Creating Reports and Web-Enabled Output. Chapter 10. Building SQL Server Applications with Access Projects. Chapter 11. Building SQL Server Applications with Access Projects. Chapter 12. Finishing the Application. Chapter 13. Case Study I: Project Tracker Application. Chapter 14. Case Study II: Customer Service Application. Appendix A. Exercise Answers.
Denise Gosnell is a software patent attorney and technology consultant with Gosnell & Associates, Inc., which she founded in 2005. Denise has a unique background in both technology and law, and presently uses her deep technical and legal expertise to counsel hi-tech clients on intellectual property and technical matters. Denise was recognized in February 2005 with the Indianapolis Business Journal award: "Top 40 Under 40," which recognizes the top up-and-coming professionals under the age of 40 in the city of Indianapolis each year. She also appeared on the Inside Indiana Business with Gerry Dick television show in March 2005 to discuss hi-tech issues facing the business world. Denise has over 12 years of experience in creating software applications, ranging from standalone and client-server to enterprise-wide applications. Denise has worked for leading software companies such as Microsoft and EDS, and has earned a worldwide reputation for her technology expertise. She received a bachelor of arts degree in Computer Science-Business (summa cum laude) from Anderson University, where she currently serves as an adjunct professor for the Computer Science Department. Denise obtained a doctor of jurisprudence degree from Indiana University School of Law in Indianapolis. Denise has authored and coauthored seven other software development books to date, covering topics such as database development, Access, Visual Basic .NET, and web services. Most recently, Denise authored Professional Development with Web APIs (Wiley 2005) and Beginning Access 2003 VBA (Wiley 2004). Denise was a featured technology speaker at the Microsoft European Professional Developer's Conference in December 2001 and has on numerous occasions assisted Microsoft's Training and Certification group in creating new exams for their MCSD and MCSE certifications.