Microsoft Office 2016 Access Intermediate Level 2 (091046)

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports.
    • Learning Style
      Virtual Instructor-Led
    • Difficulty
      Beginner
    • Course Duration
      1 Day
In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports.
Purchase For Teams
Team Pricing Available - Request A Quote Today!

  • Group Discounts & Private Training Available
  • Free Learning Management Center
  • Group Reporting & Tracking
  • Author / Publish Your Own Courses
  • Request Team Enrollment

Your training and experience using Microsoft® Access® 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Course Objectives

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Validate data entered into a database.
  • Use advanced queries to manipulate your data.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Customize reports to organize the displayed information and produce specific print layouts.


Audience

    This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports.

    \


Prerequisites

    To ensure your success, it is recommended you have completed Microsoft® Office Access® 2016: 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 either of the following courses, or any similar courses in general Microsoft Windows skills:

    • Using Microsoft® Windows® 10
    • Microsoft® Windows® 10: Transition from Windows® 7
    • Microsoft® Office Access® 2016: Part 1
More Information
Brand Microsoft
Lab Access No
Technology Microsoft
Learning Style Virtual Instructor-Led
Difficulty Beginner
Course Duration 1 Day
Language English
Write Your Own Review
You're reviewing:Microsoft Office 2016 Access Intermediate Level 2 (091046)
Your Rating