Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007 > Working with Tables > Understanding Primary and Composite Keys

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007

Search

Praise for Visual Books

Credits

About the Author

Author's Acknowledgments

How to Use This Book

Ch. 1. Getting Started with Access 2007

Ch. 2. Entering and Editing Data

Ch. 3. Working with Tables

Plan Effective Tables

Create a Table from a Template

Save a Table

Create a Table in Datasheet View

Create a Table by Copying Another Table's Structure

Create a SharePoint List

Create a Table in Design View

Understanding Primary and Composite Keys

Set the Primary or Composite Key

Rename a Table

Delete a Table

Ch. 4. Working with Fields

Ch. 5. Working with Relationships and Lookups

Ch. 6. Finding and Filtering Data

Ch. 7. Creating Simple Queries

Ch. 8. Creating More Complex Queries

Ch. 9. Creating Forms

Ch. 10. Modifying and Formatting Forms

Ch. 11. Creating and Formatting Reports

Ch. 12. Grouping and Summarizing Data

Ch. 13. Creating Mailing Labels and Charts

Ch. 14. Working with External Data

Ch. 15. Maintaining a Database

Index

3.8. Understanding Primary and Composite Keys

The primary key is the field by which each record will be uniquely identified, and by which relationships between tables can be created. When there is more than one field designated as the primary key, it is called a composite key.

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial

Download Safari Books Online apps: Apple iOS | Android

This Book

Search

Contents

Chapter 3. Working with Tables > Understanding Primary and Composite Keys

3.8. Understanding Primary and Composite Keys