Course Objectives: Advanced Microsoft Access 2003

Compare your skills and experiences to these objectives to see if this course would be appropriate for you to take.

• Validate field entries.
• Create a custom input mask.
• Create a master-detail form.
• Add a picture to a form.
• Display the current date on a form.
• Create an advanced filter.
• Create a parameter query.
• Create a query to generate summary information.
• Create an action query.
• Create a master-detail report.
• Create and run a macro.
• Create a command button.
• Write an event procedure.*
• Set database startup options.
• Set a database password.
• Encrypt and decrypt a database.*
• Use the Database Splitter Wizard and the Linked Table Manager.*
• Create a replica of a database.*
• Add a PivotTable and a PivotChart to a data access page.*
• Create a switchboard.*
• Export Access data to an XML document.
• Import an XML document into Access.
• Save an Access database in an MDE file.*
• Create an Access workgroup.*

*These topics will be covered in classes only if time allows.

Microsoft offers certification in this subject, and depending on your position and duties, you may be eligible for reimbursement for the certification exam fee (currently around $75). View the exam objectives.