Step 1
Determine Data Requirements
Decide what information you'll want to collect and what type of information (data type) that will be.
Possible date types include:
AlphaNumeric - includes a-z, 0-9 and punctuation characters (aka string or nvarchar)
Integer - whole numbers 0-9 only
Decimal - Decimal numbers 0-9 & a decimal point
Money - Currency 0-9 a decimal point and a currency indicator ($)
Date/Time - Dates or times
Boolean - a value of 0 or 1 indicating True/False or Yes/No
For this example we will use a small number of data fields but your table can be as large and as complex as you want.
| Data Field |
Data Type |
| FirstName |
AlphaNumeric |
| MiddleName |
AlphaNumeric |
| LastName |
AlphaNumeric |
| SSN |
AlphaNumeric we use AlphaNumeric here because we want to store the value like xxx-xx-xxxx |
| BirthDate |
Date |
NEXT