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!

05-31-2006, 09:36 PM	#1 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,380	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. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

06-15-2006, 03:06 PM	#8 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,380	Ok, feedback looks good, so here is lesson two: http://www.sim2005.com/access2/ Please let me know what you think. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

06-16-2006, 05:23 PM	#10 (permalink)
gbmoore121 Major Leagues Join Date: Feb 2002 Location: Arizona Posts: 384	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 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,380	Yes, you can, I will do that in the next lesson. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

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

06-01-2006, 01:47 AM	#2 (permalink)
Bonedwarf All Star Starter Join Date: Jan 2004 Posts: 1,336	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 (permalink)
alasxdair Minors (Rookie Ball) Join Date: May 2002 Posts: 32	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 (permalink)
Mike Donlin All Star Reserve Join Date: Sep 2004 Location: Feeling the Illinoise! Posts: 698	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 (permalink)
gbmoore121 Major Leagues Join Date: Feb 2002 Location: Arizona Posts: 384	This is great! Thank you very much.

06-13-2006, 10:15 PM	#7 (permalink)
gbmoore121 Major Leagues Join Date: Feb 2002 Location: Arizona Posts: 384	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 (permalink)
gbmoore121 Major Leagues Join Date: Feb 2002 Location: Arizona Posts: 384	Another great one! Thank you.

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