- Access 2007 Advanced

- Access 2007 Expert

- Outlook 2007 Advanced

- Outlook 2007 Expert

- Power Point 2007 Advanced

- Power Point 2007 Expert

- Excel 2007 Fundamentals

- Excel 2007 Advanced

- Excel 2007 Expert

- Word 2007 Fundamentals

- Word 2007 Advanced

- Word 2007 Expert

Access 2007 Expert

Course description
Overview: Students will learn how to use some advanced commands to work with forms, reports, designing tables, manipulating queries, as well as using subforms or subreports. It is designed for computer users who are familiar with Access and now want to explore some of the intermediate to advanced skill sets.

Prerequisites: Access 2007 Advanced or previous experience in Access.

Objectives:

• Create one-to-one, one-to-many and many-to-many relationships
  
• Use the table analyzer
  
• Perform maintenance on databases
  
• Identify object dependencies
  
• Open a database exclusively or with shared access
  
• Use the Database Documenter
  
• Create a form using the Form tool or a Form wizard
  
• Create a form in desing or layout view
  
• Add, move, resize, delete, formatting, space, anchor or group controls
  
• Creating datasheet forms, multiple item forms, split forms, and PivotTable forms
  
• Create a report using the Report Tool and Report Wizard
  
• Modify a report in  design or layout view
  
• Print and preview forms and reports
  
• Create mailing labels
  
• Use input masks, validation rules, or indexed fields
  
• Use the lookup wizrd or create lookup fields manually
  
• Work with query joins
  
• Create parameter, unique, unmatched and duplicate select queries
  
• Create summary, action, and sub queries
  
• Use embedded macros in forms or reports
  
• Create and modify charts
  
• Create a subform or subreport using the wizard or the subform/subreport tool