I need help setting up my database

  • Thread starter Thread starter kmr
  • Start date Start date
K

kmr

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.
 
TblStaff
StaffID
FirstName
MI
LastName
<other staff fields>

TblDrill
DrillID
DrillDescription

TblDrillPerformedByStaff
DrillPerformedByStaffID
StaffID
DrillID
DrillDate
DrillStartTime
DrillEndTime
DrillObserver
PassFail

Steve
(e-mail address removed)
 
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
 
Get a life stevie. When two people have similar trivial answers, that is NOT
plagarism.

John... Visio MVP
 
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.
 
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.
 
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

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.
 
One word ...... STUPID

Time Zones have at least one hour difference. Put your mind in gear before
running at the moth to butt in.
 
Make that mouth not moth.


Steve said:
One word ...... STUPID

Time Zones have at least one hour difference. Put your mind in gear before
running at the moth to butt in.
Click to expand...
 
Oh my goodness... 1 hour difference would explain the 60 seconds Fred was
referring to but then again that probably went over your head. Moving
along...

--
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

One word ...... STUPID

Time Zones have at least one hour difference. Put your mind in gear before
running at the moth to butt in.
 
Oh my goodness .... You can't follow simple directions. Iy was suggested you
put your mind in gear before running at the mouth critizing. A 1 hour
difference does not explain 60 seconds! Next you are probably going to say
that the change to Daylight Savings explains the 60 seconds (: To repeat,
one word ....... STUPID. Telling time apparently goes over your head. I
guess telling time is not a prerecquiste for becoming an MVP. Moving along
.......

PS Look in the mirror at the color of your hair to see if it is blond
........
 
No, it is you who is not getting it but that does explain a lot!

--
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

Oh my goodness .... You can't follow simple directions. Iy was suggested you
put your mind in gear before running at the mouth critizing. A 1 hour
difference does not explain 60 seconds! Next you are probably going to say
that the change to Daylight Savings explains the 60 seconds (: To repeat,
one word ....... STUPID. Telling time apparently goes over your head. I
guess telling time is not a prerecquiste for becoming an MVP. Moving along
.......

PS Look in the mirror at the color of your hair to see if it is blond
........
 
Oh .... so what are you trying to say? The change to Daylight Savings
explains the 60 seconds? Or, you have blond hair and that gives you a pass
on being able to tell time? Or that you got to be an MVP by just being
stupid?
 
OMG... I can't believe you don't understand that I am not talking about
Daylight Savings time... Nevermind...

--
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

Oh .... so what are you trying to say? The change to Daylight Savings
explains the 60 seconds? Or, you have blond hair and that gives you a pass
on being able to tell time? Or that you got to be an MVP by just being
stupid?
 
OK ..... we'll check off that you weren't talking about Daylight Savings
Time. Now we're down to only two possibilities. Tell us which is the correct
answer. BTW, blondes don't take God's name in vain so was that a hint as to
the correct answer?
 
Ummm, OMG = Oh my goodness in my book. I am not continuing this
conversation... there is no need. Have a nice evening...

--
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

OK ..... we'll check off that you weren't talking about Daylight Savings
Time. Now we're down to only two possibilities. Tell us which is the correct
answer. BTW, blondes don't take God's name in vain so was that a hint as to
the correct answer?
 
Stevie pretends to be religious, but his past behaviour indicates otherwise.
He will con anyone if he thinks he can make a buck.

John...
 
John,

Oh, I know he's not the least bit religious. Posting for money in a free
newsgroup, abusive language... well, you get the idea. But as you reminded
me I need to stop trying to bickering with an unarmed opponent.

--
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

Stevie pretends to be religious, but his past behaviour indicates otherwise.
He will con anyone if he thinks he can make a buck.

John...
 
Checking the Microsoft site directly:


Steve's post: 3/12/2010 1:30 PM PST

My Post 3/12/2010 1:31 PM PST


Checking common sense, there's only on answer to the poster's guestion, and
a very simple obvious one at that, which is the simplest and most common
relationship structure. one-to-many staff and drills (performed) table. I
think that Steve thinks he invented it.

Good thing I didn't mention a look up table for the drill types, or he would
claim that he invented lookup tables that day and that I plagiarized the
concept of lookup tables from him.


Checking reality, it was obvious that I wrote it without having seen his,
doubly obvious from the time stamps directly on the Microsoft site.
 
Back
Top