O'Reilly logo

Alison Balter’s Mastering Microsoft Access 2002 Desktop Development 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 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 ...

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