In previous levels, you were introduced to the various features of Microsoft® Office Access™ 2007 that dealt with local database management. However, effective database management calls for mastering the advanced administrative and collaborative features of Access. In this course, you will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.
Upon successful completion of this course, students will be able to:
- share Access data with other applications.
- use VBA to automate a business process.
- create and modify a database switchboard, and set the startup options.
- secure databases.
- share databases using a SharePoint site.
This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft® Office Access™ 2007 application, and are interested in learning introductory level administrator skill sets. The course is also for the student who may be working in a web-based environment and may need to adapt Access applications to the environment.
To ensure the successful completion of Microsoft® Office Access™ 2007: Level 4, the following courses or equivalent knowledge is recommended:
- Microsoft® Office Access™ 2007: Level 1
- Microsoft® Office Access™ 2007: Level 2
- Microsoft® Office Access™ 2007: Level 3
Lesson 1: Integrating Access into Your BusinessTopic 1A: Import XML Data into an Access DatabaseTopic 1B: Export Access Data to XML FormatTopic 1C: Export Data to the Outlook Address BookTopic 1D: Collect Data Through Email MessagesLesson 2: Automating a Business Process with VBATopic 2A: Create a Standard ModuleTopic 2B: Develop CodeTopic 2C: Call a Procedure from a FormTopic 2D: Run the ProcedureLesson 3: Managing SwitchboardsTopic 3A: Create a Database SwitchboardTopic 3B: Modify a Database SwitchboardTopic 3C: Set the Startup OptionsLesson 4: Distributing and Securing DatabasesTopic 4A: Split a DatabaseTopic 4B: Implement SecurityTopic 4C: Set PasswordsTopic 4D: Convert an Access Database to an ACCDE File Topic 4E: Package a Database with a Digital SignatureLesson 5: Sharing Databases Using a SharePoint SiteTopic 5A: Export a Table to a SharePoint ListTopic 5B: Import Data from a SharePoint ListTopic 5C: Publish a Database to a SharePoint SiteTopic 5D: Move a Database to a SharePoint SiteTopic 5E: Work Offline