Microsoft®

Access®

2010 Training

Create reports for a new database

Course contents

• Overview: The end product

• Lesson: Includes eight sections

• Suggested practice tasks

• Test

• Quick Reference Card

Create reports for a new database

Course goals

• Create basic reports.

• Group and sort the data in a report.

• Add subtotals and other sums to a report.

• Create reports manually and with a wizard.

• Use Layout and Design views to change a

report.

Create reports for a new database

Group and sort data

Create reports for a new database

Grouping and sorting data in a report.

One of the more

powerful things you can

do in a report is group

and sort your data.

For example, if you want

to know which supplier

provided a given set of

computers, then

grouping your assets by

supplier can give you

that information quickly

and easily.

Group and sort data

Create reports for a new database

Grouping and sorting data in a report.

You can group tabular

or stacked reports.

Open your report in

Layout view, and on the

Design tab, in the

Grouping & Totals

group, click Group &

Sort. The

Group, Sort, and Total

pane appears below

your report.

1

2 In the pane, click Add a

group, and then select

the field by which you

want to group your data.

Access groups your data

to reflect your choice.

Group and sort data

Create reports for a new database

Grouping and sorting data in a report.

You can add 10

grouping levels to a

report, and you can sort

each level, if you need

to.

If you want to sort your

data, click Add a

sort, select a field, and

again Layout view shows

you your changes.

3

Suggestions for practice

1. Create a report with the Report tool.

2. Group and sort the report.

3. Add subtotals and grand totals to the report.

4. Use Design view to label your subtotals.

5. Add labels in Layout view.

6. Create a report from scratch.

7. Use the Report Wizard.

Create reports for a new database

Online practice (requires Access 2010)

Test question 1You can add as many as _____ levels of grouping to a report. (Pick one answer.)

Create reports for a new database

1. Seven.

2. Five.

3. Ten.

Test question 1

Create reports for a new database

You can also specify sums, counts, and sort orders for each

group.

You can add as many as _____ levels of grouping to a report.

Answer:

3. Ten.

Test question 2

All reports must contain which of the following? (Pick one answer.)

Create reports for a new database

1. A title section.

2. A date/time section.

3. A detail section.

4. A footnote section.

Test question 2

Create reports for a new database

All reports must have a detail section. They’re

meaningless, otherwise.

All reports must contain which of the following?

Answer:

3. A detail section.

Test question 3You can add controls to a report when working in Design view.(Pick one answer.)

Create reports for a new database

1. True.

2. False.

Test question 3

Create reports for a new database

You can add dates and times, logos, check boxes, and more.

You can add controls to a report when working in Design view.

Answer:

1. True.

Test question 4The important thing to remember when designing reports is: (Pick one answer.)

Create reports for a new database

1. They must be clear and easy to understand.

2. They must contain a date and time.

3. They must group data in some way.

4. They must use all the available report sections.

Test question 4

Create reports for a new database

You can include as few or as many elements as you need to

make the information clear.

The important thing to remember when designing reports is:

Answer:

1. They must be clear and easy to understand.

Quick Reference Card

For a summary of the tasks covered in this course, view the Quick Reference Card.

Create reports for a new database