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

Designing the Database

Now let's move to a more familiar spot—the computer chair—and begin designing the database. It's tough to get too specific here because your actual mileage will vary depending on the brand of database software you use. Each software manufacturer has its own methods for creating tables and defining fields, but most are surprisingly similar. For this example, I'll use the common package Microsoft Access. If you use a different package and run into trouble, consult your application's documentation.

First you'll use your database package to create a new file. To create the database file, open Microsoft Access and select File|New Database. Access offers several templates to start from; keep it simple and select the default, blank database. Access then prompts for a filename—use tv_cop_pasta_inc.mdb. The .mdb extension is specific to Microsoft Access software—other manufacturers use other extensions.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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