People in Office

[Guest]

Im tryin to create a database where if i download the sheet with the data of
people absent from my office. Inputed that data into a table somehow. The how
could i make it show me the people in the office instead of out. So subtracts
the names from a total list of all the people in the office.

Then also create a skills section which gives each person in the office a
tick or X in a table with their skills in it. So then people could look at
this go, oh on monday 31st .. MR joe Bloggs is in and he is skilled in
........ and look what skills he has an X in...

Does this make any sense ? if so how would i go about doing it ?

 

[Jeff Boyce]

It sounds like you are trying to build an application. These newsgroups are
great for answering specific questions, but your description sounds more
general.

What have you already tried? Have you searched at Microsoft.com for
templates? ?Searched on-line for similar applications?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[John W. Vinson]

Im tryin to create a database where if i download the sheet with the data of
people absent from my office. Inputed that data into a table somehow. The how
could i make it show me the people in the office instead of out. So subtracts
the names from a total list of all the people in the office.

Then also create a skills section which gives each person in the office a
tick or X in a table with their skills in it. So then people could look at
this go, oh on monday 31st .. MR joe Bloggs is in and he is skilled in
....... and look what skills he has an X in...

Does this make any sense ? if so how would i go about doing it ?

Check out some of the tutorials:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


What you're describing is very normal many to many relationships and queries.
If you have a SPECIFIC problem (rather than a generic task description with
"how do I go about doing it") we'll be glad to help you over the rough places.

John W. Vinson [MVP]