Appendix A. Table Structures

This appendix gives you a complete listing of all the tables included in the Time and Billing application. Each table includes the following

  • A list of the field names, types, and lengths of each field in the table

  • A detailed list of the properties associated with each field in the table

The tblClients Table

This table stores pertinent information about each client, such as the company name, contact name, and phone numbers.

Table A.1. The tblClients Table

Field Name

Type

Size (Bytes)

ClientID

Number (Long)

4

CompanyName

Text

50

ContactFirstName

Text

30

ContactLastName

Text

50

ContactTitle

Text

50

ContactTypeID

Number (Long)

4

ReferredBy

Text

30

AssociatedWith

Text

30

IntroDate

Date/Time

8

DefaultRate

Currency

8

Notes

Memo

(Varies)

Miles

Number (Long)

4

TermTypeID ...

Get Alison Balter’s Mastering Microsoft Access 2002 Desktop Development now with O’Reilly online learning.

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