Employee Database/Managers and departments

I am using Access 2010. I have created an employee database.
Here are my tables;

I want to make some employees managers and assign multiple departments to them through a form. Within this form I'll need to be able to see ALL assigned departments and also be able to add or delete departments as they are moving targets.

I created a junction table called tblManagers and I added a field in the employee table that is YES or NO for manager's.

What is the best way to manage the manager's table

Sponsored Links:

Related Topics

Employee Table and retrieving data
I have created an employee database for many different groups (departments) to use and I'd like to create a button that restricts or filters the data from the employee table for particular departments. Exampe: I have a form with all of the different groups labeled with cmd buttons and upon clicking the cmd botton I want only the Chassis data to be sent to the Main form instead of the main form showing all of the employees.

send email to email addresses in database?
I have a table that keeps track of different managers for different departments. Each department has their own row of the table where we keep track of first/last names and email addresses of all the managers of each department (each departement has multiple managers). So, each row will have multiple email addresses.

How can I make a button that will automatically insert all the email addresses into the "To" field of a new Outlook message

Automatically updating matrix
I have a question about something I've been asked to do for my company.

We have 10 managers that on a regular basis are asked to sit in on 5 work sessions with employees. Managers are randomly assigned to give employees feedback based on this observation, with employees getting a max of 5 sets of feedback.

I am wondering if there is a way to automate this process with access. For instance, can I input all of the employees into one table, all managers into another, set a variety of limitations or rules (e.g. no manager gives the same employee feedback more than once) and have access automatically populate a matrix with employees and managers paired up across these sessions

Splitting DB into front/back end
I'm making a time management database/system that tracks employee clocking and allows managers to edit/ view the roster.

Initially the database will be accessed from 3 computers: 2 used by the managers and 1 used by employees to clock in/out (kiosk type PC).

I've never worked with a access database that is used from multiple locations, or ever split an access database into front/backend file. The reasons I'm looking into it is to improve stability, speed and secure against accidental editing from inexperienced users. I'm less concerned with malicious 'hacking'.

-MDE file: compiled only version of the code. is this file type for security purposes only, or does it lessen the chances of file corruption/ improve speed
-MDW file: what is this and is it necessary? the 3 computers are always logged on, users will eventually login directly with the system, rather than be identified by the windows user.
-The frontends will be different for managers and employees. should these contain forms only, or should they include queries that are specific to the frontend
-lastly, the database has 13 related tables (and this may increase by the time its completed). is it ok to have this in one file or best to have multiple backend files? say one for employees and one for roster.

Creating Custom Forms
In this lesson, you will learn how to use Access forms for data input and editing. Forms let you go one giant step beyond regular data entry. In short, forms provide custom interfaces that let you work with data in the most natural way.
For example, if you are working with an employee database, you can create a form that matches an employee record. Depending on your company, you may have several different departments that use employee records. Using Access forms, you can create a custom interface for each department. Each department's form, in turn, will present only those fields that employees in that department need to use.

Employee Database
Am brand spanking new to access. Need to create an employee database. Figure I need several tables, like one for name & address, one for level of employee certification, one for the different certifications held (about 4 different ones per employee) and their reapective expiration dates, etc. Is this correct

Compare and return, should be simple.. but
Simple employee training dbase.
Trainings are organised in training sessions, since a session can contain more than one training (i.e. First Aid, CPR, and Fire extinguisher)
Employees belong to departments.
Certain trainings are required working in a department, that dictates requiered trainings for an employee.
Now I have two queries:
'Query emp trng req' returning employee id and their requiered training id
'Query emp trng done' returning employee id and their completed training id.
Obviously I like to know which of the 'req training id's' are missing in the 'done training id's' per employee id
There can be training id's in the done query, that are not requiered for that employee.
I have the dBase attached, had to strip a lot from it down to <500k

Help with making a call list
I'm hoping for some help making a call list in Access:

We have 4 managers and 16 foreman. Each month a manager is tasked with calling 4 foreman for progress reports.

I'd like to create a simple program with Access to have the foreman assigned to the managers differently each month. It would have to remember the past 4 months so the same names aren't assigned to the same managers.

It also has to randomly assign the foremen so the managers don't have the same foreman after 4 months (if that makes sense).

date filtering in Query
I created a database which collects call-in records (time and date stamp) for buildings my company cleans. Then I run a report at day’s end of exceptions for buildings that have not called in.

This report is then sent to my managers so they can contact the employee(s) or subcontractor to find out if the building is or has been cleaned. So, my problem is that not every building is to be cleaned every day.

Because of this fact, my exceptions report includes buildings that should not have a call-in for that day. This causes my managers to use more of their valuable time researching buildings that should not be on the report.

How can I get these buildings excluded from my report? I created schedule table, but not sure it is setup correctly. Also, had my exceptions query convert the date and time to weekday (d) in a separate column to compare to this schedule.

Permissions for sharing a database
I have a split database which I would like to share between two departments. I want one of the departments to have full access permissions to the database and create a form for the other department to view and select a check box.

I don't want the department with the view and select check box permissions to make any other changes to the database and the ability for them toonly view the other reports.

Need outer join instead of inner join
I want to list the employees from employee eventhough not existing in holiday

FROM employee,

employeeid = employee.recordid )

Relationships/Data Organization
with organizing data. The database should contain annual Health & Safety tests results for each employee. Although, I'm not very familiar with MS Access, I thought that building a huge table holding all info wouldn't be the best way to go. Building separate tables for each year doesn't seem like a particularly good idea either, considering that Employee names and info would be the same in all of them. Now, is it possible to have one table with Employees names, departments etc. (e.g. Employees) and several tables containing tests results (e.g. Test2008, Test2009)? How do I link them together? Your help is REALLY appreciated.

Creating a Database to track Employee Training
I am in the process of designing a database that tracks certain employees training history.

I created three tables; tblEmployees(PK -Employee ID), tblTraining(PK - TrainingID), Course (PK-CourseID)

My problem is that I created a form, and a subform. But I cannot get both forms to be in Synch. Meaning once I select an employee, listing the training history of the employee. I would also like to be able to additional training information for each employee. I feel that I am almost there, but I am not sure what I a missing.

Permissions for sharing a database
I have a split database which I would like to share between two departments. I want one of the departments to have full access permissions to the database and create a form for the other department to view and select a check box. I dont want the department with the view and select check box permissions to make any other changes to the database and the ability for them to only view the other reports.

How to use SendObject Macro
I am attempting to create a SendObject Macro that sends an email to managers who have not completed certain assignments.
I run a query that pulls out those managers and their email addresses and create a report with that information.
How can I get the To action arguments to pull from the query/report to obtain those managers email addresses and not have a set distribution list

Access 2000 Forced Page Breaks
I am an average user of Access and have been working on a project at work with it. I have everything completed, except one task in the reports.

In the forms, I have a drop down menu with each departments listed. In the report, I have a 2 column report that looks great. Only problem is I want to force a page break for each of the departments listed in the original form (a total of 8 departments), so all of them do not run together on the report. I have been messing with it for a few days now and can't seem to get it to work. I am sure its easier then I think

Delete Records
I want to see if this can be done. I have an employee and asset database. If an employee gets fired, I need remove them from the general employee records, but I want to save a record of that employee. Is there a way to delete an employee from one table and have it automatically added to another table

When web users use 'client' database objects?
I am designing a web database in Access 2010 so that company employees and managers can enter and manage data. As it grows (as databases seem to do), I increasingly want to make some 'client' features available to branch managers - like providing them with detailed financial reports with charts and queries that allow date selection criteria.

Because I'm finding it hard to find an Access Services host, I've not yet been able to trial it.

In the Access help I read that: "People can open the web database in Access, and then use the client objects.

Can anyone who has published a web database assure me that this means that a user who has Access 2010 installed can log in to the web-database - and use 'client' functions? This is what I'dlike to believe from the above,

(and bearing in mind how user permissions are organised in Sharepoint), can I then organise it so that employees have access to one level of data on their web browsers,and managers use their logins to be able to use the more flexible 'client' functions - also by logging on to the web? then MSAccess 2010 really does rock!

Question about table access
Operating on a split database. If I have a table with a bunch of values, say Department names for example.

If I create a query and fill it with the contents of the Departments table, does references to that Departments query access the backend at all?
This is of course only when values are being read and not written to.

How do I use the DSum
I am trying to setup a database that records Employee Leave, I have Two tables, one EMPLOYEES and EMPLOYEE LEAVE. In EMPLOYEE LEAVE, I have used the EMPLOYEE names and EMPLOYEE ID from the EMPLOYEE table as the Primary key. The problem is this, I have so far managed to get the data in the Form to calculate how many month leave an employee has accrued till the current date, but need a way to add the total days leave they have taken so far in the TOTAL DAYS TAKEN field that is in the EMPLOYEE LEAVE table and only add the TOTAL DAYS LEAVE for each individual Employee per record at any given date. I intend to use this value to subtract TOTAL LEAVE TAKEN from another field LEAVE LEFT which will them give a value for TOTAL LEAVE AVAILABLE.

I am relatively new to this, so please assist where possible.