Agreed - don't give your editors access to an admin-level DDS tool.

I'm interpreting your question as wanting to build a datagrid view which supports inline editing, so you can change cells in each row with save/update/delete functionality, kind of like Excel. Apologies if my interpretation is off.

Creating an editable grid should be fairly easy - roughly:

• Create an Employee class with all the required properties, and create a new DataStore with typeof(YourEmployeeClass)
• Create a new page template (content type) that contains a grid-type webcontrol, like a simple asp:datagrid or one of the many jQuery grid libraries that allow inline editing. Most of them have demos showcasing this functionality along with CRUD operations. This page should be in a protected part of your site only available to editors with the required access level.
• Load your DataStore containing employees and bind it to your datagrid.
• On each CRUD event, update your DataStore and rebind your grid control.
• (Editors would be working with this page in its published state, not in On-Page or Forms-Edit mode.)

That should get you started, though there are probably sexier ways to do it. 

Thanks Arild.

That should work OK if I am able to allow them to create new records too.

Is there a way to allow editors this functionality from with the CMS area, rather than using a published page in a new area of the site? I'm hoping I can keep everything together in one place you see.

Maybe this will help?

http://joelabrahamsson.com/custom-rendering-of-content-areas/

Limiting the CRUD functionality to only be available when PageEditing.PageIsInEditMode is true may be the way forward?

Thanks, I'll give it a whirl :-)

If you need edit functionality I would probably store employees as pages/container pages. If it is a "fair" amount of employees that is. :)