Automated Change of Access Datatype

I have a? MS Access 2007? database which I use on a weekly basis where presently all fields are set (when the database is established each week) to the "Memo" data type. I require a macro (that might itself include a VBA module) that would: 1)allow specific fields in specific tables to be set to either "date/time", "Currency" or "Double" datatypes.? 2) change all remaining field types in all tables of the database to "Text" (i.e. "Text" becomes the default). I don't require you to work on my database. ? I just need the macro so I can then specify the various tables and fields myself.