Access 2016 - Reports & Queries in pdf

Introduction

Microsoft Office Access 2016 allows people to effectively and efficiently organize data. This document has been developed to help you learn more about several useful features in Access including printing, applying queries, and importing Excel files. The various sections presented in this document will help you to build a solid knowledge foundation of the software.

The Microsoft Access Booklet Series will provide you the necessary knowledge on how to use Microsoft Office Access 2016. Before reading this booklet, it is recommended that you read the following Access 2016 documents on the UITS Documentation :

• Microsoft Access 2016 – Intro to Access
• Microsoft Access 2016 – Intro to Forms
• Microsoft Access 2016 – Relational Databases and Subforms

Learning Objectives

The following objectives are covered in this document:

• Creating reports and labels.
• Placing calculations on reports.
• Using the query feature.
• Importing an Excel file.