Productivity & Collaboration Tools     Microsoft Office 2016     Access 2016     Microsoft Office 2016: Beginning Access

---

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

---

---

Objectives

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