MSAccess Top Gear Episode Guide...in Progress

[FoolishOne]

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

[No Boss]

Another episode guide.....eh what the hell, why not?

[SL65]

...ANOTHER ONE

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?"

[ESPNSTI]

Nice and

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. )
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)

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.

[burnsy]

Originally Posted by ESPNSTI

Nice and

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. )
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)

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