Microsoft Office 2000 - Intermediate Access Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Overview/Description
To provide an introduction to the core concepts of Microsoft Access 2000 and the skill areas of creating and enhancing a report, working with queries, and integrating data
Target Audience
End-users seeking to become familiar with Microsoft Access 2000; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2000 at Core level
Prerequisites
Some knowledge of basic word processing and computing; familiarity with a Microsoft Windows environment
Expected Duration (hours)
5.0
Lesson Objectives Microsoft Office 2000 - Intermediate Access
define and create a report.
view and alter format properties of objects on reports and use Expression Builder to build calculated controls.
add a control to a report, modify format properties of sections and controls, and build a calculated control using Expression Builder.
preview and set up pages for printing.
create, modify, and format a new report.
create and modify reports in Design view.
alter the appearance and layout of a report.
modify section and control properties in a report, and preview the printed version of a report.
define and generate a subreport.
insert a subreport control into a report.
define and apply filters in queries.
apply filters in a query according to multiple criteria.
define and create a totals query and a parameter query.
modify the field properties of an existing query.
modify queries using action queries and SQL statements.
define join types and specify join properties.
improve query performance.
import table data into a database and link tables, and export data from an Access database.
import data from a table into a database and export data from an Access database to Excel.
create a chart and link data.
create and specify a chart using the Chart Wizard and view the resulting chart.
compact and split a database.
save database objects, back up data, and export data to web pages.
Course Number: 111353_eng