Microsoft?® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out) - page 1
- Table of Contents
- Table of Contents
- Back Cover
- Microsoft Office Access 2007 Inside Out
- About the CD
- Sample Applications
- System Requirements
- Support Information
- Conventions and Features Used in This Book
- Design Conventions
- Syntax Conventions
- Introduction
- Getting Familiar with Access 2007
- About This Book
- Part 1: 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
- 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
- Exploring a Desktop Database-Housing Reservations
- Exploring a Project File-Conrad Systems Contacts
- The Many Faces of Access
- Part 2: 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
- 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
