Microsoft Access for Office 365: Part 2 Training
Your training and experience using Microsoft® Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access ® will result in a robust, functional database for your users.
Microsoft® Access® for Office 365™: Part 2
Course Objectives
This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access®. In this course, you will optimize an Access® database.
You will:
- Provide input validation features to promote the entry of quality data into a database
- Organize a database for efficiency and performance, and to maintain data integrity
- Improve the usability of Access® tables
- Create advanced queries to join and summarize data
- Use advanced formatting and controls to improve form presentation
- Use advanced formatting and calculated fields to improve reports
Course Outline
- Lesson 1: Promoting Quality Data Input
- Restrict Data Input Through Field Validation
- Restrict Data Input Through Forms and Record Validation
- Lesson 2: Improving Efficiency and Data Integrity
- Data Normalization
- Associate Unrelated Tables
- 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
- Create Query Joins
- Create Subqueries
- Summarize Data
- Lesson 5: Improving Form Presentation
- Apply Conditional Formatting
- Create Tab Pages with Subforms and Other Controls
- Lesson 6: Creating Advanced Report
- Apply Advanced Formatting to a Report
- Add a Calculated Field to a Report
- Control Pagination and Print Quality
- Add a Chart to a Report
Intended Audience
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft® Access® for Microsoft 365™.
Prerequisites
To ensure your success in this course, it is recommended you have completed Microsoft® Access® for Office 365™: Part 1 or possess equivalent knowledge.
It is also suggested that you 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 the following Logical Operations course, or any similar courses in general Microsoft Windows® skills:
Using Microsoft Windows® 10 (Second Edition)
Follow-On Courses
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 2 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
Your training and experience using Microsoft® Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access ® will result in a robust, functional database for your users. 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 be able to:
- This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access®. In this course, you will optimize an Access® database.
- You will:
- Provide input validation features to promote the entry of quality data into a database
- Organize a database for efficiency and performance, and to maintain data integrity
- Improve the usability of Access® tables
- Create advanced queries to join and summarize data
- Use advanced formatting and controls to improve form presentation
- Use advanced formatting and calculated fields to improve reports
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-2/.
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.