Prev: How do I setup a date field property that allows only Saturdays?
Next: Items table help
From: kmr on 12 Mar 2010 14:59
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.
From: Steve on 12 Mar 2010 15:55
TblStaff
StaffID
FirstName
MI
LastName
<other staff fields>

TblDrill
DrillID
DrillDescription

TblDrillPerformedByStaff
DrillPerformedByStaffID
StaffID
DrillID
DrillDate
DrillStartTime
DrillEndTime
DrillObserver
PassFail

Steve
santus(a)penn.com

"kmr" <kmr(a)discussions.microsoft.com> wrote in message
news:7D4EDF44-C0A8-4DFB-A187-4E4DDD3BF196(a)microsoft.com...
>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.


From: Fred on 12 Mar 2010 16:32
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.
From: Steve on 12 Mar 2010 21:41
It's a compliment that you plagarized my response !!!!

Steve



"Fred" <Fred(a)discussions.microsoft.com> wrote in message
news:63481D38-6F65-4251-8238-43680A98EB99(a)microsoft.com...
> 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.


From: John... Visio MVP on 12 Mar 2010 23:19
Get a life stevie. When two people have similar trivial answers, that is NOT
plagarism.

John... Visio MVP

"Steve" <notmyemail(a)address.com> wrote in message
news:%23VZhjalwKHA.812(a)TK2MSFTNGP06.phx.gbl...
> It's a compliment that you plagarized my response !!!!
>
> Steve
>
>
>
> "Fred" <Fred(a)discussions.microsoft.com> wrote in message
> news:63481D38-6F65-4251-8238-43680A98EB99(a)microsoft.com...
>> 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.
>
>


 |  Next  |  Last
Pages: 1 2 3 4 5
Prev: How do I setup a date field property that allows only Saturdays?
Next: Items table help