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


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


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.

Prerequisites
None

Expected Duration (hours)
1.1

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

    • Course Number:
    mo_beac_a01_dt_enus

    Expertise Level
    Beginner