If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I need help setting up my database
I used Access in the past, so I have a general idea on how to use it, but now
I have Microsoft 2007, so it's not as familiar. I currently have an excel document with staff names and drills they have performed. The drills include dates, times, an observer, and if they passed or failed. I had considered doing something where I had a table with all my staff, and then connecting tables for each person to list out the specifics for their drills. I don't know how to link the relationship with that though because the table name was the staff's name, so there wasn't a similar piece of data to link the two tables. I need to be able to see how each individiual person is doing. I also want to be able to see who has or hasn't been drilled in a specific month. |
#3
|
|||
|
|||
I need help setting up my database
Hello Kmr,
You'd benefit from some general wording, others are better than I at citing sources for this. But here's a framework . A table of staff, with "one-to-one" type info on each staff member. Add an autonumber primary key field named "StaffID" A table of drills, with all of the "one to one" data for drills, and then add an integer field "StaffID". Then link "StaffID" to "StaffID" There are tricks to use so that you don't have to reenter data. I think there's a wizard for this. Sincerely, Fred "kmr" wrote: I used Access in the past, so I have a general idea on how to use it, but now I have Microsoft 2007, so it's not as familiar. I currently have an excel document with staff names and drills they have performed. The drills include dates, times, an observer, and if they passed or failed. I had considered doing something where I had a table with all my staff, and then connecting tables for each person to list out the specifics for their drills. I don't know how to link the relationship with that though because the table name was the staff's name, so there wasn't a similar piece of data to link the two tables. I need to be able to see how each individiual person is doing. I also want to be able to see who has or hasn't been drilled in a specific month. |
#4
|
|||
|
|||
I need help setting up my database
It's a compliment that you plagarized my response !!!!
Steve "Fred" wrote in message ... Hello Kmr, You'd benefit from some general wording, others are better than I at citing sources for this. But here's a framework . A table of staff, with "one-to-one" type info on each staff member. Add an autonumber primary key field named "StaffID" A table of drills, with all of the "one to one" data for drills, and then add an integer field "StaffID". Then link "StaffID" to "StaffID" There are tricks to use so that you don't have to reenter data. I think there's a wizard for this. Sincerely, Fred "kmr" wrote: I used Access in the past, so I have a general idea on how to use it, but now I have Microsoft 2007, so it's not as familiar. I currently have an excel document with staff names and drills they have performed. The drills include dates, times, an observer, and if they passed or failed. I had considered doing something where I had a table with all my staff, and then connecting tables for each person to list out the specifics for their drills. I don't know how to link the relationship with that though because the table name was the staff's name, so there wasn't a similar piece of data to link the two tables. I need to be able to see how each individiual person is doing. I also want to be able to see who has or hasn't been drilled in a specific month. |
#5
|
|||
|
|||
I need help setting up my database
Get a life stevie. When two people have similar trivial answers, that is NOT
plagarism. John... Visio MVP "Steve" wrote in message ... It's a compliment that you plagarized my response !!!! Steve "Fred" wrote in message ... Hello Kmr, You'd benefit from some general wording, others are better than I at citing sources for this. But here's a framework . A table of staff, with "one-to-one" type info on each staff member. Add an autonumber primary key field named "StaffID" A table of drills, with all of the "one to one" data for drills, and then add an integer field "StaffID". Then link "StaffID" to "StaffID" There are tricks to use so that you don't have to reenter data. I think there's a wizard for this. Sincerely, Fred "kmr" wrote: I used Access in the past, so I have a general idea on how to use it, but now I have Microsoft 2007, so it's not as familiar. I currently have an excel document with staff names and drills they have performed. The drills include dates, times, an observer, and if they passed or failed. I had considered doing something where I had a table with all my staff, and then connecting tables for each person to list out the specifics for their drills. I don't know how to link the relationship with that though because the table name was the staff's name, so there wasn't a similar piece of data to link the two tables. I need to be able to see how each individiual person is doing. I also want to be able to see who has or hasn't been drilled in a specific month. |
#6
|
|||
|
|||
I need help setting up my database
So you can't spell either, moron?
On 13/03/2010 02:41, Steve wrote: It's a compliment that you plagarized my response !!!! Steve |
#7
|
|||
|
|||
I need help setting up my database
Yeah, I read yours, and wrote my response in a totally different way and then
posted it, all in 60 seconds. If you are going to make baseless swipes (e.g. "plagarized") you should at least look at the time stamps so that you don't look too stupid. |
#8
|
|||
|
|||
I need help setting up my database
I posted at 4:55PM and you posted at 5:32PM. That's more than 60 seconds
later. You should at least learn some math so that you don't look too stupid. "Fred" wrote in message ... Yeah, I read yours, and wrote my response in a totally different way and then posted it, all in 60 seconds. If you are going to make baseless swipes (e.g. "plagarized") you should at least look at the time stamps so that you don't look too stupid. |
#9
|
|||
|
|||
I need help setting up my database
Two words... TIME ZONES
-- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" wrote in message ... I posted at 4:55PM and you posted at 5:32PM. That's more than 60 seconds later. You should at least learn some math so that you don't look too stupid. "Fred" wrote in message ... Yeah, I read yours, and wrote my response in a totally different way and then posted it, all in 60 seconds. If you are going to make baseless swipes (e.g. "plagarized") you should at least look at the time stamps so that you don't look too stupid. |
#10
|
|||
|
|||
I need help setting up my database
One word ...... STUPID
Time Zones have at least one hour difference. Put your mind in gear before running at the moth to butt in. "Gina Whipp" wrote in message news Two words... TIME ZONES -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" wrote in message ... I posted at 4:55PM and you posted at 5:32PM. That's more than 60 seconds later. You should at least learn some math so that you don't look too stupid. "Fred" wrote in message ... Yeah, I read yours, and wrote my response in a totally different way and then posted it, all in 60 seconds. If you are going to make baseless swipes (e.g. "plagarized") you should at least look at the time stamps so that you don't look too stupid. |
Thread Tools | |
Display Modes | |
|
|