"The decimal field's precision is too small to accept the numeric you attempted to add". The problem field has a currency format (£00.00) Precision -...

Before Christmas I was asked about the possibility of setting up a training database for the employees. Instead of typing out the fields for every table I...

I have a working hours database for staff and it records basic and overtime hours on separate records. I also want to record enquiry volumes on a weekly...

The database I am using now has a 1:m relationship. Employee info is in the main form and the records are in the subform. I know that for each employee,...

Earlier in the year I devised a database to hold working hours information for members of staff. Because I didn't know any better I used a 1:m relationship...

I've been sorting out my design for this and I *think* I have come up with something that should pass the test! As far as I can see, none of the fields or...

I am still working on my training records database. I have got my three main tables sorted out (hoorah! LoL). To get a list of supervisors, it was suggested...

....what I am missing? If I have training courses and employees, I know that each employee attends many training courses and each course is attended by many...

Anyone designed a db for this purpose? At the moment I have in my mind the following logic: For the first two tables in this list, each employee can attend...

I have been asked to design a database but I am not entirely sure how to go about it. I have job titles and job descriptions. A job title will have many job...

For the last couple of weeks I have been trying to design a website and it is proving to be a bit more challenging than I thought. I thought I had managed it...

For my employee database, I think I have managed to crack my table relationships. This is the way I have it set up in the relationships box from left to right...

Hi, Due to work demands some temp employees in my office may work in more than one department. for my database I am aiming to record the total number of...

my table relations. From left to right: "Employees" Payroll (PK: 1) Employee Work Status Rate

I designed my database, did some testing and it has been working fine. My manager would like to have the database open to everyone in the department. This will...

I have a working hours database so info is entered on a weekly basis for each employee. I have a query that totals the number of hours for each department...

My database holds employee records on a weekly basis. I have a query that totals up the number of hours for each department for each week. What I would like...

I assume you are putting these three names into separate fields? If not you should do. initial: left(,1) -- The 11th day of every month:

Hi all, as I continue on my awesome journey of Access I am making efforts to improve my design. My question is this. I am adding a new element to my database...

Hi all, Have a question here. I am creating a new DB and want to get the design right first. Concept: I work for the US Coast Guard. Small Boat Stations...