I am currently a novice DB developer. I have some experience, but mostly with Access.
I am trying to develop a DB for my company that takes data from an Oracle DB and is then manipulated with though my companies editor. I am trying to store the data every month so that I can manipulate the data. Currently I am using Excel to create certain values and changes that I need.
I was wondering what the best way is to create this DB. I am pretty familiar with Access, but I know that there are other ways to retrieve data from the server and then be able to manipulate the data as well.
Could you please give me some ideas?
Thank you.