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 Microsoft Access Advanced course teaches the concepts and skills necessary for advanced use of Microsoft Access. You will learn how to create advanced queries, forms, and reports, design and implement macros, and effectively manage databases. This course is ideal for individuals looking to become advanced users of Microsoft Access, enhancing their ability to streamline data management and automate tasks. At the completion of this course, participants will be able to:
- Create advanced queries by grouping and summarizing data, updating and deleting records, managing relationships, and applying indexing for performance.
- Design advanced forms using subforms, advanced control types, and specialized form structures.
- Develop advanced reports with subreports, complex grouping techniques, and advanced formatting.
- Build and manage macros by creating basic macros, utilizing variables, and troubleshooting issues.
- Perform database management tasks such as compacting and repairing databases, restoring data, and executing other maintenance procedures.
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
Chapter 1: Advanced queries
- Module A: Grouping and summarizing
- Module B: Updating, deleting, and relationships
- Module C: Indexing for performance
Chapter 2: Advanced forms
- Module A: Subforms
- Module B: Advanced control types
- Module C: Specialized form types
Chapter 3: Advanced reports
- Module A: Subreports
- Module B: Advanced grouping
- Module C: Advanced formatting
Chapter 4: Macros
- Module A: Creating basic macros
- Module B: Using variables
- Module C: Troubleshooting macros
Chapter 5: Database management
- Module A: Compact & Repair
- Module B: Restoring a database
- Module C: Other maintenance tasks
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
