So I just started working at an advertising firm and I'm trying to reorganize their various excel files into an access database. This is my first time using access.
Basically what we track is the amount of money we put in our advertising channels, and the subscriptions we get via each channel. Multiple channels are, at times, owned by one partner (e.g Google is a partner, the channels are desktop, mobile, search, display etc).
What I've done so far is to create four tables: a list of partners, a channel list, and then spend and subscriber tables. The latter two have columns for channel, date, and spend/subs.
What I'd like to do is be able to query via partner or channel the amount spent and the number of subscriptions during time periods. How should I set up the relationships to adequately do this?
Also does anyone know any reference books that would help me?