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.