Administering a Database System

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

1. Convert a database to an earlier version of Access
2. Use the Table Analyzer, Performance Analyzer, and Documenter
3. Use an input mask
4. Specify referential integrity options
5. Set startup options
6. Set and remove passwords
7. Encrypt a database
8. Use replication
9. Create PivotTables and PivotCharts
10. Create and run SQL queries
11. Split a Database
12. Create an MDE File
13. Specify user-level security

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

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 today will focus on the topics listed above.