FinalGear.com Forums  

Go Back   FinalGear.com Forums > Shows > Top Gear

Welcome to the FinalGear.com Forums!

Top Gear Jeremy Clarkson, Richard Hammond, and James May host the best automotive television show in the world.

Reply
 
LinkBack Thread Tools Search this Thread
Old January 26th, 2006, 9:45 PM   #1
 
Joined: Jan 14th, 2006
Last Online: October 26th, 2009
Location: Branchville, NJ
Posts: 5
Rep Power: 0
FoolishOne has between 0 and 9 reputation
Default MSAccess Top Gear Episode Guide...in Progress

I was reading one of the threads in which someone mentioned an Access format guide, which I was suprised no one did yet, so I thought that I would at least try. I have started the database with only one table but have a few questions.

The information in the database is taken from janpi's thread and Excel guide.

The time has to be stored as a string, and not time, because of the decimal point, which makes it harder to do a query, can't do < or > 1:34.6 s for example. Do you want the first name and the last name for the guests so you can do a query by last name and not have to remember the first name? Do you want a separate option for in the wet, because you can't search for just in the wet or dry, have to get both. Some of the other Excel are better because all you have to do is a Ctrl-F and type what you want to find, which is a little bit different than performing a query.

Anyways...

http://www.thedisarnos.com/TopGear/TopGearEpisodes.mdb

»fo
FoolishOne is offline   Reply With Quote
Want To Remove This Ad? Just Register For A FREE Account!
Old January 26th, 2006, 10:36 PM   #2
Neener, neener, I banned your title!
 
No Boss's Avatar
 
Joined: Oct 8th, 2005
Last Online: November 8th, 2009
Location: 'mericuh, someday the UK.
Age: 24
Posts: 6,859
Car: 2005 Volvo S60 R
Rep Power: 86
No Boss has a reputable reputation.No Boss has a reputable reputation.No Boss has a reputable reputation.No Boss has a reputable reputation.No Boss has a reputable reputation.No Boss has a reputable reputation.No Boss has a reputable reputation.No Boss has a reputable reputation.No Boss has a reputable reputation.No Boss has a reputable reputation.No Boss has a reputable reputation.
Default

Another episode guide.....eh what the hell, why not?
__________________
No Boss is offline   Reply With Quote
Old January 26th, 2006, 11:05 PM   #3
Ambitious but rubbish!
 
SL65's Avatar
 
Joined: Jul 12th, 2004
Last Online: November 10th, 2009
Location: Sydney, Australia
Age: 19
Posts: 9,299
Car: 1998 Subaru Legacy 2.5L
Rep Power: 46
SL65 has between 1500 and 1999 reputationSL65 has between 1500 and 1999 reputationSL65 has between 1500 and 1999 reputationSL65 has between 1500 and 1999 reputationSL65 has between 1500 and 1999 reputationSL65 has between 1500 and 1999 reputationSL65 has between 1500 and 1999 reputationSL65 has between 1500 and 1999 reputationSL65 has between 1500 and 1999 reputationSL65 has between 1500 and 1999 reputationSL65 has between 1500 and 1999 reputation
Default

...ANOTHER ONE images/smilies/lol.gif

Well thanks for the contribution. At least your worth something to this forum.

Sad thing is, people aren't going to search before they post a silly question like "What episode was the DB9 tested?" images/smilies/rolleyes.gif
SL65 is offline   Reply With Quote
Old January 27th, 2006, 12:32 AM   #4
Can't Find Waldo
 
ESPNSTI's Avatar
 
Joined: Dec 9th, 2003
Last Online: Yesterday
Location: Decorah, IA
Age: 37
Posts: 4,333
Car: 2004 Subaru Impreza WRX STI (USDM)
LFS Status: LFS Status
Rep Power: 42
ESPNSTI has between 1000 and 1499 reputationESPNSTI has between 1000 and 1499 reputationESPNSTI has between 1000 and 1499 reputationESPNSTI has between 1000 and 1499 reputationESPNSTI has between 1000 and 1499 reputationESPNSTI has between 1000 and 1499 reputationESPNSTI has between 1000 and 1499 reputationESPNSTI has between 1000 and 1499 reputationESPNSTI has between 1000 and 1499 reputationESPNSTI has between 1000 and 1499 reputation
Default

Nice images/smilies/thumbup.gif and images/smilies/welcome.gif

Added to the List 'O Guides : http://forum.finalgear.com/viewtopic.php?t=8925


Not sure that I see how a guide in database format is all that practical without a nice front end. (And also since not people will have Access installed).
I for one go out of my way to NOT having access installed. (IMHO, Access is the red headed step-child of the database family. images/smilies/tongue.gif )
Making a nice front end is a lot of work.
If you were to make a front end though, you'd probably want to use HTML. And if you're going to go there, you might as well use MySQL or something like that instead. 8)

Quote:
Originally Posted by FoolishOne
The time has to be stored as a string, and not time, because of the decimal point, which makes it harder to do a query, can't do < or > 1:34.6 s for example.
In MS SQL you can do something like that. I know Access can't do a lot of things, but I would imagine it would at least be able to do that.
Having said that, in practice you probably wouldn't query on something like that anyway.
Instead you'd simply open the list sorted by time and scroll to the time range you're interested in.
ESPNSTI is offline   Reply With Quote
Old January 28th, 2006, 7:02 PM   #5
 
burnsy's Avatar
 
Joined: Mar 25th, 2005
Last Online: 3:48 AM
Location: Indiana, USA
Age: 27
Posts: 691
Car: 2006 Ford Ranger FX4
LFS Status: LFS Status
Rep Power: 20
burnsy has between 50 and 149 reputationburnsy has between 50 and 149 reputation
Send a message via MSN to burnsy
Default

Quote:
Originally Posted by ESPNSTI
Nice images/smilies/thumbup.gif and images/smilies/welcome.gif

Added to the List 'O Guides : http://forum.finalgear.com/viewtopic.php?t=8925


Not sure that I see how a guide in database format is all that practical without a nice front end. (And also since not people will have Access installed).
I for one go out of my way to NOT having access installed. (IMHO, Access is the red headed step-child of the database family. images/smilies/tongue.gif )
Making a nice front end is a lot of work.
If you were to make a front end though, you'd probably want to use HTML. And if you're going to go there, you might as well use MySQL or something like that instead. 8)

Quote:
Originally Posted by FoolishOne
The time has to be stored as a string, and not time, because of the decimal point, which makes it harder to do a query, can't do < or > 1:34.6 s for example.
In MS SQL you can do something like that. I know Access can't do a lot of things, but I would imagine it would at least be able to do that.
Having said that, in practice you probably wouldn't query on something like that anyway.
Instead you'd simply open the list sorted by time and scroll to the time range you're interested in.
taking the idea from the guy, i too have made a access from your excel sheet. i also made a front end, and the searching is very easy, just type whatever you want, and it'll find it. i too was thinking of doing mysql, i've got a server running it now, just don't have the time right now. i'll get to it later. here's the file for the access database though: http://burnsy.no-ip.info/Top_Gear_Episodes.mdb
__________________
Quote:
Originally Posted by RATM - Down Rodeo
Can't waste a day when the night brings a hearse
Make a move and plead the fifth 'cause ya can't plead the first
Team FinalGear.com | CoRe Racing
burnsy is offline   Reply With Quote
Want To Remove This Ad? Just Register For A FREE Account!
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Go Back   FinalGear.com Forums > Shows > Top Gear
Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 7:17 AM.
All content © FinalGear.com unless stated otherwise.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.2
Page generated in 0.17986 seconds with 17 queries by web1
no new posts