13.2. Building the Database

In this section, you will build the database in an Access file separately from the user interface. You learned in Chapter 11 that you can realize performance improvements by separating the user interface from the underlying data. The database containing the data tables can be placed on the same or a different computer than the one containing the user interface. If you are the only user, then having both files on the same computer is fine. If you have others with whom you must share the application, then putting the database with the data tables on a file server and the user interface on each user's workstation makes the most sense. In either case, you can make the database location configurable, so you can change the setup as your needs scale. This chapter will not discuss this option, but it is easily implemented in VBA.

Try It Out: Building the ProjectTrackerDb Database

Let's now build the database that will store the data tables.

  1. Create a new database by selecting the Office Button New. From the list of available templates, select "Blank Database." Specify ProjectTrackerDb for the file name, and click the Create button.

  2. The tables for this database are shown in Figures 13-7 through 13-11. Note that for each table, the field size is specified in the Description field for your convenience. You also need to add primary keys as indicated in each table ...

Get Beginning Access™ 2007 VBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.