how to create report: School Timetable

[ultra5219]

hi everyone


does anyone know how to create timetable report in Access?
i have encounter difficulty to create timetable report. currently im using report wizard options. i select table under "Timetable Table" then select field which i want to display on report.. then select grouping etc then end wizard.
once the i opened the design view, its hard to move the object example i want to adjust the "Period" to upward, but it seems wont moved at all... is it posible to use "REPORT DESIGN"?? to create custom timetable??

Thanks...

PS: i attach my sample design for my timetable. is it i can design my own timetable using "REPORT DESIGN" based on my draft design (refer below) ?

[alcapps]

usually you can go to grouping and sorting

sort by ascending date
next time descending

that should do it..

[ultra5219]

usually you can go to grouping and sorting

sort by ascending date
next time descending

that should do it..

really? but if im using the REPORT DESIGN, i wana design my own without using report Wizard. i want my timetable report design same as my design based on my sample design. is it possible to do that?

[alcapps]

if your data is normalized.. or properly structured. I see no reason not to be able to make the report the way you shown it.

you would go to the designer to make the grouping changes that I suggested.

[ultra5219]

if your data is normalized.. or properly structured. I see no reason not to be able to make the report the way you shown it.

you would go to the designer to make the grouping changes that I suggested.

i see.. well here is my Relationship.. do you think my table are all normalized? my opinion, i try create simple query to find for example : on query: enter group code.. then all information will display from the table which under group code " IT/CES/2001 --- just an example
another example i create query: enter session: example i type: morning..then all information will display morning session on timetable.

is it true, to verified our table or to test relationship of access is correct, simply create query to test what information we want to extract from the table?
sorry my english bit bad.. LOL

Attachment 11125

[alcapps]

Just a quick pointer it is best not to put spaces or special characters in your field names. When you go to code things and make queries you have to put a wrapper around each field name.
also reserved words used by the database i.e. day or time.

between instructor and instructor Id Make them both instuctorid
there are a lot of those like group code could be groupid and unit title should be an unitid to unitid

you might consider day to have 2 fields for a start and end date every Monday between 1/1/2013 and 1/3/2013 or a semester table so you don't have to put the date in every record just the semesterid

[ultra5219]

Just a quick pointer it is best not to put spaces or special characters in your field names. When you go to code things and make queries you have to put a wrapper around each field name.
also reserved words used by the database i.e. day or time.

between instructor and instructor Id Make them both instuctorid
there are a lot of those like group code could be groupid and unit title should be an unitid to unitid

you might consider day to have 2 fields for a start and end date every Monday between 1/1/2013 and 1/3/2013 or a semester table so you don't have to put the date in every record just the semesterid

oh.. okie let me investigate my tables first..

[alcapps]

timetable Testing.zip

I hope this helps you..

go thru the tables and the query and forms..

[ultra5219]

timetable Testing.zip

I hope this helps you..

go thru the tables and the query and forms..

alright... thanks for helping me.. let me try first input first all timetable info using the form..
now im just bit worried when creating timetable report...

[alcapps]

If it a try you can do it

[ultra5219]

If it a try you can do it

ok.. i did input everything already the timetable info.. next is creating timetable report. which one do you prefer, is it using report wizard or using report design?
if im using report design, how to select the field which i want to display information on report form? example i want to display on report form " DAY" Time " etc since report design default report form is empty..

[ultra5219]

ok.. im almost done here.. got another problem again
any ideas how to sort DAY properly from MONDAY TO SATURDAY.
my timetable report wont sort properly it display MONDAY SATURDAY THURSDAY TUESDAY WEDNESDAY..
IT should be sort like this: MONDAY, TUESDAY, WEDNESDAY, THURSDAY, SATURDAY...

any ideas? how to solve?Attachment 11180

[alcapps]

good to hear your making progress.
If your using date convert that to weekday() i.e. weekday() monday = 2, tuesday = 3, wed= 4,thur=5, fri=6, sat = 7,sun =1

sort on the weekday of the date..
use an expression in the sorting or do it in the query that the report calls.

[ultra5219]

yep.. quite busy this few day... doing my database..
i see.. u mean covert weekday by using expression on Query? or by typing "Criteria" on DAY section which i mark on RED color on screenshot?Attachment 11182