If you’re developing a database application with the tools in Access 2007, this book gives you a thorough understanding of “programming without pain.” It provides a solid foundation for designing databases, forms, and reports and getting them all to work together. You’ll learn that you can quickly create complex applications by linking design elements with macros or Visual Basic. This book will also show you how to take advantage of some of the more advanced features of Access 2007. You’ll learn how to build an Access project that links directly to an SQL Server database. You’ll also learn how to use Access tools to link to your Access data from the Web or link your Access application to data stored on the Web.
If you’re new to developing applications, particularly database applications, this probably should not be the first book you read about Access. We recommend that you first take a look at Microsoft Access 2007 Plain and Simple or Microsoft Access 2007 Step by Step.
Microsoft Office Access 2007 Inside Out is divided into seven major parts:
Part 1 provides an overview of Access 2007 and provides you with a detailed look at the new user interface.
Chapter 1 explains the major features that a database should provide, explores those features in Access, and discusses some of the main reasons why you should consider using database software.
Chapter 2 thoroughly explores the new user interface introduced in the 2007 Office release. The chapter also explains content security, working with the Ribbon and the Navigation Pane, and setting options that customize how you work with Access 2007.
Chapter 3 describes the architecture of Access 2007, gives you an overview of the major objects in an Access database by taking you on a tour through two of the sample databases, and explains the many ways you can use Access to create an application.
Part 2 shows you how to create your desktop application database and tables and build queries to analyze and update data in your tables.
Chapter 4 teaches you how to create databases and tables.
Chapter 5 shows you the ins and outs of modifying tables even after you’ve already begun to load data and build other parts of your application.
Chapter 6 explains how to link to or import data from other sources.
Chapter 7 shows you how to build simple queries and how to work with data in Datasheet view.
Chapter 8 discusses how to design queries to work with data from multiple tables, summarize information, build queries that require you to work in SQL view, and work with the PivotTable and PivotChart views of queries.
Chapter 9 focuses on modifying sets of data with queries-updating data, inserting new data, deleting sets of data, or creating a new table from a selection of data from existing tables.
Part 3 discusses how to build and work with forms and reports in a desktop application.
Chapter 10 introduces you to forms-what they look like and how they work.
Chapters 11, 12, and 13 teach you all about form design in a desktop application, from simple forms you build with a wizard to complex, advanced forms that use embedded forms or ActiveX controls.
Chapter 14 leads you on a guided tour of reports and explains their major features.
Chapters 15 and 16 teach you how to design, build, and implement both simple and complex reports in your desktop application.
Part 4 shows you how to use the programming facilities in Visual Basic to integrate your database objects and make your application “come alive.”
Chapter 17 discusses the concept of event processing in Access, provides a comprehensive list of events, and explains the sequence in which critical events occur.
Chapter 18 covers macro design in depth and explains how to use the new error trapping and embedded macro features.
Chapter 19 is a comprehensive reference to the Visual Basic language and object models implemented in Access. The final section of the chapter presents two complex coding examples with a line-by-line discussion of the code.
Chapter 20 thoroughly discusses some of the most common tasks that you might want to automate with Visual Basic. Each section describes a problem, shows you specific form or report design techniques you must use to solve the problem, and walks you through the code from one or more of the sample databases that implements the solution.
Part 5 is all about using Access tools with the Web.
Chapter 21 provides an overview of the ways you can publish data on a Web site.
Chapter 22 discusses specific ways to publish your Access applications using Windows SharePoint Services (version 3).
Chapter 23 covers the features in Access that handle XML, including importing, updating, and publishing data. The chapter also shows you how to use XML to modify table templates and design custom Ribbons.
Part 6 covers tasks you might want to perform after completing your application.
Chapter 24 teaches you how to automate custom Ribbons, how to use the Performance Analyzer tool, how to design a switchboard, and how to set Startup properties.
Chapter 25 teaches you tasks for setting up your application so that you can distribute it to others.
Part 7 expands on what you learned in Parts 2, and 3 by teaching you the additional skills you need to create client/server applications in an Access project.
Chapter 26 shows you how to build a new project file and explains how to define SQL Server tables from the project.
Chapter 27 teaches you how to design the project equivalent of desktop queries-views, stored procedures, and functions.
Chapter 28 builds on what you learned in Chapters 11–13 and shows you how forms work differently in an Access project.
Chapter 29 leverages what you learned in Chapters 15–16 and teaches you how to design reports in an Access project.
The Appendix explains how to install the 2007 Office release, including which options you should choose for Access 2007 to be able to open all the samples in this book. It also discusses how to install Microsoft SQL Server 2005 Express Edition.
The CD also provides six Articles that contain important reference information:
Article 1 explains a simple technique that you can use to design a good relational database application with little effort. Even if you’re already familiar with Access or creating database applications in general, getting the table design right is so important that this article is a “must read” for everyone.
Article 2 is a complete reference to SQL as implemented in desktop databases. It also contains notes about differences between SQL supported natively by Access and SQL implemented in SQL Server.
Article 3 discusses how to export data and Access objects to various types of other data formats from your Access application.
Article 4 lists the functions most commonly used in an Access application categorized by function type.
Article 5 lists the color names and codes you can use in Access.
Article 6 lists the macro actions you can use in Access.