98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Database design
Database design
Resolved · Medium Priority · Version 2016
Fri 22 Sep 2017, 14:08Delegate Charlotte said...
Charlotte has attended:
Access Introduction course
Database design
Hi,
We are currently looking to build a database with information on clients and service providers and in designing it we had a few questions, which we were hoping we could get some clarification on.
1. Is it possible to create relationships between a look-up table to several junction tables?
a. If yes is it best to have minimal junction boxes
2. Can junction tables be added at a later date or is a very complicated exercise?
3. Are multiple persons able to add/edit records at the same time?
4. It was mentioned on the course that emails can be sent from the database, requesting information from the recipient and once this information is completed it will automatically update in the database. How is this set up?
Thank you
Fri 22 Sep 2017, 14:49Trainer Jens said...
RE: Database design
Hi Charlotte,
Thank you for the forum questions.
1. Yes you can have any number of junction tables related to the same lookup table.
a. I am not sure what you mean by junction boxes
2. Yes you can add junction tables later and I cannot answer if it is very complicated. An Access database must be created right from the start. If it is not, adding more tables can be very complicated. But if the database is structured the right way, it is easy to continue develop it adding more tables.
3. With a normal installation of Access 25 can work in the database at the same time. If you need more to have access, it is a bit technical and you will have to ask your IT department for help.
4. I am sorry but Microsoft has removed the option from MS Access 2016.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Fri 22 Sep 2017, 16:46Delegate Charlotte said...
RE: Database design
HI Jens,
Thank you very much for your swift response.
On question 1.a., my apologies I meant junction tables and whether it is recommended to have a minimal number of junction tables?
In connection with that if the primary key in a look-up table is connection to several junction tables, when a record is updated in one of these junction tables will the information automatically update in throughout the database?
King regards,
Charlotte
Fri 22 Sep 2017, 17:13
Edited on Fri 22 Sep 2017, 17:14Trainer Jens said...
RE: Database design
Hi Charlotte,
You will need to have the number of junction tables you need. It is all about which kind of relationships you need. If you need many to many relationships you must have junction tables to get this. This part can be a little difficult. If you update a record in the junction table the amended record will be displayed in queries, reports and forms.
kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 28 Sep 2017, 11:09Trainer Wendy said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Fri 29 Sep 2017, 17:16Delegate Charlotte said...
RE: Database design
Please first state which training course this forum post is about:
Hi Jens,
We would like to send you the database design. Could you please provide me with your email address?
Thank you and kind regards,
Charlotte
Sat 30 Sep 2017, 22:24Trainer Jens said...
RE: Database design
Hi Charlotte,
You can send it to:
info@stl-training.co.uk
Can you please tell me, what is the question?
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 16 Oct 2017, 14:20Trainer Wendy said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Mon 23 Oct 2017: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create An Inaccessible Field On A FormThere is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this: |
