Using Queries and Reports in Access 2003 Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number 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 (hours)
3.7
Lesson 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