Rocketry Center Forums
Building a Data Base - Printable Version

+- Rocketry Center Forums (https://rocketrycenter.com)
+-- Forum: General Discussions (https://rocketrycenter.com/forumdisplay.php?fid=1)
+--- Forum: Rocketry-Related (https://rocketrycenter.com/forumdisplay.php?fid=46)
+--- Thread: Building a Data Base (/showthread.php?tid=173)

Pages: 1 2


RE: Building a Data Base - phlash - 07-26-2015

Try now. It'll be interesting to see if the db, once built, saves back.
https://dl.dropboxusercontent.com/u/12567537/RocketLogTables.xls


RE: Building a Data Base - j.a.duke - 07-27-2015

(07-14-2015, 12:43 AM)JEAdams Wrote: I would to look up rockets by;
Manufacturer
Skill Level
Engine size: 13, 18, 24, & 29mm
Max. Altitude listed.
Upgrades such as Engine Mounts and Recovery options for a certain rocket.
If it's a duplicate with upgrades (1 stock, 1 with upgraded Engine Mount and/or recovery system/electronics.
Built or unbuilt.
Build status, like in assembly, ready for primer, ready for paint, etc.
If it's OOP and collectable.
And in my case, if it's for me to build and fly, or for one of my 2 son's collection (so I don't screw up and build something ment to leave to them when I'm gone.
Maybe even include a flight status card for each rocket each time it's launched and what went wrong and repairs needed. Materials is not needed unless it's electronics.
I tried for 2 days, but Works just isn't powerful enough.
I totally lost in access.
Help would be greatly appreciated by a database expert.
I know it's a lot of crap to try and put together. I realize this now.
I can do it on paper no problem, I just have a very, bery hard time reading and understanding instructions.
So eye's and hands on would be a big help.

(07-18-2015, 09:56 PM)j.a.duke Wrote: I’ve started work on this-will have a little more time in the next week or two.

I’ll keep you posted on my progress.

Cheers,
Jon

(07-25-2015, 04:49 PM)phlash Wrote: I'm making good progress on mine.  I'm working nibbles at a time, but it's coming together nicely.  Here's a spreadsheet with examples of the tables (so far).  If you find something lacking, let me know and I'll see if it can be added.
https://dl.dropboxusercontent.com/u/12567537/RocketLogTables.xlsx

Phill,

Are you building it in Access or Excel?

If you don’t have objections, I’d like to use some of your ideas.  

I really like some of your ideas like the engine chart, the launch needs (e.g. rod or rail size), the kit instruction links.

I’ve also got the ability to pull the instructions (in PDF format) directly into the database for storage not dependent upon a site being available long term.

I’ve enclosed what I’ve defined so far, but your ideas are making me re-think the design a bit, so I’m back a couple of days while I work on adding additional items. 

Thanks.

Cheers,
Jon


RE: Building a Data Base - JEAdams - 07-27-2015

Yea Phill, I can open that spreadsheet.
Thanks.


RE: Building a Data Base - phlash - 07-28-2015

Access. I just dumped the tables to excel so that non-DB types could view 'em too.


RE: Building a Data Base - JEAdams - 08-26-2015

I found a box yesterday that contained a bunch of CD's.
To my surprise, I found my Video Professor 3 disc set on Access.
Been up all night, been through the 1st CD and think I got this worked out as far as fields I want n such.
It's just getting all the crap entered into it.
Then it's on to disc 2.
Perhaps that will give me the reports/data I want to look at.
Once I get things to a point that I think it would be worth while sharing, I'll do so.
I'm hoping that these CD's will teach me how to link a table of flight sheet data to each rocket in another table.
Showing all kinds of information.
It's amazing no one has done this before.
Or if they have, they have not shared it.
Time for a nap...ZZZZZZZ


RE: Building a Data Base - phlash - 08-26-2015

Cool!
I've been occupied with my L3, so I haven't put any time in on finishing up my Database. I'm travelling this weekend, so I should port it back to Office 2003 and put it on my laptop...