Creating relationships, queries, forms and reports in Access 2016

Important to know:
The course video is English with Romanian subtitles and test questions are in Romanian.

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

Be the first to add a review.

Please, login to leave a review
Get Course
Enrolled: 13 students
Video: 00:50:28
Level: Introductory

Related Courses

Microsoft Access
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Access 2016 makes it ...
Introductory
€12.90
Microsoft Access
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Queries, being the essence of A...
Introductory
€12.90
Individual
Business
Partner

Register as Individual

For those who are individual learners, team members of a business, business professionals.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Register as Business

Business Leaders / HR Responsibilities / Other company representatives who want to upskill employees.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Register as Partner

For companies which want to colobrate with DB Academy and publish educational content for their customers.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Login

Authanticate to DB Academy.

{{this.errorMessage}}

{{this.successMessage}}

New to DB Academy?

Forgot your password?