Access 2003: Level 4

Learning Objectives:

• Accurately apply knowledge of security procedures to set passwords, encrypt and decrypt the database and determine which procedures are appropriate for the data being stored.

• Using what you have learned in class, plan and develop a PivotTable with the appropriate tool and demonstrate mastery.

• Successfully integrate Access into business operations as indicated in the Lesson Lab.

• Given criteria, apply Access tools to create a standard module to facilitate the entry and manipulation of business data without error.

Extend your knowledge of Access into introductory-level administrator skill sets in this one-day session. This course is also one of a series for those pursuing MOS certification in Access 2003.

· Making your Data Available on the Web
· Create a Data Access Page by Using the Wizard
· View Data Access Pages with the Browser
· Plan and Develop a PivotTable with the Office PivotTable Tool
· Split a Database
· Implement Security, set passwords
· Encrypt and Decrypt a Database
· Link Tables to External Data Sources
· Import and Export XML data
· Automate a Business Process with VBA

Access 2003: Level 4

Upon successful completion of this course, students will be able to:
Create and modify a database switchboard, and set and modify startup options.
Develop a data access page and include in it a PivotTable and PivotChart. Distribute a database and add security features to it. Integrate Access more fully into your business operations Create and modify a Database Switchboard and Set Startup Options. Create a Standard Module; create and insert a procedure; develop procedure code; call a procedure from a form and run the procedure.
Convert an Access Database to an MDE File

Class targeted to:

Students who have a thorough understanding of the basic and advanced user features of the Access program, and who are interested in developing introductory-level administrator skill sets or those pursuing the MOUS Expert Level Certification.

Prerequisites:

Mastery of Access 2003: Introduction (Level I), Intermediate (Level II), and Advanced (Level III).