Desktop Certifications     Microsoft     Microsoft Office Specialist (MOS) on Microsoft Office 2016     77-730: Access 2016 Core Database Management, Manipulation, and Query Skills

---

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 learning path that covers Microsoft Access 2016 for beginners.

---

---

Objectives

Introduction to Databases 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 Database Organization and Management 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 Building Tables 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 Practice: Creating Databases create and modify a database in Access 2016