Results 1 to 2 of 2
  1. #1
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051

    Setting up a timetable

    Not quite sure how to go about setting up tables for a database which will involve staff and pupil timetables.



    I have an excel file with teachers names in column A. With their lessons from monday1 through to friday5 as the headings of columns B to X

    The cells contain teachers classes. This file has been exported from a database which the school uses called Sims.

    Can I import that worksheet into one table in access or should I try and extract info into more than one table.


    Can anyone advise?
    Click image for larger version. 

Name:	timetable.PNG 
Views:	15 
Size:	53.6 KB 
ID:	37976
    Last edited by andy49; 03-31-2019 at 12:43 PM.

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    SIMS. I know it well after working in UK schools for almost 40 years.
    You will need several tables for the teachers, students, timetable, classes, rooms and possibly others for the support staff. You will also need Junction tables.
    Displaying the timetables will require arrays to convert the normalised data into the familiar timetable grid.

    You could also look at my School Data Analyser application. See http://www.mendipdatasystems.co.uk/s...ser/4584605482
    Its a commercial app but there is a fully working DEMO version. The DEMO is an ACCDE file so code not available
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help setting up tables
    By JamesFredericks in forum Database Design
    Replies: 12
    Last Post: 10-10-2016, 06:42 PM
  2. Creating A Timetable
    By liamfrancis2013 in forum Access
    Replies: 2
    Last Post: 06-10-2015, 06:06 AM
  3. weekly timetable report format
    By merlin777 in forum Reports
    Replies: 14
    Last Post: 10-27-2014, 11:06 AM
  4. how to create report: School Timetable
    By ultra5219 in forum Reports
    Replies: 13
    Last Post: 02-14-2013, 07:51 AM
  5. setting up
    By jimmy321go in forum Access
    Replies: 2
    Last Post: 05-02-2012, 12:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums