Microsoft Access for Office 365: Part 1 Training
Microsoft® Access® for Office 365™: Part 1: Focuses on the design and construction of an Access database viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 1
Course Overview
By the end of this course, users should be comfortable with navigating the Microsoft® Access® interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more.
Access is Microsoft®’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This version of Access® incorporates a few new features to better visualize data, support for new datatypes, as well as interface and workflow improvements.
- Getting Started with Access®
- Working with Table Data
- Query a Database
- Create Advanced Queries
- Generate Reports
- Design a Relational Database
- Joining Tables
- Importing and Exporting Data
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
Intended Audience
This course is designed for students looking to establish a foundational understanding of Access®, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Prerequisites
To ensure your success in this course, you should have end-user skills with any current version of Windows®, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
You can obtain this level of skills and knowledge by taking either of the following Logical Operations courses, or any similar courses in general Microsoft® Windows® skills:
Using Microsoft® Windows® 10 (Second Edition)
Experience in another Microsoft Office product such as Excel® is recommended. Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 would be a good choice.
Related training topics
Justify your training
Use this sample request letter — copy it into an email to your manager and personalize the bracketed details to make the case for the time and budget.
Sample training request letter
Subject: Request for Business Applications training from Applied Technology Academy
[Decision Maker Name],
I'm writing to request time and budget approval to complete Applied Technology Academy's course, Microsoft Access for Office 365: Part 1 Training. The information below outlines how this training benefits our organization, the tasks I'll be able to perform after completing it, and relevant cost and funding details.
Course Description
Microsoft® Access® for Office 365™: Part 1: Focuses on the design and construction of an Access database viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. Applied Technology Academy is an award-winning, SBA-certified woman-owned training provider (est. 2008) whose instructors are active practitioners; the course is hands-on with virtual labs and a learn-by-doing methodology.
Course Objectives
Once I've completed the course, I'll have hands-on, job-ready skills in business applications that I can apply immediately to our work.
Expected Organizational Benefits
After completing this course, I will be better equipped to apply these skills directly to our projects, reduce our reliance on outside expertise, strengthen our team's capabilities, and share what I learn with colleagues.
Expected Cost & Funding
Course fee: [request an itemized quote at the link below]. Applied Technology Academy supports multiple funding paths that may reduce or cover this cost: GSA MAS purchasing and government purchase orders, military credentialing funding (Army CA, AF COOL, CG COOL), VA GI Bill and VR&E, ATA Flexible Spending, and student financing. Private team cohorts are available if colleagues should attend with me.
Conclusion
This training provides practical, hands-on experience I can apply immediately to strengthen our work in business applications. Additional course information is available at https://appliedtechnologyacademy.com/microsoft-training/microsoft-access-for-office-365-part-1/.
Thank you for your consideration,
[Your Name]
Design training around your team, not the other way around.
Talk to a training advisor about private cohorts, funding paths and program management.