Help with microsoft access for making schedules

[Kenjamin.Lafayette]

Here is the scenario. I have a list of people, what building they work
in, and on what days.

Is there a way in access to pull up this database and have it make a
list based only on the days, like select monday and everyone who works
on monday will be listed along with the building they work at on a
sheet to print out?

im a newbie to access but know a veteran amount about other office
products. any help at all would be greatly appreciated.

thanks in advance,

Ken Lafayette, Jr
Assistant Liaison
KAS Transportation

[BillCo]

It's hard to know how to advise you as you do not give much information
on the database you are working on. did you build it yourself? How
comfortable are you going into the database and looking at tables and
queries?

I'm guessing that all this information is all in the one table? Let's
call it "tblSchedule"

There are a number of ways of producing this information. Probably the
best way for you to do this would be to use a parametarised query:

SELECT
tblSchedule.Name,
tblSchedule.Building
FROM
tblSchedule
WHERE
tblSchedule.WeekDay = [Please enter a day];

Create a query from scratch (without the wizard) and go into the "SQL
view". Copy the above text in and adjust it so that the table name and
field names match whats in your database. When you open this query you
will be prompted for a day. Enter it, and all the matching records will
be displayed.

However, if the employee and building records are other tables, as they
should be in a well designed table schema, your query may look more
like this:

SELECT
tblEmployee.EmployeeName,
tblBuilding.BuildingName
FROM
(tblSchedule
INNER JOIN tblEmployee
on tblSchedule.EmployeeID = tblEmployee.EmployeeID)
INNER JOIN tblBuilding
on tblSchedule.BuildingID = tblBuilding.BuildingID
WHERE
tblSchedule.WeekDay = [Please enter a day];

So you see, it's quite hard to tell without knowing more about your
data structure. Can you tell us more?

[Kenjamin.Lafayette]

i havent even created a database yet, so i can create it however is the
easiest way.

what data i have is just in a paper sheet now.

the data i have is:

a column of names, a column of buildings, and what days each person
works.

im not familiar with access that much, but i know a few things that are
very rookie.

[BillCo]

I recommend you do some reading on database normalisation and
referential integrity before you start. Your table design and
relationships are your foundations and will shape how the entire
database operates (or doesnt!)

You are in a rare position to create an ap from scratch and if you do
your research now you will save yourself a LOT of heartache in the long
run. If you understand those two topics then you are in a great
position to create a database which will will not only be more
efficient and easier to use, but you will be able to expand it far
easier to grow to your needs