Course Details

Previous Page


Creating Relationships, Queries, Forms and Reports in Access 2016


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
Queries, being the heart of Access 2016, allows searching and extraction of information from tables for analysis. In this course, you'll learn how to set primary keys, forming relationships between objects in a database. In addition, this course demonstrates how to design forms and reports for data input, and how to present information in a neat and organized format. In addition, you will learn various methods of exporting and importing data using Access 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.

Prerequisites
None

Expected Duration (hours)
1.0

Lesson Objectives

Creating Relationships, Queries, Forms and Reports in Access 2016

  • start the course
  • outline the different types of relationships and when they should be applied in Access 2016
  • recognize the rules for creating relationships between tables in an Access 2016 database
  • choose a primary key from table fields and set relationships between tables in Access 2016
  • change form views and edit a form using Design View in Access 2016
  • apply blank forms and quick start templates to an Access 2016 database
  • modify data in a form in Access 2016
  • modify data on a form and delete form records in Access 2016
  • list the different query types available in Access 2016
  • create and run queries in Access 2016
  • create update, make table, and append queries in Access 2016
  • use the Total Column and the Query Setup features in Access 2016
  • modify and preview reports in Access 2016
  • export and import data in different file formats in Access 2016
  • set a relationship between fields, create a parameter query and report, and import data in Access 2016
  • Course Number:
    mo_beac_a02_dt_enus