PDA

View Full Version : Help from Microsoft Office Guru's...


TRR
04-17-2005, 09:29 PM
Please don't delete/move until I get a couple of answers....

I have a Microsoft Access project due in the next couple of weeks, and was wondering if anyone could give me a hand with it. Basically it is just creating a database, and providing minimal security with it.

If anyone could give me a hand, or had a simplistic database that I could use as an example to work off of, it would be much appreciated. My instructor is a complete *ss, and I am running out of options. I am struggling through it, but a little help would really speed up the process.

Enormous rep to anyone that could lend a helping hand....

htismaqe
04-17-2005, 09:36 PM
Just an FYI, but you WOULD get answers even if this was moved.

The idea that the tech forum has no traffic is absolutely false.

TRR
04-17-2005, 09:39 PM
Just an FYI, but you WOULD get answers even if this was moved.

The idea that the tech forum has no traffic is absolutely false.

Thanks....I'll take any help I can get from anywhere. I am stressed to the max over this project.

...way in over my head.

KCWolfman
04-17-2005, 09:39 PM
What kind of database?

I use several. I have a production database I keep on my data entry staff, a music database I keep on my own material, a stock database of my wife's shipping materials... etc

The wizards in access will walk you through any process (except detail in the reports). I won't give you my databases, but I would be happy to answer any questions or assist you.

TRR
04-17-2005, 10:10 PM
What kind of database?

I use several. I have a production database I keep on my data entry staff, a music database I keep on my own material, a stock database of my wife's shipping materials... etc

The wizards in access will walk you through any process (except detail in the reports). I won't give you my databases, but I would be happy to answer any questions or assist you.

I'm not looking for a database from anyone to turn in. That could come back to haunt me. What I am looking for is a database (like your music one) to work off of. I don't have any type of physical example to work from. I'm going to do a stat tracker database (the choice is up to us), however I just can't find anyone to share an Access project with me to use as an example. Would you be willing to share your music one? If not, I understand. Bottom line is that we have to present our project, so there is no way I could use yours.

KCWolfman
04-18-2005, 12:46 AM
I'm not looking for a database from anyone to turn in. That could come back to haunt me. What I am looking for is a database (like your music one) to work off of. I don't have any type of physical example to work from. I'm going to do a stat tracker database (the choice is up to us), however I just can't find anyone to share an Access project with me to use as an example. Would you be willing to share your music one? If not, I understand. Bottom line is that we have to present our project, so there is no way I could use yours.
Nope, I can't give you the database itself. Sorry.

Let's start with basics.
What stats do you want to track?
How many stats?
What or who are the owners of the stats? In other words, what relative comparison do you want to use in every report (Baseball stats by player, driving stats by age group, etc).
Do you want any relative comparisons on the stats?
Are you having trouble building tables?
Are you having trouble building queries?
Are you having trouble building forms?
Are you having trouble building reports?

ChiefsCountry
04-18-2005, 12:48 AM
I have databases for our boat dealerships on Access but like KCWolfman said I can't really give it to. Personally you just basically play around with it that is what I did and I got it pretty easy.

TRR
04-18-2005, 12:56 AM
Nope, I can't give you the database itself. Sorry.

Let's start with basics.
What stats do you want to track?
How many stats?
What or who are the owners of the stats? In other words, what relative comparison do you want to use in every report (Baseball stats by player, driving stats by age group, etc).
Do you want any relative comparisons on the stats?
Are you having trouble building tables?
Are you having trouble building queries?
Are you having trouble building forms?
Are you having trouble building reports?

Like I said, I need an example to go from. I am Access illiterate. I was going to track basketball stats of the Iowa Hawkeyes. Keeping it pretty generic. I was going to track PPG, RPG, and APG. Other than that, I am not really sure what correlates with what in regards to tables, queries, forms and reports. As I said, I am clueless.

KCWolfman
04-18-2005, 01:13 AM
Like I said, I need an example to go from. I am Access illiterate. I was going to track basketball stats of the Iowa Hawkeyes. Keeping it pretty generic. I was going to track PPG, RPG, and APG. Other than that, I am not really sure what correlates with what in regards to tables, queries, forms and reports. As I said, I am clueless.
That is a breeze.

Again use your wizards for each of the four below

1. Build tables
2. Build queries
3. Build forms
4. Build reports

Go to tables and select "Create table by using wizard"
Select Employees
Select Last Name
Select First Name
Click Next
Change the title to Players
Skip relationships for now
Select enter data directly in table
Go to the fields and enter the first and last name of all the players
Close, save as players
Now create a table using design view
for the first field name enter "Last Name"
for the data type, use Lookup Wizard
Leave it at "I want the lookup column"
Click next
Select your table
Click next
Select last name
Click next
click next again (sort is not required right now)
Click finish
You will get a message saying the table relationships must be saved. Click yes
Save the table name as Iowa BBall Stats
Do not define a primary key
for the next field enter "First Name"
Repeat the bolded section above selecting first name instead of last name
Enter each individual stat as a field name
Select data type as Number for each stat
Change the format to general number
Change your decimal places to 2
go to the next stat


Your tables are done


Now click on queries
Much quicker here
Select Create Query by using Wizard
Find your table named Iowa BBall Stats
Click on the double arrows to send all fields over ">>"
Click on next
Click on finish
Click on the lower X in the upper right hand corner to close the query only


Your query is done

Now click on forms
Click on Create Form by Using Wizard
Find your query (DO NOT USE THE TABLE!!!)
Use the double arrows to shove all fields over
Click on next
select columnar
click on finish
Select your player from the drop down arrow
Enter all his stats in the corresponding boxes
Click on the lower x in the upper right hand corner to close the forms only.

Your forms are done


Click on Reports
Click on Create Report Using Wizard.
Follow the prompts and your report will be complete.

Open the report when complete and print


Good luck

KCWolfman
04-18-2005, 01:34 AM
BTW - This is now getting moved to the tech forum

|Zach|
04-18-2005, 01:39 AM
KCWolfman made that whole post to throw you off. He knows nothing of what he speaks.

If you want to know about something like bows and arrows then drop him a note. He will give you all the info you will ever need.

KCWolfman
04-18-2005, 01:42 AM
KCWolfman made that whole post to throw you off. He knows nothing of what he speaks.

If you want to know about something like bows and arrows then drop him a note. He will give you all the info you will ever need.
Curses foiled again!!!!


http://flyingmoose.org/moose/dd5.jpg

TRR
04-18-2005, 11:27 AM
KCWolfman...

So when you say, "enter each individual stat as a field name." Where do I enter that at? In Table one? Or under the Players table? Or do I create another table to put my stats in?

Simplex3
04-18-2005, 11:46 AM
1. Are you trying to track the team's stats or the player's stats?
2. Do you need to be able to keep the stats by game?
3. Do you need to keep info on the games themselves?
4. Are there any requirements for this project? Minimum number of tables, tables must be relational, etc?

TRR
04-18-2005, 11:47 AM
Are you trying to track the team's stats or the player's stats?

Individual players stats as in....

Jeff Horner PPG APG RPG.....

Simplex3
04-18-2005, 11:50 AM
Individual players stats as in....

Jeff Horner PPG APG RPG.....
Yeah. Do you need to know how many hits they EACH got or how many hits the TEAM got?

TRR
04-18-2005, 11:53 AM
I am wanting to keep track of stats during the Big Ten season for each player.

There will be no hits or runs as I am keeping track of Iowa basketball stats...Or trying to at least.

KCWolfman
04-18-2005, 05:42 PM
KCWolfman...

So when you say, "enter each individual stat as a field name." Where do I enter that at? In Table one? Or under the Players table? Or do I create another table to put my stats in?
You are creating a second table

See "create a table using design view"

TRR
04-18-2005, 05:44 PM
You are creating a second table

See "create a table using design view"

When I go back into that second table, all it will allow me to do is put in the first and last players names from the Player table.

KCWolfman
04-18-2005, 09:42 PM
When I go back into that second table, all it will allow me to do is put in the first and last players names from the Player table.
Follow along with the pics. Note that your version may be different than mine (Office 2003), but the similarities are so close you should be able to make them out.

In this pic I have already created the players and want to start a new table. Follow the red arrow and double click.

KCWolfman
04-18-2005, 09:46 PM
The pic below is what will open up.

Follow my instructions below and type in "Last Name". Then select "Lookup Wizard" where the arrow is pointing.

KCWolfman
04-18-2005, 09:49 PM
Follow the Wizard and select last name only. Do not select first name or ID.

KCWolfman
04-18-2005, 09:57 PM
Don't worry about sort order when the wizard asks. Just click on Next


Then make sure the width is big enough to read the entire name by dragging the right side. Click on Finish.

You will get the following Message "The table must be saved before relationships can be created. Save now?" Click on Yes and then give the file a name like Iowa BBall Stats. You will be asked for a primary key - for now just say no.

Repeat the entire process of pics below for First Name, selecting first name only and ignoring last name and ID.

Then put in the stats you want as shown below.

Make sure you select "Number" for all stats and make sure your numbers use the General Information listed below in the pic.

KCWolfman
04-18-2005, 09:58 PM
Now follow the instructions I gave below from this point

Your tables are done


Now click on queries
Much quicker here
Select Create Query by using Wizard
Find your table named Iowa BBall Stats
Click on the double arrows to send all fields over ">>"
Click on next
Click on finish
Click on the lower X in the upper right hand corner to close the query only


Your query is done

Now click on forms
Click on Create Form by Using Wizard
Find your query (DO NOT USE THE TABLE!!!)
Use the double arrows to shove all fields over
Click on next
select columnar
click on finish
Select your player from the drop down arrow
Enter all his stats in the corresponding boxes
Click on the lower x in the upper right hand corner to close the forms only.

Your forms are done


Click on Reports
Click on Create Report Using Wizard.
Follow the prompts and your report will be complete.

Open the report when complete and print

TRR
04-19-2005, 04:48 PM
Don't worry about sort order when the wizard asks. Just click on Next


Then make sure the width is big enough to read the entire name by dragging the right side. Click on Finish.

You will get the following Message "The table must be saved before relationships can be created. Save now?" Click on Yes and then give the file a name like Iowa BBall Stats. You will be asked for a primary key - for now just say no.

Repeat the entire process of pics below for First Name, selecting first name only and ignoring last name and ID.

Then put in the stats you want as shown below.

Make sure you select "Number" for all stats and make sure your numbers use the General Information listed below in the pic.

After creating a first player table and a last player table like you said to do with the wizard, I save it, and when I go back in to enter my stats, all it will allow me to do is enter the players first name/last name. It doesn't allow me to enter the stats. How do I do that?

KCWolfman
04-20-2005, 09:22 PM
After creating a first player table and a last player table like you said to do with the wizard, I save it, and when I go back in to enter my stats, all it will allow me to do is enter the players first name/last name. It doesn't allow me to enter the stats. How do I do that?
That's because you have yet to create the query and the form.

Continue follow my instructions below. Create the query, create the form, then you can open forms and enter the data directly.

Boozer
04-21-2005, 07:56 AM
Good god, TRR, you better be sending KCW a sixer of his choice.

TRR
04-21-2005, 05:31 PM
That's because you have yet to create the query and the form.

Continue follow my instructions below. Create the query, create the form, then you can open forms and enter the data directly.

Thanks KCWolfman!

TRR
04-22-2005, 10:38 PM
Ok, I have created the queries and reports, however there is no drop down arrow to select each player. There are 5 or so fields like last name, first name, ppg, rpg, etc. But it won't let me enter a name into the First/Last name category. Only a number. How do I correct this???

KCWolfman
04-23-2005, 12:44 AM
Ok, I have created the queries and reports, however there is no drop down arrow to select each player. There are 5 or so fields like last name, first name, ppg, rpg, etc. But it won't let me enter a name into the First/Last name category. Only a number. How do I correct this???
You have saved the original table incorrectly.


1. Close all open tables, queries, forms, and reports. Leave Access open

2. Click on the relationships icon at the top center of the program

3. Right click on all lines between boxes and select Delete

4. Close the relationships table, but leave Access open

5. Click on Tables on the left

6. Single click on Iowa BBall Stats

7. Select the Design View icon at the top left.

8. Click on the Data Type of "Last Name"

9. Select Lookup Wizard

10. Leave the selection at "I want to lookup...."

11. Click Next

12. Click Next again

13. Select "Last Name"

14. Click Next

15. Click Next

16. Click Finish

17. Click Yes to "the table must be saved now...."

18. Repeat steps 8 - 17 using first name instead of last name.

That should fix it.