help required creating a database to store training record records that saves a scanned copy

[pants1991]

I'm a access novice who is looking to create a database to store training records for permanent and agency staff, and contractors staff. I need the database to be able to produce reports on how many courses were trained over each month, and the total duration of the course completed (in hours).


If anyone has sometime to help me, I would be very grateful.

[ranman256]

I see these tables:

tStaff
-------
StaffID
firstName
lastName
addr
city
StaffType (A, P, or C) agency, perm or contractor
...etc


tTrainCourses (name of the training classes, date it begins/inception)
---------
trainID
ClassName
Date



tStaffTrain (each persons training history)
---------
StaffID
trainID
DateOfTrain
Hrs

[ItsMe]

I have used a custom Class that I purchased years ago to develop apps for scanning documents. Beyond purchasing some sort of class library that gives you API's, you might be able to do something with WIA. I think this is what is still used with Windows to get a handle on the TWAIN. This example looks pretty good.
http://stackoverflow.com/questions/2...s-pages-loaded