Skip to main content

Access Chapter 4

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.
  • Access: Forms Participation Project
  • MyLab Lesson E
  • MyLab Lesson E
Create forms using the Form Wizard.
  • Access: Forms Participation Project
  • Homework #5
Modify the design of existing forms by performing tasks such as editing label text.
  • Access: Access Basics Participation Project
  • Access: Forms Participation Project
  • MyLab Lesson E
  • MyLab Lesson E
Use forms to modify data.
  • MyLab Lesson E
  • MyLab Lesson E
Use the Report tool to create reports.
  • Access: Reports Participation Project
  • MyLab Lesson E
  • MyLab Lesson E
Create reports using the Report Wizard.
  • Access: Reports Participation Project
  • MyLab Lesson E
  • Homework #5
  • MyLab Lesson E
Modify the design of reports by adjusting column headings, sizes, and sorting
  • Access: Access Basics Participation Project
  • Access: Reports Participation Project
  • MyLab Lesson E
  • Homework #5
  • MyLab Lesson E

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

  1. 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.
    1. 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/.