Overview:

This course is designed for students who have a thorough understanding of the basic and advanced user features of the Access program, and are interested in learning introductory level administrator skill sets. This course is also for the student that may be working in a web-based environment and may need to adapt Access applications to the environment.

Course 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 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

Assessment:

Candidates will complete a short assesment. On completion, they will receive a Certificate of Training.