A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

I need help setting up my database



 
 
Thread Tools Display Modes
  #1  
Old March 12th, 2010, 08:59 PM posted to microsoft.public.access.tablesdbdesign
kmr
external usenet poster
 
Posts: 13
Default 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  
Old March 12th, 2010, 10:32 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default 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  
Old March 13th, 2010, 03:41 AM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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  
Old March 13th, 2010, 05:19 AM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default 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  
Old March 14th, 2010, 03:22 PM posted to microsoft.public.access.tablesdbdesign
Bilky_White
external usenet poster
 
Posts: 5
Default 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  
Old March 15th, 2010, 06:21 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default 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  
Old March 15th, 2010, 06:57 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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  
Old March 15th, 2010, 08:00 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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  
Old March 15th, 2010, 08:25 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:43 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.