Access VBA Programming
Upon successful completion of this course, students will be able to:
- 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.
- automate a business process using VBA.
|
|
||||||||||
- Windows 98/ME
- Windows 2000
- Excel PowerUser Level
- MS Word PowerUser Level
Next Course(s):
None
This course is included in the following Certification Program:
- Microsoft Office Specialist
Our Program is All-Inclusive:
- 8 hours of classroom instruction
- Unlimited supervised computer lab/practice time for 6 months
- A complete instruction manual
- Certificate upon completion
- Career Enhancement Services
- Full Placement Counseling
- Free Resume Review
- Job Placement Assistance
- Free Test Preparation
- Computer-Based Training Files
- Assessment Testing
- Internship Opportunities
- Guarantee: Retake the course for free until test passed and/or employed.
- Check the schedule
Topics:
Lesson 1: Creating a Switchboard and Setting the Startup Options
Topic 1A: Create a Database Switchboard
Topic 1B: Modify a Database Switchboard
Topic 1C: Set the Startup Options
Topic 1D: Modify the Startup Options
Lesson 2: Developing a Data Access Page and Including a PivotTable and PivotChart
Topic 2A: Create a Data Access Page in Design View
Topic 2B: Incorporate a ComboBox Control in the Data Access Page
Topic 2C: View Data Access Pages with the Browser
Topic 2D: Add Records to a Database Using the Data Access Page
Topic 2E: Plan a PivotTable
Topic 2F: Develop a PivotTable with the Office PivotTable Tool
Topic 2G: Develop a PivotChart from a PivotTable
Lesson 3: Distributing and Securing the Database
Topic 3A: Split a Database
Topic 3B: Implement Security
Topic 3C: Set Passwords
Topic 3D: Encrypt and Decrypt a Database
Topic 3E: Convert an Access Database to an MDE File
Lesson 4: Integrating Access into Your Business
Topic 4A: Link Tables to External Data Sources
Topic 4B: Import XML Data into an Access Database
Topic 4C: Export Access Data to XML Format
Topic 4D: Replicate an Access Database
Lesson 5: Automating a Business Process with VBA
Topic 5A: Create a Standard Module
Topic 5B: Create and Insert a Procedure
Topic 5C: Develop Procedure Code
Topic 5D: Call a Procedure from a Form
Topic 5E: Run the Procedure
