Hi All,
I have been struggling with how begin to create an Access Database with my existing data. Currently, I am using an Excel document, but it simply isn't doing the trick.
Explanation of current data:
I am doing a project on O'Charley's Restaurants. I am to check whether or not each of its 220 individual restaurant locations are listed on 20 different online directory sites. These sites include Bing, Yahoo, Google+, Citysearch, Insider Pages, Yelp, etc. The options are that a listing is "correct", "incorrect", or "missing." Each individual O'Charley's Restaurant has a unique store code and each of the 220 location belongs to a specific region (there are 57 regions total). I have obtained all of this different data, but as you can imagine, it is very difficult to calculate across 220 Excel sheets (this is how I've structured my data recordings), as well as figure out for example how many "Correct" listings does all of O'Charley's have on Bing.
For every restaurant the directory sites in question are the same. Additionally, there are only 3 options for a directory site's status (correct, incorrect, or missing) and I would like to be able to break down the data regionally (57 regions) as well by individual location. I am unsure how to create these tables with correct relationships without creating a database that just looks like a gigantic Excel sheet.
PLEASE, PLEASE, PLEASE, any help or guidance would extremely appreciated.
All the best,
Lindsey