Hello,
I work for the local authority music service. We currently use several databases for the different services we offer. The problem is that many of the services we prove are used by the same children for example one child will attend one of our music ensembles, hire an instrument from us and attend any trip/residentials we organise, meaning that their details are repeated across several different databases.
I'm trying to look for a way to link them all together so that any child that use any of our services will have their own 'account' and i will be able to open up their account and see all of the services they access all in one place.
I've being using microsoft access for nearly ten years but I only know the basics. I can create tables, define their data type, and create basic queries but thats it. My workplace has free online courses on access that I have completed so I have learned a bit more about forms, macros, relationships etc but the more I learn the more I'm realising that the database I want to create is quite complicated.
I've tried approaching our IT dept but we now use a shared IT company with other councils and not only do they want to charge me an obscene amount of money to help they are also saying that Access is unsupported. That has lead me to the decision to try and learn my self.
I understand that this is probably going to be a big job, but is there anyone out there willing to help me?