Hi Ronald
If you are looking for someone to help you work on your database, please post your request
Here

The question is really broad. The data should import over pretty cleanly but your going to need to make sure the relationships are good. Theres a lot of things youre going to learn that you will use as you go through the classes. I would suggest to just keep watching a while further.  If you encounter a specific problem you can post on the forums and we can try to help, but this questions too loaded to really say anything other than keep watching. Especially as a beginner

Ronald, it sounds like you're just getting started with Access, so I would strongly recommend finishing the beginner lessons and then maybe the first 2 levels of the expert classes before you begin tackling a major project. You're going to learn so much between now and then that you'll probably want to start over. At least, that's what I hear from a lot of people.

First thanks to all that replied.
<B>Richard,</B> you are right and I do intend to go thru the courses, I'll most likely have to go thru more than once.
<B>Adam,</B> yes the excel did import without any problem, That is when I discovered that my co-work not here anymore entered all links twice Had to get rid of duplicate.
<B>Sami</B>Using my MasterSingle form when I enter a patched to I want it to save and open the master single with that source input and copy the circuit name. When that is done I'll be able to run a report on that circuit and give to one of the Tech.s to go trace out the fiber circuit to determine the problem and correct it.  I'm not sure how or where a screen shot can be posted.
Again my thanks for all replies
Ron M

I think I need to shrink screen shot before posting.
Is there a preferred size? I know these things can take a lot of space.
Ron M

Your screenshot is fine.
Without seeing your table structure, I think I understand what you're trying to do.
Very easily done in Access. However, it uses techniques you have not yet learnt.
Take Richard's advice and go further with your courses first.

Send screenshots of your tables.

What helps me is to make mockups in Excel or PowerPoint of what I want the database forms to look like. Do some of that and post it here so we can get an idea of what you're trying to do.

Hope these are not to small to view.
The 1st image shows the overall structure of the fiber network, with in this layout there are over 1700 possible connections.
Currently there are 195 circuits names identified. Not sure exactly what you wanted to see.
<B>Side Note: </B>I use GIMP for image editing.