Access Step by Step

Comedian2004 · 05-31-2006, 10:36 PM

I have created this step by step demo to export out the data and then import it into Acess and then the steps to do something with the data.

http://www.sim2005.com/Access/Default.htm

Let me know what you think of it.

Lots of pictures, so give each page time to load.

NOTE: This is just importing the data using CSV, not using the harder SQL stuff. Newbies should have no problem doing something like this.

Bonedwarf · 06-01-2006, 02:47 AM

HELLO! Not see you around (not that I've been around on here much) and was gonna PM you and ask if you'd joined us in the land of OOTP 2006.

Very glad you have. I don't give a crap what anyone says, your util for OOTP6 was awesome, and you didn't get nearly enough credit IMO. (Perhaps because you came in near the end of it's run.)

Looking forward to what you might have in story for us this time

alasxdair · 06-01-2006, 04:09 PM

This is great! I've dabbled in Access before, but really wasn't too sure what I was doing. I really enjoyed seeing it all explained to me. I'd definitely like to see more!

Mike Donlin · 06-04-2006, 02:20 PM

Thanks so much for this. I'm a noob at this stuff but I want to learn more and this is a VERY helpful start.

boilermaker · 06-06-2006, 07:11 PM

Quote:

Originally Posted by Comedian2004

NOTE: This is just importing the data using CSV, not using the harder SQL stuff. Newbies should have no problem doing something like this.

Very easy to follow, I may jump on the active newbie wagon this week.

gbmoore121 · 06-13-2006, 10:27 PM

This is great! Thank you very much.

gbmoore121 · 06-13-2006, 11:15 PM

Comedian,
You mentioned you might do more if there was interest. If you do, I would like to see how to use additional reports (ie. career batting). Not sure how to use them together.

Comedian2004 · 06-15-2006, 04:06 PM

Ok, feedback looks good, so here is lesson two:

http://www.sim2005.com/access2/

Please let me know what you think.

gbmoore121 · 06-15-2006, 04:35 PM

Another great one! Thank you.

gbmoore121 · 06-16-2006, 06:23 PM

Comedian,

IS there a way to get Access to automatically create calculations (expressions??) for you? I was thinking of something that would look at a players VORP and make some calculations (Career, Top 3, Top 5 consecutive and per 162). This is a play on the Bill JAmes system with WS.

Is that too complicated?

EDIT: I don't mean automatically create calculations, but perform those calculations after you enter them?

Comedian2004 · 06-16-2006, 07:03 PM

Yes, you can, I will do that in the next lesson.

Church OOTP · 06-18-2006, 05:51 PM

umm ... Hero!

gbmoore121 · 06-08-2010, 04:50 PM

Did anyone save these instructions? I remember them being very good.

Also, anyone hear from Comedian recently? I know he posted about some health issues back in 2009, but said he had recovered. Hope he is well.

DWK · 08-08-2010, 07:04 PM

I also would like to know if anyone has these

yazfan67 · 11-25-2010, 08:57 PM

The website link is not loading for me, has it changed? I'm really trying to work on getting reports to my Access2007 and nothing seems to work.

Bluenoser · 07-25-2011, 09:00 AM

Both links are dead, hopefully someone has these still and will share.

05-31-2006, 10:36 PM	#1 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,870 Thanks: 0 Thanked 22x in 14 posts	Access Step by Step I have created this step by step demo to export out the data and then import it into Acess and then the steps to do something with the data. http://www.sim2005.com/Access/Default.htm Let me know what you think of it. Lots of pictures, so give each page time to load. NOTE: This is just importing the data using CSV, not using the harder SQL stuff. Newbies should have no problem doing something like this. __________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

06-15-2006, 04:06 PM	#8 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,870 Thanks: 0 Thanked 22x in 14 posts	Ok, feedback looks good, so here is lesson two: http://www.sim2005.com/access2/ Please let me know what you think. __________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

06-16-2006, 06:23 PM	#10 (permalink)
gbmoore121 Major Leagues Join Date: Feb 2002 Location: Arizona Posts: 442 Thanks: 22 Thanked 6x in 5 posts	Comedian, IS there a way to get Access to automatically create calculations (expressions??) for you? I was thinking of something that would look at a players VORP and make some calculations (Career, Top 3, Top 5 consecutive and per 162). This is a play on the Bill JAmes system with WS. Is that too complicated? EDIT: I don't mean automatically create calculations, but perform those calculations after you enter them? Last edited by gbmoore121; 06-16-2006 at 06:24 PM.

06-16-2006, 07:03 PM	#11 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,870 Thanks: 0 Thanked 22x in 14 posts	Yes, you can, I will do that in the next lesson. __________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

06-08-2010, 04:50 PM	#13 (permalink)
gbmoore121 Major Leagues Join Date: Feb 2002 Location: Arizona Posts: 442 Thanks: 22 Thanked 6x in 5 posts	Did anyone save these instructions? I remember them being very good. Also, anyone hear from Comedian recently? I know he posted about some health issues back in 2009, but said he had recovered. Hope he is well. __________________ Laseron Baseball Association Weekend Warriors College Football Weekend Warriors Pro Football

06-01-2006, 02:47 AM	#2 (permalink)
Bonedwarf All Star Starter Join Date: Jan 2004 Posts: 1,337 Thanks: 0 Thanked 1x in 1 post	HELLO! Not see you around (not that I've been around on here much) and was gonna PM you and ask if you'd joined us in the land of OOTP 2006. Very glad you have. I don't give a crap what anyone says, your util for OOTP6 was awesome, and you didn't get nearly enough credit IMO. (Perhaps because you came in near the end of it's run.) Looking forward to what you might have in story for us this time

06-01-2006, 04:09 PM	#3 (permalink)
alasxdair Minors (Rookie Ball) Join Date: May 2002 Location: Phoenix, AZ Posts: 34 Thanks: 0 Thanked 0x in 0 posts	This is great! I've dabbled in Access before, but really wasn't too sure what I was doing. I really enjoyed seeing it all explained to me. I'd definitely like to see more!

06-04-2006, 02:20 PM	#4 (permalink)
Mike Donlin All Star Reserve Join Date: Sep 2004 Location: Life, friends, is boring. Posts: 801 Thanks: 15 Thanked 11x in 7 posts	Thanks so much for this. I'm a noob at this stuff but I want to learn more and this is a VERY helpful start.

06-13-2006, 10:27 PM	#6 (permalink)
gbmoore121 Major Leagues Join Date: Feb 2002 Location: Arizona Posts: 442 Thanks: 22 Thanked 6x in 5 posts	This is great! Thank you very much.

06-13-2006, 11:15 PM	#7 (permalink)
gbmoore121 Major Leagues Join Date: Feb 2002 Location: Arizona Posts: 442 Thanks: 22 Thanked 6x in 5 posts	Comedian, You mentioned you might do more if there was interest. If you do, I would like to see how to use additional reports (ie. career batting). Not sure how to use them together.

06-15-2006, 04:35 PM	#9 (permalink)
gbmoore121 Major Leagues Join Date: Feb 2002 Location: Arizona Posts: 442 Thanks: 22 Thanked 6x in 5 posts	Another great one! Thank you.

06-18-2006, 05:51 PM	#12 (permalink)
Church OOTP Minors (Double A) Join Date: Dec 2001 Posts: 156 Thanks: 0 Thanked 0x in 0 posts	umm ... Hero!

08-08-2010, 07:04 PM	#14 (permalink)
DWK All Star Reserve Join Date: Mar 2007 Location: Bluffton, South Carolina Posts: 571 Thanks: 17 Thanked 12x in 11 posts	I also would like to know if anyone has these __________________ Hardball Chronicles - Milwaukee Braves Major League Historical Baseball - Boston Red Sox Diamond King Baseball - New York Yankees Sabermetric Baseball - Detroit Tigers

11-25-2010, 08:57 PM	#15 (permalink)
yazfan67 Minors (Rookie Ball) Join Date: Jan 2010 Location: Orange City, FL Posts: 35 Thanks: 11 Thanked 1x in 1 post	Not loading The website link is not loading for me, has it changed? I'm really trying to work on getting reports to my Access2007 and nothing seems to work. __________________ We are no longer the Knights Who Say Ni.....

07-25-2011, 09:00 AM	#16 (permalink)
Bluenoser Hall Of Famer Join Date: Mar 2002 Location: Canada Posts: 5,264 Thanks: 20 Thanked 372x in 244 posts	Both links are dead, hopefully someone has these still and will share. __________________ It takes neither courage nor intelligence to cheer for a team only when that team wins. The true test of a fan's mettle is the same as it is for a player: Were you there when you were needed?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode