Divide one field (column) into 2 or more in Microsoft Access. A wizard guides you through the process of selecting a field (and table) to be split. The values found in the field will be split by a delimiting (dividing) character of your choice. The necessary amount of new fields will be created with the new split-data.