Merging fields in a table

[Bx Snipe]

I have started a database to track my coin collection I have 2 questions.

1. I started tables for various coins the tables have 6 fields in addition to the primary field description, year, mint, condition, value & notes I decided it would make more sense to include the mint with the year is there any way to combine these 2 fields or do I have to redo the information?

2. I initially started with multible tables for certain denominations of coins ie: jefferson nickles, Buffalo nickles I have since decided it would be easier to have all the same denomination coins in the same table is it possible to merge tables?

[June7]

1. Use query and create a field by expression that concatenates the two fields. There is no need to actually save the concatenated value in table and is probably a bad idea to do so - this can be calculated whenever needed. Concatenation is easier than splitting.
SELECT *, Mint & [Year] As MintYear FROM tablename.

2. Could probably have all coins regardless of denomination in one table. Just have another field for the denomination attribute. Can use an action sql (probably an INSERT SELECT) to merge tables or maybe just a manual copy/paste of records will serve your needs.