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

Alison Balter

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

The tblAddressTypes Table

This table stores the valid address types. It relates to the tblClientAddresses table and is a lookup table for the AddressTypeID stored in the tblClientAddresses table.

Table A.5. The tblAddressTypes Table

Field Name

Type

Size (Bytes)

AddressTypeID

Long Integer

4

AddressType

Text 50

Table A.6. The Field Properties for Each Field in the tblAddressTypes Table

Property

Value

AddressTypeID

Long Integer

AllowZeroLength

False

Attributes

Fixed size, auto-increment

Caption

Address Type ID

CollatingOrder

General

ColumnHidden

False

ColumnOrder

Default

ColumnWidth

Default

DataUpdatable

False

OrdinalPosition

1

Required

False

SourceField

AddressTypeID

SourceTable

tblAddressTypes

AddressType

Text

AllowZeroLength

False

Attributes

Variable length

Caption

Address Type

CollatingOrder

General

ColumnHidden

False

ColumnOrder

Default

ColumnWidth

Default

DataUpdatable

False

DisplayControl

Text Box

IMEMode

0

IMESentenceMode

3

OrdinalPosition

2

Required

False

SourceField

AddressType

SourceTable

tblAddressTypes

UnicodeCompression

True