Access Step by Step

Comedian2004 · 05-31-2006, 09: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, 01: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, 03: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, 01: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, 06: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, 09:27 PM

This is great! Thank you very much.

gbmoore121 · 06-13-2006, 10: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, 03: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, 03:35 PM

Another great one! Thank you.

gbmoore121 · 06-16-2006, 05: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, 06:03 PM

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

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

umm ... Hero!

gbmoore121 · 06-08-2010, 03: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, 06:04 PM

I also would like to know if anyone has these

yazfan67 · 11-25-2010, 07: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, 08:00 AM

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

05-31-2006, 09:36 PM	#1
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	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, 03:06 PM	#8
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	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, 05:23 PM	#10
gbmoore121 All Star Reserve Join Date: Feb 2002 Location: Arizona Posts: 602	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 05:24 PM.

06-16-2006, 06:03 PM	#11
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	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, 03:50 PM	#13
gbmoore121 All Star Reserve Join Date: Feb 2002 Location: Arizona Posts: 602	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. __________________ WWPF- via DDS Pro Football

06-01-2006, 01:47 AM	#2
Bonedwarf All Star Starter Join Date: Jan 2004 Posts: 1,341	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, 03:09 PM	#3
alasxdair Minors (Rookie Ball) Join Date: May 2002 Location: Phoenix, AZ Posts: 34	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, 01:20 PM	#4
Mike Donlin All Star Reserve Join Date: Sep 2004 Location: Life, friends, is boring. Posts: 840	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, 09:27 PM	#6
gbmoore121 All Star Reserve Join Date: Feb 2002 Location: Arizona Posts: 602	This is great! Thank you very much.

06-13-2006, 10:15 PM	#7
gbmoore121 All Star Reserve Join Date: Feb 2002 Location: Arizona Posts: 602	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, 03:35 PM	#9
gbmoore121 All Star Reserve Join Date: Feb 2002 Location: Arizona Posts: 602	Another great one! Thank you.

06-18-2006, 04:51 PM	#12
Church OOTP Minors (Triple A) Join Date: Dec 2001 Posts: 269	umm ... Hero!

08-08-2010, 06:04 PM	#14
DWK All Star Reserve Join Date: Mar 2007 Location: Somewhere in South Carolina Posts: 636	I also would like to know if anyone has these

11-25-2010, 07:57 PM	#15
yazfan67 Minors (Triple A) Join Date: Jan 2010 Location: Orange City, FL Posts: 260	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. __________________ When they start the game, they don't yell, "Work ball." They say, "Play ball." ~Willie Stargell, 1981

07-25-2011, 08:00 AM	#16
Bluenoser Hall Of Famer Join Date: Mar 2002 Location: In The Moment Posts: 13,680	Both links are dead, hopefully someone has these still and will share.