The tblProjects Table

This table stores information about each project, including a cost estimate and important dates.

Table A.33. The tblProjects Table

Field Name	Type	Size (Bytes)
ProjectID	Number (Long)	4
ProjectName	Text	50
ProjectDescription	Memo	n/a
ClientID	Number (Long)	4
PurchaseOrderNumber	Text	50
ProjectTotalEstimate	Currency	8
EmployeeID	Number (Long)	4
ProjectBeginDate	Date/Time	8
ProjectEndDate	Date/Time	8