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

Alison Balter

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

The tblExpenseCodes Tables

This table contains all the valid expense codes used in the hypothetical time and billing application.

Table A.27. The tblExpenseCodes Table

Field Name

Type

Size (Bytes)

ExpenseCodeID

Number (Long)

4

ExpenseCode

Text

30

Table A.28. The Field Properties of the tblExpenseCodes Table

Property

Value

ExpenseCodeID

Number (Long)

AllowZeroLength

False

Attributes

Fixed size, auto-increment

Caption

Expense Code ID

CollatingOrder

General

OrdinalPosition

0

Required

False

SourceField

ExpenseCodeID

SourceTable

tblExpenseCodes

ExpenseCode

Text

AllowZeroLength

False

Attributes

Variable length

Caption

Expense Code

CollatingOrder

General

OrdinalPosition

1

Required

False

SourceField

ExpenseCode

SourceTable

tblExpenseCodes