Share this Page URL

Chapter 14. Understanding Access Project... > Creating SQL Server Tables in an Acc... - Pg. 519

Understanding Access Projects 519 6. 7. Click in the row for the AmountSpent field. On the Columns tab at the bottom of the window, enter 0.00 for the Default Value property. As in an Access database, the Default Value property sets the value that will appear by default for this field. Some of the other properties you are likely to set for a field in an Access project include the following. These properties aren't included for all data types. · Precision The maximum number of digits for values in the column. · Scale The maximum number of digits to the right of the decimal point for values in the