Microsoft Access Level 4
This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft® Office Access 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.
Lesson 1: Integrating Access into Your Business
- Import XML Data into an Access Database
- Export Access Data to XML Format
- Export Data to the Outlook Aliress Book
- Collect Data Through Email Messages
Lesson 2: Automating a Business Process with VBA
- Create a Standard Module
- Develop Code
- Call a Procedure from a Form
- Run the Procedure
Lesson 3: Managing Switchboards
- Create a Database Switchboard
- Modify a Database Switchboard
- Set the Startup Options
Lesson 4: Distributing and Securing Databases
- Split a Database
- Implement Security
- Set Passwords
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
Lesson 5: Sharing Databases Using a SharePoint Site
- Export a Table to a SharePoint List
- Import Data from a SharePoint List
- Publish a Database to a SharePoint Site
- Move a Database to a SharePoint Site
- Work Offline3
Microsoft Access
We are offering a 2 day course that covers concepts on how databases work, how to build a relational database and how to query and filter your data for $399.
Includes essential topics from levels 1, 2, 3 & 4.
