Course Objectives: Intermediate Microsoft Access 2003

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

• Specify a required field in a table.
• Define a default field value in a table.
• Add a Memo field to a table.
• Display multiple tables on the Access desktop.
• Resize and reposition the Table window.
• Create a relationship between two tables in a database.
• Display and use a subdatasheet.
• Design a custom form.
• Add a calculated control to a form.
• Create a query to extract information from multiple tables.
• Find unmatched records in a table.
• Create a report of information in multiple tables.
• Add a calculated control to a report.
• Create a data access page.*
• Add a hyperlink to a data access page.*
• Use the Database Wizard.*
• Add a Lookup field to a table.*
• Define an input mask for a field.*
• Export an Access datasheet to Microsoft Excel.

*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.