• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Working in Access > Planning a Database

Planning a Database

When you do create a new database, you want to make sure that the database is designed not only to meet your data entry needs, but also to meet your needs for viewing and reporting the data that is held in the various tables that make up the database. Taking a little time to plan your database before you create it can save you from headaches down the road. The sections that follow provide some tips on planning a database.

Determining Your Tables

Technically, you need only one table to make a database. However, because Access is a relational database program, it's meant to handle many tables and create relationships among them. For example, in a database that keeps track of customer orders, you might have the following tables:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint