Advanced Database Features in Access 2002 Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Overview/Description
To demonstrate a range of advanced database features in Access 2002
Target Audience
Anyone wishing to become familiar with Microsoft Access 2002 at an advanced level; students seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at advanced level
Prerequisites
The Microsoft Office XP: Beginning Access 2002 learning path; familiarity with any Windows user environment
Expected Duration (hours)
6.3
Lesson Objectives Advanced Database Features in Access 2002
use charts in Access 2002 forms and reports.
create a chart using the Chart Wizard in Access 2002.
run Access 2002 projects against SQL Server 2000.
define XML data and describe how it is integrated with Access 2002.
describe the use of XML in Access 2002.
create a live web report in Access 2002.
save Microsoft Access data or database objects as a web page and use data access pages in Access 2002.
create a data access page in Access 2002.
to create and modify a data access page using the Page Wizard in Access 2002.
describe how to take data offline in Access 2002.
create and modify a data access page using Design view in Access 2002.
specify startup options and set and modify a database password in Access 2002.
set a database password in Access 2002.
analyze the performance of a database in Access 2002.
use the replication and encryption tools in Access 2002.
use macros in Access 2002.
create a macro using the Macro Builder in Access 2002.
discuss the function of Visual Basic in Access 2002.
discuss the different ways to control program flow in Access 2002.
write Visual Basic code in Access 2002.
write a procedure in Access 2002.
build an application and use MDE files in Access 2002.
create an MDE file in Access 2002.
Course Number: 116051_eng