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.