Creating Relationships, Queries, Forms and Reports in Access 2016

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

---

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

Expertise Level
Intermediate