Access Level 3
Printer friendly

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

This course is suited for those using Office 2003 or Office 2002. This course will be taught using MS Office Access 2003.



Objectives
  

This Course Includes:
  Six months of access to Online Learning Resources for the topics covered in your class. Online Learning Resources is a convenient, on-demand way of helping you retain what was taught in your class.

Sixty days of access to Post Class Support for instant help regarding the topics and tasks covered in your class. Post Class Support provides you with 24/7 support from certified experts via chat, phone and multimedia, including live demonstration, collaborative learning and step-by-step instruction.

Audience
  Access Level 3 is 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 skillsets. The 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. It is also designed for students pursuing the Microsoft MOS Expert Level Certification for Access.




Prerequisites
  Windows XP Levels 1 and 2 Access Levels 1 and 2
Course Number
  EKEUACCL3
Course Length
  1 Days

Course Price
  $275.00
Category
  1
Topics
  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