BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
Course Overview
This one day, instructor led advanced-level course equips participants with the skills to manage and enhance complex Access databases. Students will learn to import and export data, create advanced queries, develop sophisticated forms and reports, and automate tasks using macros and VBA. The course also covers database management, performance optimization, security implementation, and strategies for multi-user deployment. By the end of the course, participants will be able to extend database capabilities and maintain secure, efficient, and professional Access solutions. At the completion of this course, participants will be able to:
- Import, link, and export data, including creating mail merges.
- Build advanced queries, including action, unmatched, and duplicate queries.
- Design complex forms and reports, including subforms, subreports, and navigation forms.
- Automate tasks using Access macros and VBA to enhance user interaction and database functionality.
- Manage database performance, backup, and documentation.
- Implement security measures, distribute databases for multiple users, and prepare databases for deployment.
Course Schedule
Currently, there are no public classes scheduled. Please contact a Phoenix TS Training Consultant to discuss hosting a private class at 301-258-8200.
Course Outline
Lesson 1: Importing and Exporting Table Data
- Topic A: Import and Link Data
- Topic B: Export Data
- Topic C: Create a Mail Merge
Lesson 2: Using Queries to Manage Data
- Topic A: Create Action Queries
- Topic B: Create Unmatched and Duplicate Queries
Lesson 3: Creating Complex Reports and Forms
- Topic A: Create Subreports
- Topic B: Create a Navigation Form
- Topic C: Show Details in Subforms and Popup Forms
Lesson 4: Creating Access Macros
- Topic A: Create a Standalone Macro to Automate Repetitive Tasks
- Topic B: Create a Macro to Program a User Interface Component
- Topic C: Filter Records by Using a Condition
- Topic D: Create a Data Macro
Lesson 5: Using VBA to Extend Database Capabilities
- Topic A: Introduction to VBA
- Topic B: Use VBA with Form Controls
Lesson 6: Managing a Database
- Topic A: Back Up a Database
- Topic B: Manage Performance Issues
- Topic C: Document a Database
Lesson 7: Distributing and Securing a Database
- Topic A: Split a Database for Multiple-User Access
- Topic B: Implement Security
- Topic C: Convert an Access Database to an ACCDE File
- Topic D: Package a Database with a Digital Signature
BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
Phoenix TS is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints re-garding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: www.nasbaregistry.org
![[GSA LOGO]](https://phoenixts.com/wp-content/themes/phoenixts-com/assets/images/gsa-logo-black.png){kind=logo}
