I need help setting up my database

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

 

[Steve]

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)

 

[Fred]

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

 

[Steve]

It's a compliment that you plagarized my response !!!!

Steve

 

[John... Visio MVP]

Get a life stevie. When two people have similar trivial answers, that is NOT
plagarism.

John... Visio MVP

 

[Bilky_White]

So you can't spell either, moron?

 

[Fred]

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.

 

[Steve]

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.

 

[Gina Whipp]

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.

 

[Steve]

One word ...... STUPID

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

 

[Steve]

Make that mouth not moth.

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]

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.

 

[Steve]

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

 

[Gina Whipp]

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

 

[Steve]

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?

 

[Gina Whipp]

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?

 

[Steve]

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?

 

[Gina Whipp]

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?

 

[John... Visio MVP]

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

John...

 

[Gina Whipp]

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