Office 2013 On Demand

15. Managing and Presenting Data with Access

What You’ll Do

Sort or Filter Out Records

Create Complex Filters Using Forms

Understand the Different Types of Queries

Create a Query Using a Wizard

Create a Query in Design View

Get Information with a Query

Modify a Query in Design View

Perform Calculations in Queries

Summarize Values with a Crosstab Query

Create a Parameter Query

Find Duplicate Fields

Create a Form

Work with a Form in Design View

Enter and Edit Data in a Form

Modify a Form

Create a Report

Modify a Report in Design View

Perform Calculations in Reports

Format a Form or Report

Group and Sort in Reports

Format a Datasheet

Change the Page Setup

Preview and Print Information

Introduction

Once you’ve created a database in Microsoft Access, ...