Fall Semester 2003


Lab Eleven, October 10, 2003
Date
Oct 10, 2003
Note
Homework Four will be collected on Tue in class.

Due today
Project Seven (Lab Manual)

Starting today
Project Eight (Lab Manual)

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.

Due next time
Project Eight (Lab Manual)

Today's grading
Project Seven (Lab Manual)

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.


Last updated: Oct 13, 2002 by Adrian German for A114/I111