D
DerekD
I am designing a database that essentially tracks scheduling and completion
of compliance exams by employees. I have forms completed for scheduling,
editing, and marking a course as completed. I want to be able to report in
the following manner:
Courses that are unscheduled,scheduled but not completed and another report
for completed courses.
In addition to that I want to be able to search/sort by 5 fields:
1. Manager's Name
2. Course Title
3. Department
4. Location
5. Hire Date
I am a novice user with some experience using VBA and SQL - I am just unsure
the best way to design this. Should I create a form with option boxes and
text boxes for search criteria? Should I have 15 different reports created
and allow the user only to specify a parameter for the selected sort field?
Any help is greatly appreciated.
of compliance exams by employees. I have forms completed for scheduling,
editing, and marking a course as completed. I want to be able to report in
the following manner:
Courses that are unscheduled,scheduled but not completed and another report
for completed courses.
In addition to that I want to be able to search/sort by 5 fields:
1. Manager's Name
2. Course Title
3. Department
4. Location
5. Hire Date
I am a novice user with some experience using VBA and SQL - I am just unsure
the best way to design this. Should I create a form with option boxes and
text boxes for search criteria? Should I have 15 different reports created
and allow the user only to specify a parameter for the selected sort field?
Any help is greatly appreciated.