- Other Location: Bukit Merah - Central
- Duration: 1 Day
Course details
In this course, students will exchange data with other applications, automate business processes by using VBA code, and secure and share databases. (Second Edition)
What will I learn?
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 Address 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 a 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 a Database 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 Offline
Prerequisites
- Access 2007 - Level 1
- Access 2007 - Level 2
Course Location
About New Horizons Singapore
Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business
See all New Horizons Singapore courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Certificate in Microsoft Word VskillsSGD 57Duration: 1 To 2 Months
- Microsoft Office 2016 Advanced John AcademySGD 34
SGD 518Duration: Upto 76 Hours
