Access Chapter 03

Access Chapter 03 - MS Access Chapter 3 Chapter 3...

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

View Full Document Right Arrow Icon
MS Access Chapter 3 Carlotta Eaton Committed to Shaping the Next Generation of IT Experts. Chapter 3 Information From the Database: Reports and Queries Exploring Office 2003 - Grauer and Barber 2 Objectives z Describe types of reports z Describe similarities between forms and reports with respect to controls z List sections in a report z Use conditional formatting in a report z Differentiate between a query and a table z Use design grid to create and modify a select query z Explain multiple criteria rows in a query z Use concatenation to combine fields z Use an immediate If statement z Define an action query z Create a crosstab query Exploring Office 2003 - Grauer and Barber 3 Case Study: Citizen of the World z The case requires students to create 3 queries: z 20 countries with the highest population density in descending order z 20 largest countries by area z 20 largest countries by population Exploring Office 2003 - Grauer and Barber 4 Report Types z Columnar (vertical) report z Simplest type z Lists every field for every record in a single column (one record per page) z Tabular report z Displays selected fields in a row z One record per row
Background image of page 1

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

View Full DocumentRight Arrow Icon
MS Access Chapter 3 Carlotta Eaton Exploring Office 2003 - Grauer and Barber 5 Anatomy of a Report z Report header & footer z Page header & footer z Group header & footer z Detail section Exploring Office 2003 - Grauer and Barber 6 Report Wizard z Easiest way to create a report z Specify the table or query z Select one or more fields z Select layout (columnar/ tabular) z Select a style z Modify the resulting report Exploring Office 2003 - Grauer and Barber
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

Access Chapter 03 - MS Access Chapter 3 Chapter 3...

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

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