Easy Excel Learning

Juan Hinojosa, Technologist and Math Instructor

Intermediate Access 11-8-2014 forms, subforms, reports, macros

It was a nice working with the group on Saturday November 8. Below is a copy of the database developed during the workshop. You can use it to practice and review the activities covered in class.

  • Creating a one to many relationship
  • Creating a form
  • Creating a form with a subform
  • Creating a report
  • Adding a group and adding a sort to a report
  • Adding a number list to groups in a report
  • Creating a macro
  • Creating the AutoExec macro
  • How to hide the navigation pane. (Note: use “F11” to show/hide the navigation pane.)

Intermediate Access 11-8-2014 forms, reports, macros