Desktop Computer Skills
Microsoft Office 2016: Beginning Access
Creating Relationships, Queries, Forms and Reports in Access 2016
Introduction to the Access 2016 Interface, Database Management, and Tables

Creating Relationships, Queries, Forms and Reports in Access 2016

Course Number:
mo_beac_a02_dt_enus
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

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.

Creating Relationships, Queries, Forms and Reports in Access 2016

Course Number:
mo_beac_a02_dt_enus
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

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.

Introduction to the Access 2016 Interface, Database Management, and Tables

Course Number:
mo_beac_a01_dt_enus
Lesson Objectives

Introduction to the Access 2016 Interface, Database Management, and Tables

  • start the course
  • describe what a database is and the advantages of using a database for different purposes
  • distinguish between data and information and outline key considerations when structuring a database
  • identify new features in Access 2016
  • describe the Access 2016 interface
  • distinguish between database objects such as tables, queries, forms, and reports
  • open, create, and save databases in Access 2016
  • set various database options using the Access 2016 Backstage
  • create a table using Datasheet and Design view in Access 2016
  • switch table views and modify table fields in Access 2016
  • work with table fields and data using the Design and Datasheet view in Access 2016
  • modify table field properties in Access 2016
  • apply sort options and filter types when working with table data in Access 2016
  • create and modify a database in Access 2016

Overview/Description
Microsoft Access 2016 makes it easy to create professional databases for home, and business use. In this course, you'll learn about the new interface and key new features introduced in Access 2016. In addition, you will learn how to structure and construct a database design for a particular purpose. Included in this course is a section on adding, and modifying tables and table fields using different methods and views. 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.

Introduction to the Access 2016 Interface, Database Management, and Tables

Course Number:
mo_beac_a01_dt_enus
Lesson Objectives

Introduction to the Access 2016 Interface, Database Management, and Tables

  • start the course
  • describe what a database is and the advantages of using a database for different purposes
  • distinguish between data and information and outline key considerations when structuring a database
  • identify new features in Access 2016
  • describe the Access 2016 interface
  • distinguish between database objects such as tables, queries, forms, and reports
  • open, create, and save databases in Access 2016
  • set various database options using the Access 2016 Backstage
  • create a table using Datasheet and Design view in Access 2016
  • switch table views and modify table fields in Access 2016
  • work with table fields and data using the Design and Datasheet view in Access 2016
  • modify table field properties in Access 2016
  • apply sort options and filter types when working with table data in Access 2016
  • create and modify a database in Access 2016

Overview/Description
Microsoft Access 2016 makes it easy to create professional databases for home, and business use. In this course, you'll learn about the new interface and key new features introduced in Access 2016. In addition, you will learn how to structure and construct a database design for a particular purpose. Included in this course is a section on adding, and modifying tables and table fields using different methods and views. 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.

Close Chat Live