ideas help please

[Reign - ExcelForums.com]

Hi everyone

I was wondering if you could please help me.

The Scenario.

I'm trying to make a database which will keep a listing of m
employers and also details of what training they have done and i
they have passed or not

I have no idea where to start can someone please point me in the righ
direction with either a template or what ?

Thanks heaps

 

[JulieD]

Hi

this would be easier in Access and i could provide you with a sample
database to do this if you have MS Access on your computer and would
consider using this as an alternative to Excel.

If you do want to do it in excel then the basic approach would be to create
a worksheet that lists the employee name, the course, the course date & the
result in four consecutive columns, then enter each training record on a
row.

You could use Data Validation to create a pick list of employees (linked to
another sheet with all the employee details on it) and also for the courses.
Check out www.contextures.com/tiptech.html for information on data
validation.

Hope this helps
Cheers
JulieD

 

[Reign - ExcelForums.com]

Hi Juli

I do have access and I wouldn't mind using it at all I was going to d
it in there but then xcel came to mind if you do have a sample I coul
look at that would be awesome

thank

my email is (e-mail address removed)

thanks agai

 

[JulieD]

Hi

i've emailed it to you

Cheers
JulieD