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 beginner-level course introduces students to the fundamentals of Microsoft Access. Participants will learn how to work with tables, queries, forms, and reports to store, manage, and present data effectively. The course covers database planning, table creation, establishing relationships, building queries, and designing user-friendly forms and reports. Learners will also explore basic customization and help features to improve efficiency and usability. At the completion of this course, participants will be able to:
- Navigate Access and manage data using tables, queries, forms, and reports.
- Plan and create tables and establish relationships between them.
- Build basic queries to find, filter, sort, and calculate data.
- Design and enhance forms for effective data entry.
- Create and improve reports to present data clearly and professionally.
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: Working with an Access Database
- Topic A: Launch Access and Open a Database
- Topic B: Use Tables to Store Data
- Topic C: Use Queries to Combine, Find, Filter, and Sort Data
- Topic D: Use Forms to View, Add, and Update Data
- Topic E: Use Reports to Present Data
- Topic F: Get Help and Configure Options in Access
Lesson 2: Creating Tables
- Topic A: Plan an Access Database
- Topic B: Start a New Access Database
- Topic C: Create a New Table
- Topic D: Establish Table Relationships
Lesson 3: Creating Queries
- Topic A: Create Basic Queries
- Topic B: Add Calculated Columns in a Query
- Topic C: Sort and Filter Data in a Query
Lesson 4: Creating Forms
- Topic A: Start a New Form
- Topic B: Enhance a Form
Lesson 5: Creating Reports
- Topic A: Start a New Report
- Topic B: Enhance Report Layout
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
