Creating relationships, queries, forms and reports in Access 2016

Overview

Queries, being the essence of Access 2016, allow you to search and retrieve information from tables for analysis. In this course, you will learn how to set master keys by forming relationships between objects in a database. In addition, this course demonstrates how to design data entry forms and reports and how to present information in an efficient 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 of SkillSoft learning pathways that cover Microsoft Access 2016 for beginners.

Objectives

• Highlight 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 master key from table fields and set relationships between tables in Access 2016
• Change views forms and editing a form using Design View in Access 2016
• applying blank forms and quick start templates to an Access 2016 database
• modifying data in an Access 2016 form
• modifying data in a form and deleting form records in Access 2016
• listing the different types of queries available in Access 2016
• creating and running queries in Access 2016
• creating updates, creating tables, and attaching queries in Access 2016
• using the Full Column and Query Setting features in Access 2016
• Modifying and previewing reports in Access 2016
• export and import data in various file formats in Access 2016