Schedule?
Hey there
I'm currently doing an ICT project for some school work, in which we all have to make access databases. My database is based around a fictional company that provide driving lessons. I've set most of the tables up including clients employees, bookings etc, but i'm wondering if its possible to implement a schedule within access?
I would like to know if its possible for say if someone booked 2 hours of lesson, 2 blocks within the schedule table would be filled, or similar to a calender function, e.g. each day has 6 openings within it, and as these become booked the next day is filled.
i've searched around a bit and can't really find anything but i'm very new to access so any advice would be much appreciated, or just being told that it isnt possible to implement such a schedule or calender would also be useful as then i wont be wasting time looking :P
Hope i've posted this in the right place, sorry if i haven't.
Thanks in advance.
Ben
Just found this website: http://www.aislebyaisle.com/access/calendartool.htm
kinda similar to what i'm looking to do, just wanna know if theres anyway of doing this thats less complex? or free?
View Complete Forum Thread with Replies
Related Forum Messages:
Staff Schedule - 'how To' Help..
Hi all, I'm relatively new to Access and would like a few pointers... I have been asked by work to create a schedule database. We would like to be able to put in dates and see who's working on that day, pull up an individual and see his/hers rota for a week. Also see if they have meetings, annual leave, sickness etc.... We want it to be a very primitive WFM tool. Is this possible and is it relatively easy? The database doesn't have to create the shifts, they will be imported from Excel.... Which leads me to believe I need to think of it differently to excel... Attached is an excel rota, which would need to be importred - but maybe I need to be think a lot differently. I know thats a big question but any help would be appreciated, or pointers to more resources... Thanks Neil
View Replies !
Schedule Next Appointment Automaticly
Good Day everyone, I am looking at setting up appointments and having Access automaticly schedule the next appointment in either 6 months or a year depending on the Vender. I've search the forum and can't find anything. For Example if their last appointment was 12-1-05 I would like access to automaticly schedule the next appoint 12-1-06. Any ideas? Thanks,
View Replies !
Advanced Employee Schedule
Hello Everyone I need to make an employee schedule in access. I am not sure if it is possible, but here are my constraints: 20 employees 5-6 different truck locations (sm1, sm2, sm3, sm4, sm5, sm6) These locations are scattered within our service area. 2 employees must meet at the same truck, (each truck has 2 employees working on it) some employees can only meet at certain locations (ex. paul can meet at either sm2 or sm3) all employees are PT so they can only work on certain days or a certain amount of days per week. (ex. paul can work up to 4 days a week and jim can work only sat and fri) I would like to make a program in access that will take all these factors into consideration. EX. if i try to schedule paul on sm4 the program will not let me do it or it will give a warning or if i try to schedule paul for 5 days it will give me a warning. It would also be great to have a counter that will show how many days each employee has left to be scheduled for, EX: if i scheduled paul for 2 days it will show that he can actually work 2 days more if i need him to. I know this might be a lot, but i also know there are so many talented people here so i am sure it is feasible. Please let me know if you know how to do this or if you could guide me through it. or if you know about a different program that can solve this please let me know Thanks in advance
View Replies !
Schedule A Task In Access
Hi i would like to know if it is possible to schedule a a task in access, at the moment i refresh all my excel report by using a button on a form in access and would like ot know if i can do this automatically
View Replies !
Schedule A Compact & Repair
I have a database that is split. We want to be able to schedule a compact & repair on the back end. Is there a way within access to schedule a compact and repair?
View Replies !
Using Access To Create A Perpetual Schedule
I am trying to create a database to schedule customer visits. I would like to enter a beginning date and a frequency (IE every week or every two weeks) and then be able to print a schedule by entering a date range. Very similar to how MS Outlook calendar performs. Any suggestions appreciated. Thanks Chad
View Replies !
Recall - Create Schedule (sbaxter?)
This could be one for you Mr Baxter. I want to automatically create interview slots. On a form I've got an interview set up and there is a one to many relationship with a table containing interview slots. I want the user to key in the start time of interviews and the end time and the duration of the interview. It should then create the records (time slots) and display them. I assume it will be some kind of append query, but to be honest I just don't know where to start. Please help. A cyber pint goes to the boffin that susses it. Cheers, Recall.
View Replies !
How To Schedule Update Field Every 4 Week (Friday)
How do I schedule to run update COMMISSION field based on calculation every 4 weeks? For example....every friday, i would like to do this calculation : COMMISSION : FIELD (total sales) * 0.05 All customer that logged into the account will be able to see their own commision, AND all administrators will be able to see ALL commission of all customers. Can anybody guide me on how to do this? This scheduling is VERY important to me. I hope somebody can help me. THANKS!
View Replies !
Interesting Launch Schedule Schema Design Puzzle
Hello All, I am working on designing an application in Access that produces reports of how the various Products/Projects in an organization are being planned out in terms of their launch. The products can be in the concept, engineering or complete status and for each status a regular (typically monthly) feed of release/launch data (Beta and GM dates) is provided by the respective teams. The idea is to produce a release schedule for all the products based on these dates and publish them in the monthly (could be different frequency depending on the organization's need) calendar. From month-to-month, these release/launch dates can slip and if there is a slip from the previous version of the launch calendar that was published, then the change needs to be displayed in the calendar report. I have designed most of the schema and feel (hope) I am mostly there. However, the critical piece is how to design a schema that can incorporate incoming release data any time of the month, keep a track of the incoming data for any future ad-hoc reporting purposes, and use the latest release date data and the dates used in the previous calendar to produce the next calendar (showing the latest dates and the slippage if any). I am attaching a picture of an abridged version of my schema I have so far. I have not included some tables that are not directly relevant to this issue. Please let me know how I may incorporate the date and slippage issue and also your thoughts on the design itself. Will be immensely grateful for any guidance. Thank you. (btw, if someone feels it will be useful, I could provide the Access db with the schema itself. It is fairly small without any data). 1. I have put the release/launch date information in the LAUNCH_DETAILS table 2. since the Calendar can actually be published anytime, I have made a separate CALENDAR_VERSION table that related to the Release_Date field. I think it needs to also have a Calendar_Start_Time and Calendar_End_Time that denoted when in the timeline, a particular version of the Calendar was started on and when it go released 3. With all that done, I still need to figure out how to go about extracting the lates release date and checking whether it slipped from what was reported in the last calendar and reflecting that information in the upcoming calendar
View Replies !
|
TRACKER
