You’re beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle Access 2007—and challenge yourself to new levels of mastery!
Create tables that support your database design strategy
Import and link to data from spreadsheets, text files, databases, and other ODBC data sources
Build simple to complex queries to manipulate data
Learn advanced techniques for building and customizing user interface forms
Design attractive reports to calculate and analyze large sets of data
Automate your application with Microsoft Visual Basic® for Applications
Customize the Office Fluent Ribbon
Explore using XML and Windows® SharePoint® Services to create Web-based applications
CD includes:
Fully searchable eBook—plus bonus chapters
Sample database applications—including query, form, and report examples
Articles from the experts: designing databases, understanding SQL, exporting data, and more
Links to demos, blogs, and user communities
References for finding Access 2003 commands in Access 2007
Windows Vista® Product Guide eReference and other eBooks
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Understanding Microsoft Access
Chapter 1 What Is Microsoft Access?
What Is a Database?
Access as an RDBMS
Access as an Application Development System
Deciding to Move to Database Software
Chapter 2 Exploring the New Look of Access 2007
Opening Access for the First Time
Getting Started—A New Look for Access
Understanding Content Security
Understanding the New Ribbon Feature
Understanding the New Navigation Pane
Using the Single-Document vs. Multiple-Document Interface
Modifying Global Settings via the Access Options Dialog Box
Chapter 3 Microsoft Office Access 2007 Overview
The Architecture of Access
Exploring a Desktop Database—Housing Reservations
Exploring a Project File—Conrad Systems Contacts
The Many Faces of Access
Building an Access 2007 Desktop Application
Chapter 4 Creating Your Database and Tables
Creating a New Database
Creating Your First Simple Table by Entering Data
Creating a Table Using a Table Template
Creating a Table in Design View
Defining Fields
Defining a Primary Key
Defining a Table Validation Rule
Understanding Other Table Properties
Defining Relationships
Adding Indexes
Setting Table Design Options
Creating a Default Template for New Databases
Printing a Table Definition
Database Limitations
Chapter 5 Modifying Your Table Design
Before You Get Started
Deleting Tables
Renaming Tables
Changing Field Names
Moving Fields
Inserting Fields
Copying Fields
Deleting Fields
Changing Data Attributes
Reversing Changes
Using the Table Analyzer Wizard
Taking a Look at Lookup Properties
Working with Multi-Value Lookup Fields
Changing the Primary Key
Compacting Your Database
Chapter 6 Importing and Linking Data
A Word About Open Database Connectivity (ODBC)
Creating a Data Source to Link to an ODBC Database
Importing vs. Linking Database Files
Importing Data and Databases
Importing Spreadsheet Data
Importing Text Files
Modifying Imported Tables
Linking Files
Collecting Data via E-Mail
Chapter 7 Creating and Working with Simple Queries
Selecting Data from a Single Table
Testing Validation Rule Changes
Working in Query Datasheet View
Chapter 8 Building Complex Queries
Selecting Data from Multiple Tables
Using a Query Wizard
Summarizing Information with Totals Queries
Using Query Parameters
Customizing Query Properties
Editing and Creating Queries in SQL View
Limitations on Using Select Queries to Update Data
Creating PivotTables and PivotCharts from Queries
Chapter 9 Modifying Data with Action Queries
Updating Groups of Rows
Creating a New Table with a Make-Table Query
Inserting Data from Another Table
Deleting Groups of Rows
Troubleshooting Action Queries
Creating Forms and Reports in a Desktop Application
Chapter 10 Using Forms
Uses of Forms
A Tour of Forms
Moving Around on Forms and Working with Data
Adding Records and Changing Data
Searching for and Sorting Data
Printing Forms
Chapter 11 Building a Form
Forms and Object-Oriented Programming
Starting from Scratch—A Simple Input Form
Working with Quick Create Commands and the Form Wizard
Simplifying Data Input with a Form
Chapter 12 Customizing a Form
Aligning and Sizing Controls in Design View
Working in Layout View
Enhancing the Look of a Form
Setting Control Properties
Setting Form Properties
Setting Form and Control Defaults
Chapter 13 Advanced Form Design
Basing a Form on a Multiple-Table Query
Creating and Embedding Subforms
Displaying Values in an Option Group
Using Conditional Formatting
Working with the Tab Control
Creating Multiple-Page Forms
Introducing ActiveX Controls—The Calendar Control
Working with PivotChart Forms
Chapter 14 Using Reports
Uses of Reports
A Tour of Reports
Printing Reports
Chapter 15 Constructing a Report
Starting from Scratch—A Simple Report
Using the Report Command
Using the Report Wizard
Building a Report in Layout View
Chapter 16 Advanced Report Design
Building a Query for a Complex Report
Creating the Basic Facility Occupancy By Date Report
Defining the Grouping and Sorting Criteria
Setting Section and Report Properties
Using Calculated Values
Creating and Embedding a Subreport
Adding a PivotChart to a Report
Automating an Access Application
Chapter 17 Understanding Event Processing
Access as a Windows Event-Driven Application
Summary of Form and Report Events
Understanding Event Sequence and Form Editing
Chapter 18 Automating Your Application with Macros
John L. Viescas is a database expert who provides consulting and training services to companies around the globe. He is the author of numerous books, including Running Microsoft Access 97, Running Microsoft Access 2000, Microsoft Office Access 2003 Inside Out, Building Microsoft Access Applications, and Microsoft Office Access 2007 Inside Out. John has been recognized as a Microsoft MVP since 1993.
Jeff was awarded Microsoft's Most Valuable Professional award from 2005 to 2007 before joining Microsoft for his continual involvement with the online Access community. He maintains a Web site with a wealth of information and resource links for those needing guidance with Access (http://www.AccessJunkie.com). He is the author of Microsoft Access 2010 Inside Out and co-authored the Microsoft Office Access 2007 Inside Out book with John Viescas. Jeff is currently employed by Microsoft as a Software Design Engineer in Test working with the Access development team.
