I am using Windows 7 and Microsoft Access 2007.
I recently imported a lot of data from Microsoft Excel 2007 into Access. The field size allotted for each column was 255. Some of the columns contain only 15 characters, but none of the others contain 255.
Is there any way to reduce the size of the fields safely, so no data is lost? I am new to Access and I don't know how to program or do anything complicated now. Please explain the procedure in easy English. Thank you very much.