Using Queries and Reports in Access 2003

Using Queries and Reports in Access 2003

Overview/Description
To create and modify queries and reports in Access 2003

Target Audience

End users seeking to become familiar with Microsoft Access 2003 or to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2003 at Core level

Prerequisites

Familiarity with the Microsoft® Office environment

Expected Duration

220 Minutes

Objectives :

Using Queries and Reports in Access 2003

select the options that allow you to create and run a select query.

select the options that allow you to refine a query.

select the options that allow you to perform calculations on a query.

create and modify a query and print query results.

create a crosstab query.

find unmatched or duplicate records using queries.

use queries to obtain information useful to an organization.

select the appropriate methods to generate a specific report.

add controls to a report.

select the methods to organize data in a report.

create a report and organize its data.

Course Number: 125964_eng