Microsoft® Office Access 2003 Inside Out

Larger Cover

By John Viescas

Publisher: Microsoft Press

Released: November 2003

Pages: 1344

dc:abstract """

Hey, you know your way around a database—so now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format. It’s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Access mastery!

Build on what you already know about Access and quickly dive into what’s new
Design your database the way the experts do—and sidestep common mistakes
Import data from spreadsheets, text files, databases, and other sources
Write simple to sophisticated queries to manipulate data
Learn advanced techniques for building forms and reports
Develop PivotTable and PivotChart dynamic views
Tap the power of Microsoft SQL Server with Access projects and views, functions, and stored procedures
Implement database security features
Deliver dynamic data on the Web with data access pages and XML
Use Microsoft Visual Basic for Applications (VBA) and script to automate your applications and Web pages

CD features:

Complete eBook in PDF format
Insider Extras—including fully functional sample databases, VBA code, and sample web pages
Catalog of Access resources with links to third-party tools and demos
Microsoft resources and demos, including Insider’s Guide to Microsoft Office OneNote 2003 eBook
Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entries

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 O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's 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
1. Chapter 1 What Is Microsoft Access?
  1. What Is a Database?
  2. Microsoft Access as an RDBMS
  3. Microsoft Access as an Application Development System
  4. Deciding to Move to Database Software
2. Chapter 2 The Many Faces of Microsoft Access
  1. The Architecture of Microsoft Access
  2. Exploring a Desktop Database—Housing Reservations
  3. Exploring a Project File—LawTrack Contacts
  4. The Many Faces of Microsoft Access
3. Chapter 3 Designing Your Database Application
  1. Application Design Fundamentals
  2. An Application Design Strategy
  3. Data Analysis
  4. Database Design Concepts
  5. When to Break the Rules
Building a Microsoft Access Desktop Application
1. Chapter 4 Creating Your Database and Tables
  1. Creating a New Database
  2. Creating Your First Simple Table by Entering Data
  3. Creating a Table Using the Table Wizard
  4. Creating a Table in Design View
  5. Defining Fields
  6. Defining a Primary Key
  7. Defining a Table Validation Rule
  8. Understanding Other Table Properties
  9. Defining Relationships
  10. Adding Indexes
  11. Setting Table Design Options
  12. Printing a Table Definition
  13. Database Limitations
2. Chapter 5 Modifying Your Table Design
  1. Before You Get Started
  2. Deleting Tables
  3. Renaming Tables
  4. Changing Field Names
  5. Moving Fields
  6. Inserting Fields
  7. Copying Fields
  8. Deleting Fields
  9. Changing Data Attributes
  10. Reversing Changes
  11. Using the Table Analyzer Wizard
  12. Taking a Look at Lookup Properties
  13. Changing the Primary Key
  14. Compacting Your Database
3. Chapter 6 Importing and Linking Data
  1. A Word About Open Database Connectivity (ODBC)
  2. Importing vs. Linking Database Files
  3. Importing Data and Databases
  4. Importing Spreadsheet Data
  5. Importing Text Files
  6. Modifying Imported Tables
  7. Linking Files
4. Chapter 7 Creating and Working with Simple Queries
  1. Selecting Data from a Single Table
  2. Testing Validation Rule Changes
  3. Working in Query Datasheet View
5. Chapter 8 Building Complex Queries
  1. Selecting Data from Multiple Tables
  2. Using a Query Wizard
  3. Summarizing Information with Totals Queries
  4. Using Query Parameters
  5. Customizing Query Properties
  6. Editing and Creating Queries in SQL View
  7. Limitations on Using Select Queries to Update Data
  8. Creating PivotTables and PivotCharts from Queries
6. Chapter 9 Modifying Data with Action Queries
  1. Updating Groups of Rows
  2. Creating a New Table with a Make-Table Query
  3. Inserting Data from Another Table
  4. Deleting Groups of Rows
  5. Troubleshooting Action Queries
Creating Forms and Reports in a Desktop Application
1. Chapter 10 Using Forms
  1. Uses of Forms
  2. A Tour of Forms
  3. Moving Around on Forms and Working with Data
  4. Searching for and Sorting Data
  5. Printing Forms
2. Chapter 11 Building a Form
  1. Forms and Object-Oriented Programming
  2. Starting from Scratch—A Simple Input Form
  3. Working with Form Wizards
  4. Simplifying Data Input with a Form
3. Chapter 12 Customizing a Form
  1. Aligning and Sizing Controls
  2. Enhancing the Look of a Form
  3. Setting Control Properties
  4. Setting Form Properties
  5. Setting Form and Control Defaults
4. Chapter 13 Advanced Form Design
  1. Basing a Form on a Multiple-Table Query
  2. Creating and Embedding Subforms
  3. Displaying Values in an Option Group
  4. Using Conditional Formatting
  5. Working with the Tab Control
  6. Creating Multiple-Page Forms
  7. Introducing ActiveX Controls—The Calendar Control
  8. Working with PivotChart Forms
5. Chapter 14 Using Reports
  1. Uses of Reports
  2. A Tour of Reports
  3. Printing Reports
6. Chapter 15 Constructing a Report
  1. Starting from Scratch—A Simple Report
  2. Using a Report Wizard
7. Chapter 16 Advanced Report Design
  1. Building a Query for a Complex Report
  2. Creating the Basic Facility Occupancy by Date Report
  3. Defining the Sorting and Grouping Criteria
  4. Setting Section and Report Properties
  5. Using Calculated Values
  6. Creating and Embedding a Subreport
  7. Adding a PivotChart to a Report
Designing an Access Project
1. Chapter 17 Building Tables in an Access Project
  1. Creating a New Project File
  2. Creating a Table in Design View
  3. Defining Columns
  4. Defining a Primary Key
  5. Adding Indexes
  6. Creating Additional Tables in Contact Tracking
  7. Defining Check Constraints
  8. Defining Relationships
  9. Setting Table Design Options
2. Chapter 18 Building Queries in an Access Project
  1. Building Queries Using the Query Designer
  2. Building Queries Using a Text Editor
3. Chapter 19 Designing Forms in an Access Project
  1. Understanding Form Differences in an Access Project
  2. Setting Recordset Type
  3. Understanding Max Records
  4. Working with Server Filters
  5. Setting Input Parameters
4. Chapter 20 Building Reports in an Access Project
  1. Understanding Report Differences in an Access Project
  2. Working with Server Filters
  3. Working with Input Parameters
Automating an Access Application
1. Chapter 21 Understanding Event Processing
  1. Access as a Windows Event-Driven Application
  2. Summary of Form and Report Events
  3. Understanding Event Sequence and Form Editing
  4. Summary of Macro Actions
  5. The Macro Design Facility—An Overview
2. Chapter 22 Understanding Visual Basic Fundamentals
  1. The Visual Basic Development Environment
  2. Variables and Constants
  3. Declaring Constants and Variables
  4. Collections, Objects, Properties, and Methods
  5. Functions and Subroutines
  6. Understanding Class Modules
  7. Controlling the Flow of Statements
  8. Running Macro Actions and Menu Commands
  9. Trapping Errors
  10. Some Complex Visual Basic Examples
3. Chapter 23 Automating Your Application with Visual Basic
  1. Why Aren’t We Using Macros?
  2. Assisting Data Entry
  3. Validating Complex Data
  4. Controlling Tabbing on a Multiple-Page Form
  5. Automating Data Selection
  6. Linking to Related Data in Another Form or Report
  7. Automating Complex Tasks
  8. Automating Reports
4. Chapter 24 The Finishing Touches
  1. Creating Custom Menus and Toolbars
  2. Fine-Tuning with the Performance Analyzer Wizard
  3. Disabling Form Design View
  4. Defining Switchboard Forms
  5. Controlling How Your Application Starts and Runs
  6. Performing a Final Visual Basic Compile
Linking Access and the Web
1. Chapter 25 Publishing Data on the Web
  1. Working with the Web
  2. Maintaining Static Web Pages
  3. Creating Dynamic Web Pages
  4. Sharing Your Data with SharePoint
  5. Discovering the Possibilities
2. Chapter 26 Creating Static and Dynamic Web Pages
  1. Creating a Static HTML Document
  2. Creating a Dynamic Active Server Page
3. Chapter 27 Building Data Access Pages
  1. Introducing Data Access Pages
  2. Designing Data Access Pages
  3. Automating Data Access Pages
  4. Updating Data Access Page Links and Connections
  5. Uploading Your Pages to a Web Server
4. Chapter 28 Working with XML and SharePoint
  1. Exploring XML
  2. Using XML in Microsoft Access
  3. Working with SharePoint
After Completing Your Application
1. Chapter 29 Upsizing a Desktop Application to a Project
  1. Benefits of the Client/Server Architecture
  2. Deciding When to Upsize
  3. Deciding on a Strategy
  4. Preparing Your Desktop Database
  5. Using the Upsizing Wizard
  6. Correcting the Upsize Result
2. Chapter 30 Securing Your Database
  1. Securing a Desktop Database
  2. Security Considerations in a Project File
  3. Understanding Macro Security
3. Chapter 31 Distributing Your Application
  1. Using Linked Tables in a Desktop Database
  2. Verifying Server Connection in a Project File
  3. Understanding Runtime Mode
  4. Creating an Execute-Only Database
  5. Creating an Application Shortcut
  6. Understanding the Visual Studio Tools for the Microsoft Office System
Appendix
1. Appendix Installing Microsoft Office
  1. Installing Microsoft Office
  2. Installing the Microsoft SQL Server Data Engine (MSDE)
  3. Managing ODBC Connections
  4. Converting from a Previous Release of Microsoft Access
  5. Creating an Office Toolbar in Windows XP
2. Appendix Index to Troubleshooting Topics
3. Appendix About the Author

Title:

Microsoft® Office Access 2003 Inside Out

By:

John Viescas

Publisher:

Microsoft Press

Formats:

Print
Ebook
Safari Books Online

Print:

November 2003

Ebook:

November 2009

Pages:

1344

Print ISBN:

978-0-7356-1513-7

| ISBN 10:

0-7356-1513-6

Ebook ISBN:

978-0-7356-9206-0

| ISBN 10:

0-7356-9206-8

Description

Table of Contents

Product Details

About the Author

Recommended for You

Understanding Microsoft Access

Chapter 1 What Is Microsoft Access?

Chapter 2 The Many Faces of Microsoft Access

Chapter 3 Designing Your Database Application

Building a Microsoft Access Desktop Application

Chapter 4 Creating Your Database and Tables

Chapter 5 Modifying Your Table Design

Chapter 6 Importing and Linking Data

Chapter 7 Creating and Working with Simple Queries

Chapter 8 Building Complex Queries

Chapter 9 Modifying Data with Action Queries

Creating Forms and Reports in a Desktop Application

Chapter 10 Using Forms

Chapter 11 Building a Form

Chapter 12 Customizing a Form

Chapter 13 Advanced Form Design

Chapter 14 Using Reports

Chapter 15 Constructing a Report

Chapter 16 Advanced Report Design

Designing an Access Project

Chapter 17 Building Tables in an Access Project

Chapter 18 Building Queries in an Access Project

Chapter 19 Designing Forms in an Access Project

Chapter 20 Building Reports in an Access Project

Automating an Access Application

Chapter 21 Understanding Event Processing

Chapter 22 Understanding Visual Basic Fundamentals

Chapter 23 Automating Your Application with Visual Basic

Chapter 24 The Finishing Touches

Linking Access and the Web

Chapter 25 Publishing Data on the Web

Chapter 26 Creating Static and Dynamic Web Pages

Chapter 27 Building Data Access Pages

Chapter 28 Working with XML and SharePoint

After Completing Your Application

Chapter 29 Upsizing a Desktop Application to a Project

Chapter 30 Securing Your Database

Chapter 31 Distributing Your Application

Appendix

Appendix Installing Microsoft Office

Appendix Index to Troubleshooting Topics

Appendix About the Author

John Viescas

About O'Reilly

Community

More O'Reilly Sites

Partner Sites

Shop O'Reilly