 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||
 |
 |
 |
|
|||||||||
Students will learn remote database management, how to exchange data with XML and other type applications, and how to automate business processes by using VBA code.
Prerequisites:
Access 2003 Level 3, or equivalent knowledge.
Unit 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
Unit 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
Unit 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
Unit 4 : Automating a Business Process with VBA
Create a Standard Module
Develop Code
Call a Procedure from a Form
Run the Procedure
Unit 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
Unit 6 : 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