Chapter Demonstrable Skills
After completing the Access Chapter 4 portion of the Access unit, students will be able to:
Demonstrable Skill | Learning Activities & Informal Assessments |
Formal Assessments (excluding Exams) |
---|---|---|
Use the Form tool to create forms. |
|
|
Create forms using the Form Wizard. |
|
|
Modify the design of existing forms. |
|
|
Use the Report tool to create reports. |
|
|
Create reports using the Report Wizard. |
|
|
Modify the design of reports by adjusting headers, footers, column headings, sizes, and sorting. |
|
|
Chapter Notes
Forms
A form is a database object that is used to add data into or edit data in a table [1]. The easiest way to design a form is to use the Form Wizard. A record source is the table or query that supplies the records for a form.
When creating forms involving multiple related tables using the Form Wizard or Form tool, Access will automatically created a main form and nested subform(s) to tie together the information in the different tables [1].
Reports
A report is a document that displays information from a database in a format that outputs meaningful information to its readers [1]. Access reports can be printed, viewed on screen, or even saved as a file.
Reports cannot change data in your database. They are designed for output of information only. The easiest way to design a report is to use the Report Wizard. Identify your data sources (tables and/or queries) and be sure to add all of them in the first step.
Tips & Tricks
Forms and Reports
As mentioned in the notes above, the key to getting your form or report correct is identifying all of the sources of data you need and including them in the first step of the Form Wizard or Report Wizard. If you don't, it's difficult to add them later [2].
References
- A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 1. Upper Saddle River, NJ: Pearson Education, 2013.
-
- G. Phipps and B. M. Powell, “Access Chapter 4,” Computer Science 101, May 18, 2016. Available: http://cs101.wvu.edu/materials/units/access/access-chapter-4/.