Course Catalog > Advanced Microsoft Access 2007 Part 2
Advanced Microsoft Access 2007 Part 2
Advanced Microsoft Access 2007 Part 2 (1 Day)
Our Access 2003 relational database training courses will help you learn how to build, maintain, and implement relational databases.
Whether you are new to Microsoft Access or an advanced user, Current Technologie's Microsoft Certified Trainers will make you a Microsoft Access guru.
Advanced Microsoft Access 2007 is for those who want to expand their knowledge and abilities with Access into some of the more specialized and advanced capabilities, such as working with data exchange with other applications, automate business processes by using VBA code, and secure and share databases automate tasks, enhance forms & reports, and use Access in other Microsoft Office applications.
Come Experience the Current Technologies Computer Learning Center Way of Training. We take great care of all of our students.
The CTCLC Difference
Current Technologies Computer Learning Center uses our own certified instructors that will help guide you to a sucessful completion of your Microsoft Office training and certification. Our Instructors are simply the best instructors you will find. Let our great instructors help you get started in understanding and using your Microsoft Office applications. CTCLC has convenient day or night schedules to fit your needs. We can also do onsite classes with our top notch portable labs.
Our instructors are the very best and give 110% to their Students. We care about every student that we train and we have a Free Resit Policy for all of our courses for the same revision. You will not find a better training experience anywhere.
Current Technologies Computer Learning Center is Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Learning Alliance Member, EC-Council Accredited Training Center, and many others. We offer the highest quality, authorized training that you will find anywhere.
Intended Audience
This course is for the individual whose job responsibilities include working with related tables; creating advanced data sharing with other applications such as SQL Server, Oracle or other ODBC compliant application, securing databases, and automating data exchange.
- It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access 2007, and it is a prerequisite to take more advanced courses in Microsoft® Office Access 2007.
Course Objectives
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.
Duration
- 1 Day ( 8:30am to 4:30pm)
CTCLC Special Discounts
Advanced Microsoft Access 2007 Part 2 $249.00 List Price $299.00 Special Discounted Student price for 3 or more from the same Company $199.00
For More Information About Advanced Microsoft Access 2007 Part 2 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800
Course Outline
Advanced Microsoft Access 2007
Module 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
Module 2: Automating a Business Process with VBA
Create a Standard Module- Develop Code
- Call a Procedure from a Form
- Run the Procedure
Module 3: Managing Switchboards
- Create a Database Switchboard
- Modify a Database Switchboard
- Set the Startup Options
Module 4: Distributing and Securing Databases
- Split aDatabase
Implement Security- Set Passwords
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
Module 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 Offline
Certification Path
Required Exam(s) |
Recommended Training |
|
|---|---|---|
| Microsoft Certified Application Specialist (MCAS) - Access | ||
For More Information About Advanced Microsoft Access 2007 Part 2 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800