O'Reilly logo

Alison Balter's Mastering Access 97 Development, Second Edition by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 NameTypeSize (Bytes)
ClientIDNumber (Long)4
CompanyNameText50
AddressText255
CityText30
StateProvinceText20
PostalCodeText20
CountryText20
ContactFirstNameText30
ContactLastNameText50
ContactTitleText50
OfficePhoneText30
FaxText30
CellularText30
HomeText30
EMailAddressText30
ReferredBy ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required