Adrenaline Rush Car Club

Xenia Ohio
 
HomeHome  CalendarCalendar  GalleryGallery  FAQFAQ  SearchSearch  RegisterRegister  MemberlistMemberlist  UsergroupsUsergroups  Log in  

Share | 
 

 Database help needed

View previous topic View next topic Go down 
AuthorMessage
Jerry
Admin


Number of posts : 760
Age : 56
Location : Xenia OH
Registration date : 2007-11-25

PostSubject: Database help needed   Wed 07 Jul 2010, 10:50 pm

Is anyone proficient at Microsoft Access? Chris Swag. and I are talking about creating a database to use at our car show.

Jerry
Back to top Go down
View user profile http://www.jerry-nita.com
Lil Fish
ARCC President


Number of posts : 1018
Age : 31
Location : Xenia, Ohio
Registration date : 2007-11-25

PostSubject: Re: Database help needed   Wed 07 Jul 2010, 11:24 pm

this would be awsome
Back to top Go down
View user profile http://profile.myspace.com/index.cfm?fuseaction=user.viewprofile
doored90
ARCC Vice President


Number of posts : 1174
Age : 31
Location : xenia
Registration date : 2008-01-05

PostSubject: Re: Database help needed   Thu 08 Jul 2010, 7:54 pm

sami is
Back to top Go down
View user profile http://www.ohiominitrucks.com
playin4keeps
ARCC Member


Number of posts : 1262
Age : 29
Location : Xenia
Registration date : 2008-01-07

PostSubject: Re: Database help needed   Thu 08 Jul 2010, 11:24 pm

why not excl?
Back to top Go down
View user profile
Jerry
Admin


Number of posts : 760
Age : 56
Location : Xenia OH
Registration date : 2007-11-25

PostSubject: Re: Database help needed   Thu 08 Jul 2010, 11:29 pm

Chris Swag. found an Excel file on line but it needs work. I just thought that with the information we want to use and the queries would probably require an Access database. If someone is good enough with Excel then lets get it going.
Back to top Go down
View user profile http://www.jerry-nita.com
berger13
ARCC Secretary


Number of posts : 796
Age : 28
Location : Dayton, Ohio
Registration date : 2009-04-20

PostSubject: Re: Database help needed   Thu 08 Jul 2010, 11:58 pm

let me talk to emily about it cause she took IT (information technology) in high school for 4 years and shes pretty good with all the computer crap. i know a little about excel so i may be of some help

_________________
SPOOL MAKES HER DROOL!!!!
Back to top Go down
View user profile
Samikins
Fan
Fan


Number of posts : 60
Age : 28
Location : Dayton, Ohio
Registration date : 2008-05-14

PostSubject: Re: Database help needed   Fri 09 Jul 2010, 12:50 pm

i'm not that good in microsoft access.. I'm more of a powerpoint and excel and word.. thats about it. but I'm willing to help if need be..
Back to top Go down
View user profile
Jerry
Admin


Number of posts : 760
Age : 56
Location : Xenia OH
Registration date : 2007-11-25

PostSubject: Re: Database help needed   Fri 09 Jul 2010, 2:09 pm

What we need is:

Entry #: (automatic sequential)
Class: (should be a list of classes to scroll through and pick from. Plus the ability to easily add classes)
Name: (I Don't think we need to separate first and last name)
Email:
Club Affiliation:
Year:
Make:
Model:
Judge 1 scores: (Columns defined by Judging sheets)
Judge 2 scores: (Columns defined by Judging sheets)
Judge 3 scores: (Columns defined by Judging sheets)
Total score: (The total score for all three judges)
Best of show: (highest score over all)
Best Paint: (this should be a yes or no box)
Best Interior: (this should be a yes or no box)
Greene Leaf Pick: (this should be a yes or no box)
Pink ladies Pick: (this should be a yes or no box)
Best Paint: (this should be a yes or no box)


Be able to create a list separated by class and score for highest to lowest and a list with just highest to lowest score for all entries so we could do a top ?

Be able to create a list of all the "Best" and Club Participation.
Back to top Go down
View user profile http://www.jerry-nita.com
Samikins
Fan
Fan


Number of posts : 60
Age : 28
Location : Dayton, Ohio
Registration date : 2008-05-14

PostSubject: Re: Database help needed   Fri 09 Jul 2010, 2:26 pm

To be honest.. i think we can do this in excel also... I can mess around with it if you want... and is this like.. per person that shows up or for everyone? cause if its per person then you really don't need to have all the other stuff under the total score, right? I'm just asking so I can mess around with it...
Back to top Go down
View user profile
Jerry
Admin


Number of posts : 760
Age : 56
Location : Xenia OH
Registration date : 2007-11-25

PostSubject: Re: Database help needed   Fri 09 Jul 2010, 3:10 pm

The total score will be the combined scores for all the judging categories for each judge.

Example:

Judge 1: Interior, engine, paint, mods/original, interior, cleanliness...
Judge 2: Interior, engine, paint, mods/original, interior, cleanliness...
Judge 3: Interior, engine, paint, mods/original, interior, cleanliness...
Back to top Go down
View user profile http://www.jerry-nita.com
Lil Fish
ARCC President


Number of posts : 1018
Age : 31
Location : Xenia, Ohio
Registration date : 2007-11-25

PostSubject: Re: Database help needed   Fri 09 Jul 2010, 6:27 pm

i think we might only have 2 judges
Back to top Go down
View user profile http://profile.myspace.com/index.cfm?fuseaction=user.viewprofile
Samikins
Fan
Fan


Number of posts : 60
Age : 28
Location : Dayton, Ohio
Registration date : 2008-05-14

PostSubject: Re: Database help needed   Sat 10 Jul 2010, 12:34 am

So.. I'm messing around with excel and I got somethings done on it.. I want you to look at it Jerry that way I can keep going with it.. if you don't like it let me know! haha I'm just trying to help out... so how can I get it to you Jerry? remember.. it's just a start..
Back to top Go down
View user profile
Samikins
Fan
Fan


Number of posts : 60
Age : 28
Location : Dayton, Ohio
Registration date : 2008-05-14

PostSubject: Re: Database help needed   Sun 11 Jul 2010, 5:59 pm

I tried to figure out a way to make each separate table into 1 group by their class but i can't figure it out.. so I'm kinda stuck there...so I dunno if i can help you out jerry.. =[ I'm sorry.. I tried though.. hah
Back to top Go down
View user profile
Jerry
Admin


Number of posts : 760
Age : 56
Location : Xenia OH
Registration date : 2007-11-25

PostSubject: Re: Database help needed   Mon 12 Jul 2010, 12:04 am

Thanks for the effort Sami. I have something that is working I just need to refine it.
Back to top Go down
View user profile http://www.jerry-nita.com
Sponsored content




PostSubject: Re: Database help needed   

Back to top Go down
 
Database help needed
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» oil flush is it needed
» Internet Car movie database-cool!
» Left Back Needed
» Goalkeeper needed for Saturday - Leicester City Supporters
» Welding help Needed..

Permissions in this forum:You cannot reply to topics in this forum
Adrenaline Rush Car Club :: GENERAL :: OFF TOPIC-
Jump to: