acc_03 - Exploring Microsoft Access 2003 Chapter 3...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Exploring Office 2003 - Grauer and Barber 1 Committed to Shaping the Next Generation of IT Experts. Chapter 3 - Information From the Database: Reports and Queries Robert Grauer and Maryann Barber Modified by A. Clark (USA) Exploring Microsoft Access 2003
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Exploring Office 2003 - Grauer and Barber 2 Objectives Describe types of reports Describe similarities between forms and reports with respect to controls List sections in a report Use conditional formatting in a report Differentiate between a query and a table
Background image of page 2
Exploring Office 2003 - Grauer and Barber 3 Objectives (continued) Use design grid to create and modify a select query Explain multiple criteria rows in a query Use concatenation to combine fields Use an immediate If statement Define an action query Create a crosstab query
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Exploring Office 2003 - Grauer and Barber 4 Report Types Columnar (vertical) report Simplest type Lists every field for every record in a single column (one record per page) Tabular report Displays selected fields in a row One record per row
Background image of page 4
Exploring Office 2003 - Grauer and Barber 5 Report Wizard Easiest way to create a report Specify the table or query Select one or more fields Select layout (columnar/ tabular) Select a style Modify the resulting report
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/10/2012 for the course CIS 250 taught by Professor Wright during the Summer '09 term at S. Alabama.

Page1 / 27

acc_03 - Exploring Microsoft Access 2003 Chapter 3...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online