Chapter 7. Design and Create Your Own Tables

IN THIS CHAPTER:

  • 38 About Task Analysis

  • 39 About Database Analysis and Design

  • 40 About Relational Database Design

  • 41 About the Application Development Process

  • 42 Build a New Table

  • 43 About Selecting the Appropriate Field Type for Your Data

  • 44 Set a Primary Key

It is useful to think of the process of table design as being similar to the process of building a foundation for a house. Just as a house with a faulty foundation will fall over, an application with a poor table design will be difficult to build, maintain, and use. This chapter covers all the ins and outs of table design in Access 2003. After this chapter, you will be ready to build the other components of an application, knowing that the tables you ...

Get Microsoft Office Access 2003 in a Snap 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.

Start your free trial