Course Code: 19314

Access for Office 365 Part 2

Class Dates:
1 Days
Class Time:
Instructor-Led Training, Virtual Instructor-Led Training


  • Course Overview
  • Course Objectives:

    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.
  • 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.


  • To ensure your success in this course, it is recommended you have completed Microsoft® Access® for Office 365™: Part 1

    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)

Course Details