Application Structure

The application is composed of the following components:

• Managers table—lists managers who will receive reports

• Projects table—lists all projects and associated managers

• ProjectWork table—lists hours and cost of projects by date and staff

• ProjectSummary query—totals hours and cost by project

• Status form—displays while reports are being run

• Project Summary report—a report for distribution to managers

• CreateReports macro—creates and mails reports

• MAPI Library module—MAPI function, type, and constant declarations

• Reports module—all application-specific code