Newbie w/a few questions

[Davo]

Hello everyone,
I am creating my first Dbase and I am working in Access 2010. I'll apologize now for any lack of awareness of site protocols regarding questions. I am creating a simple Dbase for identifying projects and points-of-contact within various departments. I have created the following tables: "Project name, Notes/Comments", "Departments", "SPOC's", "Project Attachments", and "Required Attachments" Here are my immediate questions:

1) How do you "undo" a join/relationship?

2) I would like to create a new database with the same tables but without the relationships so I can start over if necessary. What is the best way to do this without re-typing all the data into tables again? Can you copy-and-paste data from tables in one Dbase into tables in a new dbase?

3) I think I accidentally copied a table in the relationship screen. One table is titled "Project Name" and contains "ID, Project Name, and Location", there is a second table titled "Project Name_1" and contains the same information as the previous table. The first table "Project Name" has been related to another table. The second Table "Project Name_1" is by itself with no relationships established. The second table also does NOT appear in the navigation pane along with the other tables. Should I delete the "Project Name_1" table. Would that table prevent the rest of the Dbase from working correctly?

4) There are two tables "Departments" and "SPOC's" that have been related to each other but not any other tables. Would this lack of any relationship between these tables and others prevent the Forms from being complete?

Thank you for your patience,
Davo

[June7]

1. Do you mean in the Relationship builder? Click on the line between tables and press Delete.

2. Yes. Can copy/paste between tables, projects and even to/from Excel.

3. Yes. Can delete the duplicated table in the Relationship builder.

4. Possibly. Depends on nature of the data. I would find it unusual to have an isolated relationship. Why do these two tables not relate to any others? Actually building Relationships is not critical to database functionality but it is where you can control referential integrity. Also, having the relationships defined helps when building queries. The table join will automatically be set in query if the relationship is defined. What is important is that the primary/foreign key fields be properly set up.

[Davo]

[QUOTE=June7;88534]1. Actually building Relationships is not critical to database functionality but it is where you can control referential integrity. Also, having the relationships defined helps when building queries.[/QU

Thank you June7, You responses are very helpful. I found your response to question 4 interesting and perhaps hitting on something I've been curious about. I understand your comments about referential integrity and I can see the importance to that. After reading a bit about it, I was wondering if Access Dbases can be built directly from Forms? I felt your comment that "...building relationships is not critical to database functionality..." may have touched on that. Can a form be created and data entered into chosen/created fields, and would the relationships automatically created? Of course there would be a bit more to it (lookups, queries, etc). It seems that the basic tables and relationships would automatically be created from the forms. I viewed a few tutorials and have been reading a book on Access over the weekend and it has not been indicated that Dbases can be developed straight from forms, but if they can't, why not??

Thanks again for your help

[June7]

Cannot build tables from forms. Design and build tables first. Data cannot be saved without tables. Whether or not you set up Relationships is up to you. I have a project with almost 300 tables. About 200 of them would have to be related to the same field of the same table. There is a limit (50 I think) of how many tables can be included in Relationship builder. I have defined relationships for only 11 tables. I control data integrity with code.