Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / September 2007

Tip: Looking for answers? Try searching our database.

certificate database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lorato - 12 Sep 2007 14:54 GMT
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 - 12 Sep 2007 15:50 GMT
Why don't you create a training registration database (as I am at the moment)?

Signature

"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video

> 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
[quoted text clipped - 6 lines]
> 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
Lorato - 12 Sep 2007 16:00 GMT
how do i start that my friend, give me more tips, i think your idea is the
best.

> Why don't you create a training registration database (as I am at the moment)?
>
[quoted text clipped - 8 lines]
> > 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
JL Wright - 12 Sep 2007 16:52 GMT
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.

Signature

Jerry Wright

> how do i start that my friend, give me more tips, i think your idea is the
> best.
[quoted text clipped - 11 lines]
> > > 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 - 13 Sep 2007 08:32 GMT
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.

Signature

"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video

> how do i start that my friend, give me more tips, i think your idea is the
> best.
[quoted text clipped - 11 lines]
> > > 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.