Reading: Activity 2 feedback
Activity 2 feedback
Table: Customers
NameTypeSize
CustomerIDLong Integer4
AllowZeroLength: False
Attributes: Fixed Size, Auto-Increment
Caption: Customer ID
CollatingOrder: Neutral
DataUpdatable: False
GUID: {guid {29A795B7-BAE5-4EEB-9256-73DDB5B8251D}}
OrdinalPosition: 0
Required: False
SourceField: CustomerID
SourceTable: Customers
CompanyNameText50
AllowZeroLength: False
Attributes: Variable Length
Caption: Company Name
CollatingOrder: General
DataUpdatable: False
GUID: {guid {0AE79578-22D5-4DF3-AA61-AAD12242D186}}
OrdinalPosition: 2
Required: False
SourceField: CompanyName
SourceTable: Customers
ContactFirstNameText30
AllowZeroLength: False
Attributes: Variable Length
Caption: Contact First Name
CollatingOrder: General
DataUpdatable: False
GUID: {guid {322CB03C-4F0D-47DD-9A2E-51958CAA3219}}
OrdinalPosition: 3
Required: False
SourceField: ContactFirstName
SourceTable: Customers
ContactLastNameText50
AllowZeroLength: False
Attributes: Variable Length
Caption: Contact Last Name
CollatingOrder: General
DataUpdatable: False
GUID: {guid {D81F2977-7344-4E93-ADE1-E48D9F9220CA}}
OrdinalPosition: 4
Required: False
SourceField: ContactLastName
SourceTable: Customers
BillingAddressText255
AllowZeroLength: False
Attributes: Variable Length
Caption: Billing Address
CollatingOrder: General
DataUpdatable: False
GUID: {guid {B3FA9A44-5FD0-4A64-AC7C-4988D6AA5C80}}
OrdinalPosition: 5
Required: False
SourceField: BillingAddress
SourceTable: Customers
CityText50
AllowZeroLength: False
Attributes: Variable Length
Caption: City
CollatingOrder: General
DataUpdatable: False
GUID: {guid {A8B067B1-8006-40C8-860E-A4DB05A58E76}}
OrdinalPosition: 6
Required: False
SourceField: City
SourceTable: Customers
StateOrProvinceText20
AllowZeroLength: False
Attributes: Variable Length
Caption: State/Province
CollatingOrder: General
DataUpdatable: False
GUID: {guid {7F20ADF6-3CCE-4042-996A-F1E5FFFC9F90}}
OrdinalPosition: 7
Required: False
SourceField: StateOrProvince
SourceTable: Customers
PostalCodeText20
AllowZeroLength: False
Attributes: Variable Length
Caption: Postal Code
CollatingOrder: General
DataUpdatable: False
GUID: {guid {38744095-6E04-4B74-9018-B1ED5AFB1A5C}}
OrdinalPosition: 8
Required: False
SourceField: PostalCode
SourceTable: Customers
Country/RegionText50
AllowZeroLength: False
Attributes: Variable Length
Caption: Country/Region
CollatingOrder: General
DataUpdatable: False
GUID: {guid {E9147DB4-F83A-4C67-9E01-22AC9F320940}}
OrdinalPosition: 9
Required: False
SourceField: Country/Region
SourceTable: Customers
ContactTitleText50
AllowZeroLength: False
Attributes: Variable Length
Caption: Contact Title
CollatingOrder: General
DataUpdatable: False
GUID: {guid {5C8DFE14-616B-4604-B6C7-9B87A4D10623}}
OrdinalPosition: 10
Required: False
SourceField: ContactTitle
SourceTable: Customers
PhoneNumberText30
AllowZeroLength: False
Attributes: Variable Length
Caption: Phone Number
CollatingOrder: General
DataUpdatable: False
GUID: {guid {71009EB6-BF22-4603-8544-AE337E137114}}
OrdinalPosition: 11
Required: False
SourceField: PhoneNumber
SourceTable: Customers
FaxNumberText30
AllowZeroLength: False
Attributes: Variable Length
Caption: Fax Number
CollatingOrder: General
DataUpdatable: False
GUID: {guid {E9409D33-068B-43B9-9AC2-6F09A5327774}}
OrdinalPosition: 12
Required: False
SourceField: FaxNumber
SourceTable: Customers
1677_activity_02.doc- 1 -
© State of New South Wales, Department of Education and Training 2006