Microsoft Access for Office 365: Part 2 Training
Offered to the Jacksonville and Northeast Florida community through UNF Professional and Lifelong Learning in partnership with Applied Technology Academy — live online or in person, taught by ATA's practitioner instructors.
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)