Enquiry Form

Duration: 1 Day

MICROSOFT ACCESS 2007 INTERMEDIATE

Objectives

Delegates will learn how to query multiple tables for data that is then used in customised forms and reports.

Designed for

Experienced users of Microsoft Access 2007.

MODULE 1: ACTION QUERIES

• Types Of Query
• The Crosstab Query
• The Make Table Query
• The Append Query
• The Delete Query
• The Update Query

MODULE 2: FORMS

• Forms
• Form Views
• Form Controls
• Basic Forms
• Using The Form Wizard
• Creating Forms In Design View
• Modifying And Redesigning The Form
• Conditional Formatting
• Sorting And Filtering Records By Using A Form

MODULE 3: REPORTS

• Reports
• The Report Wizard
• Creating A Summary Report With Totals
• Creating Reports In Design View
• Modifying And Redesigning Reports
• Report Headers & Footers
• Conditional Formatting
• The Keep Together Property
• Grouping, Sorting, And Filtering Records In A Report
• Group Headers And Footers
• Using The Label Wizard

MODULE 4: CHARTS

• Charts In Forms
• Modifying Charts In Forms
• Charts In Reports
• Modifying Charts In Reports