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 Intermediate course builds upon foundational Microsoft Access skills, focusing on improving database efficiency, accuracy, and usability. Participants will learn techniques for ensuring data quality, enforcing referential integrity, and normalizing data for better performance and consistency. The course explores advanced query design, form and report customization, and strategies for creating a more user-friendly database environment. By the end of the training, learners will be able to manage complex data relationships, enhance data input reliability, and produce professional forms and reports that support decision-making and productivity. At the completion of this course, participants will be able to:
- Enforce data validation and referential integrity to maintain data accuracy.
- Normalize and relate tables to improve database efficiency.
- Create advanced queries to analyze and summarize data.
- Enhance forms and reports with subforms, formatting, and calculated fields.
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: Promoting Quality Data Input
- Topic A: Restrict Data Input Through Field Validation
- Topic B: Restrict Data Input Through Forms and Record Validation
Lesson 2: Improving Efficiency and Data Integrity
- Topic A: Data Normalization
- Topic B: Associate Unrelated Tables
- Topic C: Enforce Referential Integrity
Lesson 3: Improving Table Usability
- Topic A: Create Lookups Within a Table
- Topic B: Work with Subdatasheets
Lesson 4: Creating Advanced Queries
- Topic A: Create Query Joins
- Topic B: Create Subqueries
- Topic C: Summarize Data
Lesson 5: Improving Form Presentation
- Topic A: Apply Conditional Formatting
- Topic B: Create Tab Pages with Subforms and Other Controls
Lesson 6: Creating Advanced Reports
- Topic A: Apply Advanced Formatting to a Report
- Topic B: Add a Calculated Field to a Report
- Topic C: Control Pagination and Print Quality
- Topic D: Add a Chart to a Report
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
