You'll Learn

Using Access Query

• Query overview
• Running a Query
• Creating Query using Query Wizard
• Designing a customized Query

Using Advanced Query Features

• Joining Tables in Queries
• Creating a calculated field
• On demand Query
• Other Options-specify criteria, sort records, calculate totals, set properties
• Aggregate queries
• About aggregate functions ( group by , expression, where )

Using Action Queries

• make-table queries,
• delete queries,
• append queries,
• update queries

Report and Report Design

• Report overview
• Working with reports
• Creating, Modifying a Report
• Standard Report by Report Wizard (AutoReport)

Using Advanced Report Features

• Designing Customized Report
• Adding calculate totals and averages
• Customize controls
• Customzed headers and footers
• Grouping and Sorting records
Creating On-Demand Reports