Easy Excel Learning

Juan Hinojosa, Technologist and Math Instructor

Intermediate Access 7-13-2013 forms (subforms), reports, macros

It was a nice working with the group on Saturday July 13. 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
  • Creating a macro
  • Creating the AutoExec macro
  • How to hide the navigation pane.  (Note: use “F11” to show/hide the navigation pane.)

Intermediate Access 7-13-2013 forms, reports, macros