1. Lecture Notes 11 and
2. Lecture Notes 12

instead. Please check the Class Notes web page

Using Visual Basic for Applications (VBA) and Advanced Form Techniques

You will have mastered the material in this project when you can:

1. Add buttons, controls, and combo boxes to forms.
2. Modify Access-generated VBA code.
3. Use VBA.
4. Create functions in a standard module.
5. Test functions.
6. Use the functions in a query.
7. Associate code with an event.
8. Create Sub procedures.
9. Create a function to run a command.
10. Create a form using Design view.
11. Add a tab control.
12. Add a subform control to a form.
13. Add a chart to a form.
14. Add an ActiveX control to a form.

Questions that you will receive next time will focus on the topics listed above.

Creating a Report Using Design View

You will have mastered the material in this project when you can:

1. Open a database
2. Create additional tables
3. Import data from an ASCII text file
4. Change the layout of a table
5. Relate several tables
6. Change join properties
7. Change field properties in a query
8. Filter a query's recordset using
   1. Filter By Selection and
   2. Filter By Form
9. Create and run a parameter query
10. Create queries for reports
11. Create a report
12. Group and sort in a report
13. Add fields to a report
14. Add a subreport to a report
15. Modify and move a subreport
16. Add a date and page number
17. Bold data
18. Add a title
19. Change margins
20. Create and print mailing labels

Questions that you will receive today will focus on the topics listed above.