Core Concepts of Accounting Information Systems, 12th Edition

Chapter 5

Database Forms and Reports

INTRODUCTION

FORMS

Creating Simple Forms

Using Forms for Input and Output Tasks

Subforms—Showing Data from Multiple Tables

Concluding Remarks About Forms

REPORTS

Creating Simple Reports

Creating Reports with Calculated Fields

Creating Reports with Grouped Data

Concluding Remarks About Reports

AIS AT WORK—MOTHER LODE BICYCLES

SUMMARY

KEY TERMS YOU SHOULD KNOW

TEST YOURSELF

DISCUSSION QUESTIONS

PROBLEMS

CASE ANALYSES

A Form for BSN Suppliers (Creating a Simple Form in Access)

A Form and Subform for BSN Suppliers (Creating Forms with Subforms in Access)

A Listing of BSN Suppliers (Creating Simple Reports in Access)

Furry Friends Foundation III (Creating Forms and Reports)

READINGS AND OTHER RESOURCES

ANSWERS TO TEST YOURSELF

After reading this chapter, you will:

1. Understand how to create simple forms in Access.

2. Understand the difference between a bound control and an unbound control on an Access form or report.

3. Know how to create advanced forms in Access with subforms.

4. Understand how to create simple reports in Access.

5. Know how to create reports based on queries.

6. Know how to create reports that contain calculated fields and understand why databases do not store such fields in their tables.

Technical skills are an accountant’s best friend nowadays. It should be self-evident as to why. Data. Data. Data.

Devereaux, G. 2010. An argument for techie accountants. Going Concern.¹

INTRODUCTION

The previous chapters illustrated how ...