how to make train time table template

[Guest]

i want to make a train time table for getting arrival and depature
information of a particular train and station information.

 

[Jamie Collins]

i want to make a traintimetable for getting arrival and depature
information of a particular train and station information.

A good starting point is to write some pseudo SQL code about how you
will be querying the data. If you don't know basic SQL, learn (e.g.
http://www.sqlcourse.com/). Once you have a rough idea of the SQL DML
(queries) you will be give you an idea of how your SQL DDL (schema
design) should look. I've got a copy of an article (no link, site
seems to be down) where the business need is to find when the next bus
departs (i.e. based on the current timestamp) and the optimal table
design for querying is non-intuitive from a pure design perspective.

Jamie.

--

 

[Guest]

hi jamie, thanks for your suggestion . can i just put data in access and get
query because i have data but i do not how to query in accesss. i have
offfice 2007 can i do in access please tell me

 

[Jamie Collins]

thanks for your suggestion . can i just put data in access and get
query because i have data but i do not how to query in accesss.

Put the data into Access and learn how to query it? Yes, that's a
valid approach too but be prapared to tweak or redo your design.

Jamie.

--