I have a database I'm trying to put together for a graduate school project I'm working on. Essentially, I'm looking for an event/incident/attack tracker. I'm looking to track all attacks across the continent of Africa. The fields I need are: ID, Incident Date, Perpetrator (al-Shabaab, Boko Haram, AQIM, unknown), City/District, Administrative Divisision/State/Region, Country, Target, Tactic, Weapon, Whether the attack was coordinated or not, If Hostage(s) were taken, if target was US/Western, if attack was suicide attack or not, if attacker was female?, civilian casualties, civilian fatalities, notes, and possibly, perpetrator casualties.
I need this to be as simple for me to input information starting with event number 1 but I would also like to be as simple as possible for people viewing the database. I want them to open the file and be greeted with a nice welcome page explaining the database, and then be brought to a series of menus where they will be able to search for information specific to a group or a target or a weapon used. It would be amazing if people could cross search, so they could compare, for example, how many IEDs Boko Haram used versus al-Shabaab between two given dates.
Before I waste all your time, I just want to make sure you're interested in the project and I figured as a member of the AF you may be more interested in a database such as this than other people on this website. Time is also a bit of problem as I need to show something to my class in two weeks or so. I think once the framework is in place I can upload all the data quite easily but making the database has been causing me the biggest problems, so it was time for me to outsource.
Let me know what you think and tell me how comfortable you are with creating a snazzy Access database. Thanks!