Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources]

Alison Balter

نسخه متنی -صفحه : 544/ 499
نمايش فراداده

The tblTerms Table

This table stores the valid term types. It relates to the tblClients table and is a lookup table for the TermTypeID stored in the tblClients table.

Table A.15. The tblTerms Table

Field Name

Type

Size (Bytes)

TermTypeID

Long Integer

4

TermType

Text

50

Table A.16. The Field Properties for Each Field in the tblTerms Table

Property

Value

TermTypeID

Long Integer

AllowZeroLength

False

Attributes

Fixed size, auto-increment

Caption

Term Type ID

CollatingOrder

General

ColumnHidden

False

ColumnOrder

Default

ColumnWidth

Default

DataUpdatable

False

OrdinalPosition

1

Required

False

SourceField

TermTypeID

SourceTable

tblTerms

TermType

Text

AllowZeroLength

False

Attributes

Variable length

Caption

Term Type

CollatingOrder

General

ColumnHidden

False

ColumnOrder

Default

ColumnWidth

Default

DataUpdatable

False

DisplayControl

Text Box

IMEMode

0

IMESentenceMode

3

OrdinalPosition

2

Required

False

SourceField

TermType

SourceTable

tblTerms

UnicodeCompression

True