I have a guestion about designing a Access database that will be used by a windows program. In my case I'm designing a database that will have information about the loans of a bank has: name and address of customer, start date and maturity date of the loan, amount and interest rate.
My question is what type of field description should I use in the database. My first choice is to use the Text field description. I don't plan on doing any calculations with the numbers.
The users of the application will be moving from edit control to edit control typing in the information.
If I'm just entering text is there any advantage to having the type of information I'm entering match the database field in some way. Example. Should my interest rate be a float and the loan amount be a long?