A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

PLEASE CHECK DB DESIGN



 
 
Thread Tools Display Modes
  #1  
Old March 19th, 2005, 03:17 AM
Dean Welch
external usenet poster
 
Posts: n/a
Default PLEASE CHECK DB DESIGN

The purpose of this database will be to store race results for drag cars,
this will include specifications of the cars setup, engine setup, race
results (including tracks weather info provided on slip at the time of the
race), driver and event . there is normally a drag event 8 times a month and
I want to be able to do a race and record the results on the time slip these
results include,
Race Time (e.g 3:59pm),
TrackTemperature, RelativeAltitude, Milibars, Humidity, AirTemperature,
Reaction, 60ftTime, 330ftTime, 660ftTime, 660ftMPH, 1000ftTime, ElapsedTime,
ElapsedMPH.
I also want to be able to record ,
TyreType, TyreSize, GearBox, DiffRatio, EngineCompression, Carburetor,
FrontJets, RearJets, FuelPressure, BaseTiming, TotalAdvance, TyrePressureHot,
TyrePressureCold, StageRPM, ShiftRPM, so that when i changed the jets in the
carby (or other engine or car specs) between races i know what difference it
made.I also need event info as there are multiple tracks across australia,
car info to be able to identify the car, and driver info so I can keep tabs
on driver and what car they raced at what event and which race at that event.
there could also be different drivers for the same car at the same event,(e.g
i could do a run in my brothers car). The database needs to be setup for
multiple entries (e.g many cars at one event) as many drag racers have shown
an interest, (Thanks to my big mouth brother???)

Main outcomes for the database will be to record a cars race results for a
particular event to keep track of the cars performance, and so that I can
search back through previous races by weather info, and setup the car and
engine the same so that the car keeps running consistent race times, because
the relative altitude, air temp, milibars, race track temp can make a big
difference in the overall race time & mile per hour.

The database has already been built and can be downloaded at

http://www.dfwcomputer.com/db/db1.zip

thanks in advance.....
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I customise an entire design set David Publisher 2 November 12th, 2004 09:43 AM
Action queries changing when reopened in design view Kendra Running & Setting Up Queries 2 August 31st, 2004 12:34 AM
opening a document so it is NOT in design mode Brad Pears New Users 1 May 3rd, 2004 09:13 PM
Dependent check boxes Elijah Worksheet Functions 1 April 8th, 2004 01:58 PM


All times are GMT +1. The time now is 12:02 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.