Howdy,
I work at a place that includes a popular rock climbing area. They have used an Access DB for many years to track their stats. After learning a fair amount about Access/DB design for my own purposes, I've taken a look at this climbing database, and it seems a pretty big mess. I would like some advice on trying to redesign or make a totally new climbing database.
After starting a new DB file and working on the underlying tables and relationships, I dived into the old climbing DB; now I'm not sure if I can handle this. My first thought was to export the table data to excel so I could clean it up a bit, but I don't know how well that will work. To give you an example, there is simply a "name" field and some of it is "First Last", some of it is "Last, First". There are ~150k records in one table, about 85k in another, so it is pretty large (at least by my standards).
Attached is an image of the current relationships screen. I will post one of my effort for a new DB later. I feel like I'm not giving you all much to go on, but I will do my best to fill in more information.
I work at a place that includes a popular rock climbing area. They have used an Access DB for many years to track their stats. After learning a fair amount about Access/DB design for my own purposes, I've taken a look at this climbing database, and it seems a pretty big mess. I would like some advice on trying to redesign or make a totally new climbing database.
After starting a new DB file and working on the underlying tables and relationships, I dived into the old climbing DB; now I'm not sure if I can handle this. My first thought was to export the table data to excel so I could clean it up a bit, but I don't know how well that will work. To give you an example, there is simply a "name" field and some of it is "First Last", some of it is "Last, First". There are ~150k records in one table, about 85k in another, so it is pretty large (at least by my standards).
Attached is an image of the current relationships screen. I will post one of my effort for a new DB later. I feel like I'm not giving you all much to go on, but I will do my best to fill in more information.