Creating Relationships, Queries, Forms and Reports in Access 2016

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.

Prerequisite
None

Expected Duration
60 minutes

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.

Objective

Setting Relationships

  • 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

Building Forms

  • 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

Construct Queries

  • 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

Designing Reports

  • modify and preview reports in Access 2016

Import and Export

  • export and import data in different file formats in Access 2016

Practice: Working with Queries

  • set a relationship between fields, create a parameter query and report, and import data in Access 2016

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.