Chapter 11. Queries, Forms, and Reports

  1. Joseph Schulman M.D., M.S.

Published Online: 11 JAN 2008

DOI: 10.1002/9780470757451.ch11

Managing Your Patients' Data in the Neonatal and Pediatric ICU: An Introduction to Databases and Statistical Analysis

Managing Your Patients' Data in the Neonatal and Pediatric ICU: An Introduction to Databases and Statistical Analysis

How to Cite

Schulman, J. (2008) Queries, Forms, and Reports, in Managing Your Patients' Data in the Neonatal and Pediatric ICU: An Introduction to Databases and Statistical Analysis, Blackwell Publishing Ltd, Oxford, UK. doi: 10.1002/9780470757451.ch11

Author Information

  1. Division of Newborn Medicine, Weill Medical College of Cornell University, New York-Presbyterian Hospital, New York, New York, 10021

Publication History

  1. Published Online: 11 JAN 2008
  2. Published Print: 1 JAN 2006

ISBN Information

Print ISBN: 9780727918703

Online ISBN: 9780470757451

SEARCH

Keywords:

  • queries;
  • reports;
  • subform;
  • subreport;
  • chart

Summary

The prelims comprise:

  • The Leszynski and Reddick naming convention

  • Queries

  • SQL: what goes on backstage in a query design grid

  • Query types

  • Updatable queries

  • Forms: overview

  • Forms: design details

  • A first look at VBA

  • Access is not omniscient

  • Nesting forms

  • The toolbox

  • Reports: overview

  • Reports: design details

  • Grouping

  • Macros