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

Chapter 3. What Every Developer Needs to... > Practical Examples: Designing the Ta...

Practical Examples: Designing the Tables Needed for the Computer Consulting Firm's Time and Billing Application

Now try designing a few of the tables needed by the computer consulting firm's Time and Billing application. You will build tblClients and tblProjects; tblClients is the main table for the application. It will be used to track the key information about each client. The second table, tblProjects, will be used to hold all the key information users need to store on the projects they're working on for each client. Table 3.2 shows the field names, data types, and sizes for each field in tblClients. You should include indexes for all fields except Notes. Table 3.3 shows the properties that need to be set for these fields. Table 3.4 shows the fields, data types, and sizes for the fields in tblProjects, and Table 3.5 shows the properties that need to be set for these fields. You should include indexes for all fields except ProjectDescription.

Table 3.2. Field names, data types, and sizes for the fields in tblClients.
Field NameData TypeSize
ClientIDAutoNumber4
CompanyNameText50
AddressText255
CityText30
StateProvinceText20
PostalCodeText20
CountryText20
ContactFirstNameText30
ContactLastNameText50
ContactTitleText50
OfficePhoneText30
FaxText30
CellularText30
HomeText30
EMailAddressText30
ReferredByText30
AssociatedWithText30
IntroDateDate/Time8
DefaultRateCurrency8
NotesMemo-
HomePageHyperlink-



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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