Category: Macros (Access)

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

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

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

Intermediate Access 4-13-13

Below is the link to the “Movie List” database developed in class. It has been provided so you can practice the activities done in class. It contains tables, a report, a data form, and macros developed in class.

To access the database:

1. Download the zip file below.
2. Open the folder containing the zip file from the previous step.
3. Right click that zip file to extract it.
4. Once the zip file is extracted, you should be able to open the database.

Intermediate Access 4-6-13

I am pleased to announce below is the link to the two database projects developed in class:
Intermediate Access 10-28-2012 (two databases)
It has been provided so you can practice the activities done in class.

I am pleased to announce the reports, forms, macros, and relationship exercises developed during the workshop are attached. To access the databases, you will need to download the zip file: Intermediate Access 7-22-2012.zip and then right click that zip file to extract it. Click the link below to access the review materials:

Intermediate Access 7-22-2012