D
DerekD
I am developing a database (using Access 2003; file is Access 2000 format)
that is used to schedule and track completion of compliance courses for our
employees. I have completed forms for scheduling, editing scheduled courses,
and marking courses completed. I want to be able to report unscheduled
courses, scheduled but not completed courses, and completed courses. I would
also like to have the results be able to be sorted by 1 of 5 criteria:
1. Manager
2. Location
3. Department
4. Course Title
5. Hire Date
In addition, would it be possible to allow the user to specify search
criteria to limit results? I am a novice user with some experience in VBA
and SQL. I am just unsure the best way to go about designing this.
that is used to schedule and track completion of compliance courses for our
employees. I have completed forms for scheduling, editing scheduled courses,
and marking courses completed. I want to be able to report unscheduled
courses, scheduled but not completed courses, and completed courses. I would
also like to have the results be able to be sorted by 1 of 5 criteria:
1. Manager
2. Location
3. Department
4. Course Title
5. Hire Date
In addition, would it be possible to allow the user to specify search
criteria to limit results? I am a novice user with some experience in VBA
and SQL. I am just unsure the best way to go about designing this.