Practical Examples: Designing the Tables Needed for a Computer Consulting Firm's Time and Billing Application
Create a new database and try designing a few of the tables needed by a computer consulting firm's time and billing application. You will build tblClients and tblProjects tables. The main table for the application, tblClients, will be used to track the key information about each client. The second table, tblProjects, will hold all the key information users need to store on the projects they're working on for each client. Appendix A, "Table Structures." The finished table structures can be found in CHAP2.MDB. This file, and all files referred to in this book, can be found on the book's sample code CD-ROM.