E
Emine
I was always confused on the following and I hope that someone can actually
answer a couple of these questions for me. BTW all you Gurus on this forum
are absolutely fantastic! You guys are great! I've learned so much from all
your expertise advise. Anyways here are my questions:
1. How do I set-up relationships and what is considered a primary table?
2. How are the relationships in a table joined and what is the best way to
join tables? I know about the primary key, but for some reason, sometimes my
relationships do not work.
3. What is front end and back end?
4. How do you setup a database so that others can use it simultaneously?
5. When Excel spreadsheets are updated (ones that I will be using for
importing) what is the best way to automatically import the updated
information into the database?
If someone can provide these answers for me OMG I would truly appreciate it.
I am in the processing of actually designing one, have not started, but will
be tasked to start one.
answer a couple of these questions for me. BTW all you Gurus on this forum
are absolutely fantastic! You guys are great! I've learned so much from all
your expertise advise. Anyways here are my questions:
1. How do I set-up relationships and what is considered a primary table?
2. How are the relationships in a table joined and what is the best way to
join tables? I know about the primary key, but for some reason, sometimes my
relationships do not work.
3. What is front end and back end?
4. How do you setup a database so that others can use it simultaneously?
5. When Excel spreadsheets are updated (ones that I will be using for
importing) what is the best way to automatically import the updated
information into the database?
If someone can provide these answers for me OMG I would truly appreciate it.
I am in the processing of actually designing one, have not started, but will
be tasked to start one.