|
Access 2003 - Level 3
Duration:
1 Day
Overview:
In this course, students
will learn remote database management, how to exchange data with XML and
other type applications, and how to automate your business processes by
using VBA code.
Pre-requisites:
Access 2003 - Level 1
Access 2003 - Level 2
Outline:
|
Lesson 1:
Making Your Data Available on the Web |
Create a Data
Access Page by Using the Wizard, Improve the Presentation of the
Data Access Page, Viewing Data Access Pages with the Browser, Edit
Data Using the Data Access Page, Group Records in the Data Access
Page |
|
Lesson 2:
Developing a Data Access Page in Design View |
Create a Data
Access Page in Design View, Incorporate a ComboBox in the Data
Access Page, Test the New Record Function of the Data Access Page,
Develop a PivotTable with the Office PivotTable Tool, Develop a
PivotChart |
|
Lesson 3:
Integrating Access into Your Business |
Import XML Data
into an Access Database, Export Access Data to XML Format, Share
Data with Other Office Applications |
|
Lesson 4:
Automating a Business Process with VBA |
Create a
Standard Module, Develop Code, Call a Procedure from a Form, Run the
Procedure |
|
Lesson 5:
Creating a Switchboard and Setting the Startup Options |
Create a
Database Switchboard, Modify a Database Switchboard, Set the Startup
Options, Modify the Startup Options |
Lesson 1:
Distributing and Securing the Database |
Split a
Database, Implement Security, Set Passwords, Encode and Decode a
Database, Convert an Access Database to an MDE File |
Back to Office 2003
Course List
|
