Well, here it goes. I?m fairly new to the world of databases and work has just dumped a Microsoft Access project in my lap. I guess it would be easiest to explain exactly what they want and then what I have so far. . With our company, when you have a job that has an issue we create work request forms. These forms are handed from department to department and make a huge mess and are easily lost in the mix of things. My task as it would be is to create a database that takes all new requests and makes them available to all employees. These are the items needed for this database.
A form in which new work requests can be entered and retrieved from queries. (I would love to be able to hyperlink the job number in each of the queries so on clicking would pull that record on the form) Not having much luck with the coding for that so far.
A productivity report showing the amount of hours each employee has worked on each of the jobs submitted. (When the action to be taken is selected in the combo box I was hoping it could auto load the job hours in a text box that are related to that action, not sure if that is possible either)
3 queries that represent the work requests for our 3 departments, and one query for the management to view all work requests(They want me to sort by date and urgency however I have only been able to sort by date) oldest to newest.
A Log-in Page where managers and users will have separate passwords to give certain privileges. (Managers can view Requests from all departments and view all productivity reports, users can only view requests to their department and their own productivity report; we only have 3 departments for separate requests)
What I have so far:
A form that can retrieve and search the 3 department queries. (Having trouble creating a control that allows me to save newly input records as new rows in the querie, need ability to save over records, and save as new)
The 3 queries for our departments sorting the jobs by date oldest to newest.
A Log-in Form-not functional (Not sure if I should use this or just use MS security functions.
And Finally the Tables that hold the employee info and all the Work requests.
I know this is a lot of info and somewhat vague. But if you can answer even just one of my questions or throw me some ideas it would be greatly appreciated. I?m still getting used to SQL so I?m working my way up to the more advanced coding (FYI)
Thanks again 😀
-Noob
