Can Access produce this kind of design???

[Guest]

Dear all....
i am working on MS Access making a database storing informations in
it....at the same time i hope it can fits in everything which i need....so
using one program is enough to work out with......

Can Access produce such information like having a page??...
which somesort of shows out like Excel spreadsheet......so every morning
we can show in the meeting ...having columns of person names on it....and
also having colours on the columns which represents different
information.....??
If yes...can u tell me roughly on how can i do it? Forms or Queries? i
hope it doesnt require code...im bad in it.....
Thanks everyone....

 

[Alex White MCDBA MCSE]

Very possible in Access, it would require either coding or third party
control, sounds like the outlook calendar type of view you are looking for?

First things to think about is how many entries in a day, how many people?
what do you want it to look like?

Have you already got this working as an excel spreadsheet?, because if you
have then populating a spreadsheet from Access is not such a complex task.

 

[Guest]

can i know what is mean by "third party control"? im not sure of how to
explain the layout.....but its something like Excel spreadsheet with columns
of names and with colour to indicate what they stands for.....

and im trying to built a database in Access...and at the same time i wish
that it can include this kind of layout too....so just in one program...all
our information is inside.....

Yes...at the moment we are use Excel spreadsheet...and every morning in the
meeting...we would look at those names in it...and with different colours on
some cells.....so would like to find out if Access can do this too? because
Access to me is like storing information and viewing them in Reports
format.....so i have no idea if it can acts in other format too....

Please do advice and help me out....im kinda urgent...so i can start working
out....
Thanks..

 

[Alex White MCDBA MCSE]

Well, because you have already mapped your solution in excel, you have an
understanding of what you are looking for, sometimes re-inventing the wheel
is not a good idea, in other words, maybe getting access to produce the
spreadsheet is what is required. So think about your spreadsheet layout e.g.

persons names across the top? or days across the top?

persons name down the side?

is there the posibility of more than one activity per person / per day?

if the last question is true then, you need a master detail table layout
within access, e.g.

Employee table

Emp_ID autonumber
Emp_Name string

... more fields

Schedule table
Schedule_ID autonumber
Emp_ID numeric
Scheduled_Date date (date and time of schedule entry)
Description string
Schedule_Type_ID numeric (what type of schedule entry... used for
colouring the cells)
Notes memo



Schedule_Type table
Schedule_Type_ID autonumber
Description string
Colour string


this should give you some idea of where to go next!!!

Do you need to produce hard copy (print it out) or do you just need it to
look nice on the screen?