Project
Courtyard Medical Plaza wants to add a form and a report to its database. To ensure consistency, the starting file is provided for you. Create a blank form and modify the form in Layout view. Edit properties to restrict the form to data entry and add buttons. Next, create a report using the Report Wizard. In Layout view, modify the layout, add sorting, and add conditional formatting. Finally, preview the results.
Skills Covered in This Project
• Create a form using the Form tool.
• Edit a form in Layout view.
• Add the current date to a form.
• Move fields within the control layout.
• Restrict a form to data entry.
• Test the functionality of a form.
• Create a report using the Report Wizard.
• Edit a report in Layout view.
• Add grouping and sorting to a report.
• Add totals to a report.
• Add conditional formatting to a report.
• Preview a report.