Introduction to the Access 2016 interface, Database Management and Tables

Overview

Microsoft Access 2016 makes it easy to create professional databases for home and office use. In this course, you will learn about the new interface and the new main features introduced in Access 2016. In addition, you will learn how to structure and build a database model for a specific purpose. This course includes a section for adding and modifying tables and table fields using different methods and views. This course is one of a series of SkillSoft learning pathways covering Microsoft Access 2016 for beginners.

Objectives

• to describe a database and the advantages of using a database for different purposes
• to differentiate between data and information and to highlight the main considerations when structuring a database
• to identify new functions in Access 2016
• to describe the Access 2016 interface
• to differentiate between objects databases such as tables, queries, forms and reports
• opening, creating and saving databases in Access 2016
• setting various database options using the Access 2016 Background function
• creating a table using the Access Data and Design tab view in Access 2016
• switching table views and changing table fields in Access 2016
• working with table fields and data using Design and Datasheet view in Access 2016
• changing table field properties in Access 2016
• applying sorting options and filter types when working with data tables in Access 2016