Chapter 3. Working with Tables

Working with Tables

Tables form the basis of any database. A table's structure defines the fields and their properties and specifies how data should be entered. In this chapter, you will learn to create and manage 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

Plan Effective Tables

As a database designer, you have the opportunity to create tables in your database that match your storage ...

Get Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.