certificate database

[Lorato]

I need your help. I want to automate the production of certificates at my
company. I train students in different courses and now want to develop a
small database to automate the printing of certificate. My idea is to have a
template of a certificate where i will just have to imput the student name
and course, upon selecting the course the course contents should atomatically
be input and after inputing all the filed i want to view and print the
certificate in a normal certificate design. I should be able to print second
compies of certificate and the certificate should also show that its a
re-issue. i should also be able to print report for certificates issues under
each course or students. i hope my problem is clear to others. thank you

 

[scubadiver]

Why don't you create a training registration database (as I am at the moment)?

 

[Lorato]

how do i start that my friend, give me more tips, i think your idea is the
best.

 

[JL Wright]

Build yourself a table with fields like [LastName] and [FirstName]. One of
your fields can be [Printed] and it should be a “Yes†or “No†combo.

Now built the report. The report should look like your certificate. A Text
Box in your report could be [FirstName]&†“&[LastName]

The report could be built off of a query or use the SQL Statement Query
Builder to tell the report to print only the certificates that you have
selected.

Hope that makes sense to you.

 

[scubadiver]

The one I am doing is quite complicated. I will give you the basic tables to
help get you started. This is a many-to-many relationship since each employee
can attend many classes and each class can have many employees:

tble_booking
BookingID (PK) Autonumber)
RoomID
CourseID
Duration
Trainingdate
TrainingTime
SupervisorID

tble_employee
EmployeeID (PK)
Employee

tble_attend
EmployeeID (FK)
BookingID (FK)
Attendance

1) Put the Booking table fields in the main form

2) Put "EmployeeID" and "Attendance" from "tble_attend" in the subform.
"BookingID" will be linked from the main form.

3) In the subform make the "employeeID" a combo box and use "tble_employee"
as the source. Make the ID number the bound column (in the data tab) but show
the names by making the width of the first column "0cm" and width of the
second column "2cm" (column widths in the format tab). This will show the
name but store the ID number.

The attendance field is a checkbox. After the training has finished, the
supervisor can tick all those who attended and then you can calculate
attendance rates.

What you can also put on the main form is a button that will open an
attendance register report. Base the report on a query that restricts the
report to the training course field on the main form.

That is the very basic one. Mine has forms for supervisors, courses,
department and employee information and employee feedback questionnaires.