How to do Everything With Microsoft Office Access 2007

Description

Maximize the powerful features of the latest release of today's most popular desktop database program. How to Do Everything with Microsoft Office Access 2007 shows you how to create and customize an efficient, multi-user database, retrieve, interpret, and share your data, secure your information, and much more. Designed to help you get things done quickly and easily, this user-friendly guide is your all-access pass to Access 2007.

    *

      Navigate the new user interface with ease

    *

      Design a well-organized database using pre-designed templates

    *

      Enter and edit data and ensure data validity

    *

      Sort, filter, and print records

    *

      Extract specific information using queries

    *

      Master form and report design basics

    *

      Add charts and graphs to forms and reports easily

    *

      Optimize database performance and speed

    *

      Exchange database objects and text files between Access databases

Part 1: Get Started

Chapter 1: Getting Acquainted with Access 2007

Chapter 2: Create a Database

Chapter 3: Create and Modify Tables

Chapter 4: Relate Tables

Chapter 5: Enter and Edit Data

Part 2: Retrieve and Present Information

Chapter 6: Sort, Filter, and Print Records

Chapter 7: Extract Data with Queries

Chapter 8: Create Advance Queries

Chapter 9: Understand Form and Report Design Basics

Chapter 10: Create Custom Forms and Subforms

Chapter 11: Create and Customize Reports and Subreports

Chapter 12: Create Charts and Graphs

Part 3: Improve the Access 2003 Workplace

Chapter 13: Customize the Workplace

Chapter 14: Speed Up Your Database

Chapter 15: Automate the Macros

Chapter 16: Customize the Navigation Pane

Chapter 17: Create Custom Switchboards and Dialog

Part 4: Exchange Data with Others

Chapter 18: Exchange Database Objects and Text

Chapter 19: Exchange Data with Outside Sources

Chapter 20: Use SharePoint with Sare with Multiple
Chapter 21: Secure a Database

Appendix: Convert to Access