beginner db dummy help
HI

I am new to databases but I have been reading here and there...I have a few questions:
1-I ran the import excel wizard which handle my 2d table quite nicely but I am wondering how to break out a table from the main one after the wizard has already run through - I was able to do it pretty easily during the wizard but I think a couple more columns could be broken out into their own tables...no idea how to do this

2-a yes/no boolean - should it be identified as a yes/no or should I leave it as text? I am getting 0s and -1s... http://www.dbforums.com/db_images_v3/images/smilies/frown.gif

3-is it wrong to use multiple entries in a table where each each entry would typically only have a one to one relationship?

4- this may demand its own post, but I am wondering if anyone has seen any templates for architectural space databases...I haven't been able to find anything, but there must be something like it out there...

thanks!

1. It would require me writing a text book to answer this and somebody has already done that. Can you narrow it down?
2. Yes/No is good. By using a Yes/No, you can more easily implement a check box in Access for that field. 0 and -1 mean false and true in Access.
3. One to ones are highly unusual. There may be a case where you would use a 1:1 to implement polymorphism.j
4. I built one in a manufacturing environment but that was a long time ago. Anyone else have any feedback?

Your questions are a bit broad. I'm sure if you narrow them down a little, someone can get you pointed in the right direction.