Microsoft Access 365 Basic: Build and Query Databases
Intended Organizations
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Skill LevelFundamentals
Virtual | Live Trainer4 hours/day, 1 Day
In-Person | Onsite6 hours/day, 1 Day
Skill Level & Progression
Skill level reflects the recommended course experience and helps match training to your team's needs. Most training courses support all learning levels.
General WorkforceDevelops team-ready capabilities across business roles and experience levels while strengthening skills and organizational results.
Fundamentals(this course)Builds introductory proficiency in essential terminology, core concepts, and workplace best practices for real-world application.
IntermediateStrengthens existing knowledge through advanced functions, skill strategies, and deeper exploration of core concepts.
AdvancedDeepens expertise through complex subject matter, specialized skills, advanced analysis, and higher-level instruction.
Course Formats
Train on your terms. Choose virtual or onsite delivery, schedule sessions around your team’s availability, and align course content with your objectives and real-world challenges.
Virtual Training4 hours/day, 1 DayLive, interactive, instructor-led training delivered through a secure videoconferencing platform.
Onsite Training6 hours/day, 1 DayEngaging, instructor-led training delivered in person at the location of your choice.
Course Duration
Course duration varies by training format and time needed to effectively cover the material, with hours per day and total days listed.
Generates a branded PDF — downloads directly to your device
Course Overview
Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft Office Access® can help you and your organization with this task. This course covers the introductory skills needed to perform basic database design and development in Access.
Navigate within the Access application environment, create a simple database, and customize Access configuration options
Organize and manage data stored within tables
Join, sort, and filter data from different tables
Use forms to view, access, and input data
Create and format custom reports
Who It's For
Beginners looking to learn database management using Microsoft Access 365.
Professionals who need to organize, store, and manage workplace data efficiently.
Administrative staff seeking to create tables, queries, forms, and reports.
Employees who want to filter, sort, and combine data from multiple tables.
Users preparing to advance their skills through intermediate Microsoft Access training.
Course Agenda
Five modules · 17 topics
1Promoting Quality Data InputTopics 1–6
Launch Access and Open a Database
Use Tables to Store Data
Use Queries to Combine, Find, Filter, and Sort Data
Use Forms to View, Add, and Update Data
Use Reports to Present Data
Get Help and Configure Options in Microsoft Access
2Creating TablesTopics 7–10
Plan an Access Database
Start a New Access Database
Create a New Table
Establish Table Relationships
3Creating QueriesTopics 11–13
Create Basic Queries
Perform Calculations in a Query
Sort and Filter Data in a Query
4Creating FormsTopics 14–15
Start a New Form
Enhance a Form
5Creating ReportsTopics 16–17
Start a New Report
Enhance Report Layout
About our Trainers
Our Mission
Our facilitators are committed to delivering the latest industry trends, job-specific best practices, and the essential soft and hard skills needed in today’s workforce. PTR offers small and large organizations the choice between onsite and virtual training. Collaborate with our specialists to address challenges, bridge skill gaps, and tailor the learning experience to meet your company’s goals.
What is the Microsoft Access 365 Basic course about?
This course introduces the fundamentals of Microsoft Access database design and development. Participants learn to create databases, organize data in tables, build queries, use forms, and generate reports.
Who should attend the Microsoft Access 365 Basic course?
The course is suitable for beginners, administrative professionals, office staff, and employees who need to organize, manage, analyze, or present data using Microsoft Access.
What will I learn in this Microsoft Access course?
You will learn how to create a database, design tables, establish table relationships, build queries, calculate and filter data, create forms for data entry, and prepare formatted reports.
Will I learn how to create and manage database tables?
Yes. The course covers planning a database, creating tables, organizing stored data, and establishing relationships between tables to structure information effectively.
Does the course cover forms for data entry?
Yes. You will learn to create and enhance forms that make it easier to view, add, and update information stored in your database.
What is the benefit of learning Microsoft Access for workplace data management?
Microsoft Access can help organize information, maintain structured records, retrieve specific data, and present findings through queries and reports. These skills can support more efficient everyday data management.
Can organizations arrange Microsoft Access training for their employees?
Organizations can contact PTR Training to discuss group training options. This course can help employees develop consistent database management skills and improve how they organize and present workplace data.
Microsoft Access 365 Basic: Build and Query Databases
Request a Training Quote
Share your team’s goals, and we’ll recommend the right skills training.
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.