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 Beginner/Intermediate course introduces participants to essential database concepts and provides hands-on experience in creating and managing databases using Microsoft Access. Participants will learn how to navigate the Access interface, design and structure tables, create queries to retrieve data, and develop forms and reports for data entry and presentation. This course is ideal for those looking to build a solid foundation in Access and effectively manage structured data. At the completion of this course, participants will be able to:
- Understand general database concepts, relational databases, and the Access interface.
- Create and modify tables, define fields, apply data validation, and establish relationships using primary and foreign keys.
- Design and modify queries to retrieve and manipulate data, including using calculated fields.
- Build simple forms, apply form design principles, and use form controls for data entry and management.
- Develop and format reports using report controls to effectively present data.
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: Database fundamentals
- Module A: Understanding general database terms
- Module B: Relational databases
- Module C: Access interface and objects
Chapter 2: Tables
- Module A: Creating tables
- Module B: Creating fields
- Module C: Data Validation
- Module D: Relationships and keys
Chapter 3: Queries
- Module A: Creating basic queries
- Module B: Modifying queries
- Module C: Using calculated fields
Chapter 4: Forms
- Module A: Creating simple forms
- Module B: Form design
- Module C: Form controls
Chapter 5: Reports
- Module A: Creating Reports
- Module B: Report controls
- Module C: Formatting reports
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
